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'];
}
