public function getPages()
{
if (empty(self::$conn)) {
self::$conn = $this->connect_pdo();
}
$sql = "SELECT p.id,p.name,p.des,p.image_icon,p.time_on,author_id,CONCAT_WS(' ',first_name,last_name) AS user_name\n\t\t\t\t\tFROM pages AS p\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\tORDER BY p.time_on DESC limit 3";
$stmt = self::$conn->query($sql);
$pages = array(array());
$i = 0;
while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
$pages[$i++] = $row;
}
$i--;
return $pages;
}
