Файл: category.php
Строк: 17
<?php
include $_SERVER['DOCUMENT_ROOT'].'/incs/system.php';
include $_SERVER['DOCUMENT_ROOT'].'/incs/classes/pagination_class.php';
$paging = new Paging($db);
$id = (int) $_GET['id'];
$array = array();
$isset = $db->query("SELECT COUNT(`id`) AS `c` FROM `categories` WHERE `id` = '$id' LIMIT 1")->fetch_assoc();
if($isset['c'] < 1) {
header("Location: /");
exit();
}
$sql = $paging->get_page("SELECT * FROM `projects` WHERE `cat_id` = '$id'", "ORDER BY id DESC");
while($row = $sql->fetch_assoc()) {
$array[] = $row;
}
if($sql->num_rows < 1 && (empty($empty))) {
$empty = 'В этой категории проектов нет';
}
$pages = $paging->get_page_links('/category/'.$id);
echo $view->render('category.tpl', array(
'title' => 'Список работ',
'array' => $array,
'pages' => $pages
));