public function getPages($menu_id) { if (empty(self::$conn)) { self::$conn = $this->connect_pdo(); } $sql = "SELECT p.id,p.name,p.des,p.image_icon,p.des,p.time_on,CONCAT_WS(' ',first_name,last_name) AS user_name,p.author_id\n\t\t\t\t\tFROM pages AS p \n\t\t\t\t\tLEFT JOIN page_menu AS pmn\n\t\t\t\t\t\tON p.id=pmn.page_id \n\t\t\t\t\tLEFT JOIN users AS u\n\t\t\t\t\t\tON u.id=p.author_id\n\t\t\t\t\tWHERE pmn.menu_id =?"; $stmt = self::$conn->prepare($sql); $stmt->bindParam(1, $menu_id); $stmt->execute(); $stmt->setFetchMode(PDO::FETCH_ASSOC); $i = 0; $pages = array(array()); while ($row = $stmt->fetch()) { $pages[$i++] = $row; } $i--; return $pages; }
public function delete($id) { // Connect to database ... if (empty(self::$conn)) { self::$conn = $this->connect_pdo(); } $stmt = self::$conn->prepare('DELETE FROM menu WHERE id=?'); $stmt->bindParam(1, $id); if ($stmt->execute()) { return true; } else { return false; } }