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;
}
}
