public function __construct(CDatabaza $db) { parent::__construct($db); $sql = "SELECT \n Clanok.clanok_id AS id,\n Clanok.nazov_clanku AS name,\n Typ_clanku.nazov AS type,\n Rubrika.nazov_rubriky AS topic,\n Clanok.casova_znamka AS timestamp\n FROM \n (Clanok\n INNER JOIN\n Rubrika\n ON Clanok.rubrika_id=Rubrika.rubrika_id)\n INNER JOIN\n Typ_clanku\n ON Clanok.typ_clanku_id=Typ_clanku.typ_clanku_id\n WHERE\n Clanok.zobrazit=1\n ORDER BY Clanok.casova_znamka DESC\n LIMIT 0,10"; $news_recs = $db->query($sql); while ($news = $news_recs->fetch_array()) { $id = $news['id']; $this->news[$id]['id'] = $id; $this->news[$id]['name'] = $news['name']; $this->news[$id]['type'] = $news['type']; $this->news[$id]['topic'] = $news['topic']; $this->news[$id]['day'] = date("j.n.Y", $news['timestamp']); $this->news[$id]['time'] = date("h:i:s", $news['timestamp']); } }
public function __construct(CDatabaza $db) { parent::__construct($db); $sql = "SELECT * FROM Tema ORDER BY tema_id"; $temy = $db->query($sql); while ($tema = $temy->fetch_array()) { $this->menu[$tema['tema_id']]['id'] = $tema['tema_id']; $this->menu[$tema['tema_id']]['nazov'] = $tema['nazov_temy']; $sql = "SELECT * FROM Rubrika WHERE tema_id='" . $tema['tema_id'] . "'\n ORDER BY rubrika_id"; $rubriky = $db->query($sql); while ($rubrika = $rubriky->fetch_array()) { $this->menu[$rubrika['tema_id']]['rubriky'][$rubrika['rubrika_id']]['id'] = $rubrika['rubrika_id']; $this->menu[$rubrika['tema_id']]['rubriky'][$rubrika['rubrika_id']]['nazov'] = $rubrika['nazov_rubriky']; } } }
public function __construct(CDatabaza $db) { parent::__construct($db); if (empty($_GET['rubrika'])) { $this->exit_program(); } $this->page = 0; if (!empty($_GET['strana'])) { $this->page = $_GET['strana'] - 1; } $this->num_on_page = 10; $topic = $db->escape_string($_GET['rubrika']); $sql = "SELECT * FROM Rubrika WHERE rubrika_id=" . $topic; $topics = $db->query($sql); $topic_data = $topics->fetch_array(); if (!$topic_data) { $this->exit_program(); } $this->topic = $topic_data['nazov_rubriky']; $sql = "SELECT COUNT(clanok_id) AS num_pages FROM Clanok WHERE Clanok.zobrazit=1 AND Clanok.rubrika_id=" . $topic; $num_pages = $db->query($sql)->fetch_array(); $this->num_of_pages = ceil($num_pages['num_pages'] / $this->num_on_page); if ($this->page < 0) { $this->page = 0; } if ($this->page > $this->num_of_pages) { $this->page = $this->num_of_pages - 1; } $start_record = $this->page * $this->num_on_page; $sql = "SELECT\n Clanok.clanok_id AS id,\n Clanok.nazov_clanku AS name,\n Clanok.casova_znamka AS timestamp,\n Clanok.typ_clanku_id AS type\n FROM\n Clanok\n WHERE\n Clanok.zobrazit=1 AND Clanok.rubrika_id=" . $topic . "\n ORDER BY Clanok.casova_znamka DESC\n LIMIT {$start_record},{$this->num_on_page}"; $articles = $db->query($sql); while ($art = $articles->fetch_array()) { $id = $art['id']; $this->articles[$id]['id'] = $id; $this->articles[$id]['name'] = $art['name']; $this->articles[$id]['type'] = $art['type']; $this->articles[$id]['day'] = date("j.n.Y", $art['timestamp']); if ($art['type'] == 3) { $this->readPost($db, $id); } } }
public function __construct(CDatabaza $db, $home) { parent::__construct($db); if (empty($_GET['clanok'])) { $this->exit_program(); } $article = $db->escape_string($_GET['clanok']); $sql = "SELECT\n Clanok.clanok_id AS id,\n Clanok.nazov_clanku AS name,\n Clanok.typ_clanku_id AS type,\n Clanok.casova_znamka AS timestamp,\n Clanok.rubrika_id AS topic_id\n FROM\n Clanok \n WHERE\n Clanok.clanok_id={$article}\n AND\n Clanok.zobrazit=1"; $articles = $db->query($sql); $info = $articles->fetch_array(); if (!$info) { $this->exit_program(); } $this->info['id'] = $info['id']; $this->info['name'] = $info['name']; $this->info['date'] = date("j.n.Y", $info['timestamp']); $sql = "SELECT Rubrika.nazov_rubriky AS topic,\n Tema.nazov_temy AS theme\n FROM\n Rubrika\n INNER JOIN\n Tema\n ON Rubrika.tema_id=Tema.tema_id\n WHERE Rubrika.rubrika_id=" . $info['topic_id']; $top_nfo = $db->query($sql); $top_nfo_data = $top_nfo->fetch_array(); $this->topic['topic'] = $top_nfo_data['topic']; $this->topic['theme'] = $top_nfo_data['theme']; $this->topic['id'] = $info['topic_id']; $this->set_program($info['type'], $home); $sql = "SELECT \n Uzivatel_info.uzivatel_id AS id,\n Uzivatel_info.meno AS name,\n Uzivatel_info.priezvisko AS surname,\n Uzivatel_info.trieda AS class\n FROM\n Uzivatel_info\n INNER JOIN\n Clanok_uzivatel\n ON Uzivatel_info.uzivatel_id=Clanok_uzivatel.uzivatel_id\n WHERE\n Clanok_uzivatel.clanok_id={$article}"; $users = $db->query($sql); while ($user = $users->fetch_array()) { $id = $user['id']; $this->users[$id]['name'] = $user['name']; $this->users[$id]['surname'] = $user['surname']; $class = $user['class']; if ($class) { $i = strpos($class, "."); $this->users[$id]['year'] = substr($class, 0, $i); } } }