'SET NAMES \'UTF8\'')); if ($type == "getnum") { $sql2 = "SELECT count(id) FROM `articles`"; $query2 = $pdo->prepare($sql2); $query2->execute(); $res2 = $query2->fetch(PDO::FETCH_NUM); echo $res2['0']; } if (($type == "next") || ($type == "prev")) { $id = $_GET['data']; $max = $id + 5; $sql = "SELECT * FROM `articles` WHERE `id` BETWEEN :idmin AND :idmax ORDER BY `created_at` DESC LIMIT 5"; $query = $pdo->prepare($sql); $query->execute(array(':idmin' => $id, ':idmax' => $max)); $res = $query->fetchAll(PDO::FETCH_ASSOC); foreach ($res as $r) { echo "

".$r['title']."

". "

".$r['content'] . "

" . "Napsal: " . $r['author'] . " " . $r['created_at'] . "

"; } } ?>