Файл: index.php
Строк: 11
<?php
include $_SERVER['DOCUMENT_ROOT'].'/incs/system.php';
$array = array();
$empty = NULL;
$sql = $db->query("SELECT c.name, c.id, COUNT(p.cat_id) AS cnt FROM `categories` AS c LEFT JOIN projects AS p ON p.cat_id = c.id GROUP BY c.name");
while($row = $sql->fetch_assoc()) {
$array[] = $row;
}
if($sql->num_rows < 1) {
$empty = 'Категории еще не созданы';
}
$re = $db->query("SELECT COUNT(`id`) AS `cnt` FROM `reviews`")->fetch_assoc();
echo $view->render('index.tpl', array(
'title' => 'Портфолио',
'reviews' => $re['cnt'],
'array' => $array,
'empty' => $empty
));
?>