public function __construct($id, CDatabaza $db) { $this->article = $id; $sql = "SELECT Kategoria.kategoria_id AS id, Kategoria.nazov_kategorie AS name FROM \n (Kategoria\n INNER JOIN\n Prispevok\n ON Prispevok.kategoria_id=Kategoria.kategoria_id)\n INNER JOIN\n Clanok\n ON\n Clanok.clanok_id=Prispevok.clanok_id\n WHERE \n Clanok.clanok_id={$id} \n AND\n Clanok.zobrazit=1\n AND\n Prispevok.zobrazit=1"; $cats_data = $db->query($sql); if ($cats_data) { while ($cats = $cats_data->fetch_array()) { $idc = $cats['id']; $this->cats[$idc]['id'] = $idc; $this->cats[$idc]['name'] = $cats['name']; } } else { echo "nastala chyba v spojeni"; } $post_select = "SELECT Prispevok.prispevok_id AS id,\n Prispevok.nazov_prispevku AS name,\n Prispevok.prispevok AS post,\n Prispevok.casova_znamka AS timestamp,\n Prispevok.kategoria_id AS cat"; $num_rows = "SELECT Count(*) AS num"; $from_stat = " FROM\n Prispevok\n INNER JOIN\n Clanok\n ON Prispevok.clanok_id=Clanok.clanok_id\n WHERE\n Clanok.zobrazit=1\n AND \n Clanok.clanok_id={$id}\n AND\n Prispevok.zobrazit=1"; if (isset($_GET['kategoria'])) { $cat_exists = false; foreach ($this->cats as $cat) { if ($cat['id'] = $_GET['kategoria']) { $cat_exists = true; break; } } if ($cat_exists) { $from_stat .= " AND Prispevok.kategoria_id=" . $_GET['kategoria']; } } $sql = $num_rows . $from_stat; $num_on_page = 10; $this->max_page = ceil($db->query($sql)->num_rows / $num_on_page); $this->page = 0; if (empty($_GET['strana'])) { if ($_GET['strana'] > 0 && $_GET['strana'] <= $this->max_page) { $this->page = $_GET['strana'] - 1; } } $sql = $post_select . $from_stat . " ORDER BY Prispevok.casova_znamka DESC LIMIT " . $this->page * $num_on_page . ",{$num_on_page}"; $post_data = $db->query($sql); if ($post_data) { while ($post = $post_data->fetch_array()) { $id = $post['id']; $this->posts[$id]['id'] = $id; $this->posts[$id]['name'] = $post['name']; $this->posts[$id]['post'] = $post['post']; $this->posts[$id]['day'] = date("j.n.Y", $post['timestamp']); $this->posts[$id]['cat'] = $post['cat']; } } }
public function __construct(CDatabaza $data, $user = null) { $user_id = ""; if ($user == null) { if (empty($_SESSION['user'])) { return; } $user_id = $_SESSION['user']; } else { $user_id = $user; } //ziska informacie z databazy $connected = $data->connected(); if (!$connected) { $data->connect(); } if (!$data->connected()) { return; } $sql = "SELECT pristupove_prava FROM Uzivatel WHERE uzivatel_id='{$user_id}'"; $query = $data->query($sql); $result = mysqli_fetch_array($query); $user_rights = explode(",", $result['pristupove_prava']); //nacita udaje z databazy a ulozi ich do premennej $rights for ($i = 0; isset($user_rights[$i]); $i++) { $res = $user_rights[$i]; $res = trim($res); $this->rights[$res] = true; } if (!$connected) { $data->close(); } }
private function readPost(CDatabaza $db, $id) { $sql = "SELECT prispevok FROM Prispevok WHERE clanok_id={$id} ORDER BY casova_znamka DESC LIMIT 0,1"; $query = $db->query($sql); $post = $query->fetch_array(); $this->articles[$id]['post'] = $post['prispevok']; }