-
-
Save Adamwaheed/9b9179648959866277a3b6f55065f172 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <?php | |
| include_once 'Db.php'; | |
| class Post | |
| { | |
| /* Fetch All */ | |
| public function readData() | |
| { | |
| try { | |
| $dao = new Db(); | |
| $conn = $dao->openConnection(); | |
| $sql = "SELECT * FROM post ORDER BY id DESC"; | |
| $resource = $conn->query($sql); | |
| $result = $resource->fetchAll(PDO::FETCH_ASSOC); | |
| $dao->closeConnection(); | |
| } catch (PDOException $e) { | |
| echo "There is some problem in connection: " . $e->getMessage(); | |
| } | |
| if (! empty($result)) { | |
| return $result; | |
| } | |
| } | |
| /* Fetch Single Record by Id */ | |
| public function readSingle($id) | |
| { | |
| try { | |
| $dao = new Db(); | |
| $conn = $dao->openConnection(); | |
| $sql = "SELECT id,title,description, url, category FROM `tb_links` WHERE id=" . $id . " ORDER BY id DESC"; | |
| $resource = $conn->query($sql); | |
| $result = $resource->fetchAll(PDO::FETCH_ASSOC); | |
| $dao->closeConnection(); | |
| } catch (PDOException $e) { | |
| echo "There is some problem in connection: " . $e->getMessage(); | |
| } | |
| if (! empty($result)) { | |
| return $result; | |
| } | |
| } | |
| /* Add New Record */ | |
| public function add($formArray) | |
| { | |
| $title = $_POST['title']; | |
| $description = $_POST['description']; | |
| $url = $_POST['url']; | |
| $category = $_POST['category']; | |
| $dao = new Db(); | |
| $conn = $dao->openConnection(); | |
| $sql = "INSERT INTO `tb_links`(`title`, `description`, `url`, `category`) VALUES ('" . $title . "','" . $description . "','" . $url . "','" . $category . "')"; | |
| $conn->query($sql); | |
| $dao->closeConnection(); | |
| } | |
| /* Edit a Record */ | |
| public function edit($formArray) | |
| { | |
| $id = $_POST['id']; | |
| $title = $_POST['title']; | |
| $description = $_POST['description']; | |
| $url = $_POST['url']; | |
| $category = $_POST['category']; | |
| $dao = new Db(); | |
| $conn = $dao->openConnection(); | |
| $sql = "UPDATE tb_links SET title = '" . $title . "' , description='" . $description . "', url='" . $url . "', category='" . $category . "' WHERE id=" . $id; | |
| $conn->query($sql); | |
| $dao->closeConnection(); | |
| } | |
| /* Delete a Record */ | |
| public function delete($id) | |
| { | |
| $dao = new Db(); | |
| $conn = $dao->openConnection(); | |
| $sql = "DELETE FROM `tb_links` where id='$id'"; | |
| $conn->query($sql); | |
| $dao->closeConnection(); | |
| } | |
| } | |
| ?> |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment