<?php header("Content-type: text/xml"); require_once "config.php"; $a = Tekst::getSomething("id,naslov,datum,kategorija"); $xml = new SimpleXMLElement("<biblioteka />"); foreach ($a as $b) { $tekst = $xml->addChild("tekst"); $tekst->addAttribute("id", $b->id); foreach ($b as $k => $v) { if ($k == "id") { continue; } $tekst->addChild($k, $v); } } echo $xml->asXML("tekstovi.xml");
echo $date->format('d.m.Y'); ?> | <?php echo $koment->broj === "1" ? $koment->broj . " komentar" : $koment->broj . " komentara"; ?> </span> </div> </li> <?php } ?> </ul> <ul id="najcitanije"> <?php $side = Tekst::getSomething("id,naslov,datum", "order by datum DESC limit 4"); foreach ($side as $text) { $date = new DateTime($text->datum); $naslov = Functions::titleSanitize($text->naslov); $q = $conn->query("select count(komentar_id) as broj,tekst_id from komentari where tekst_id={$text->id} and status<>0"); $koment = $q->fetchObject(); ?> <li class="news"> <div class="news_img"> <a href="<?php echo $naslov; ?> "> <img src="images/small/<?php echo $naslov . ".jpeg"; ?>
<li><a href="index.php">HOME</a></li> <li><a href="?a=teretane" id="teretane">TERETANE</a></li> <li><a href="?art=4">BLOG</a></li> <li><a href="takmicari.php">TAKMIČARI</a></li> </ul> </nav> <div id="sidebar_news"> <div id="sidebar_news_nav"> <button class="najnovije">Najnovije</button> <button class="najcitanije">Najčitanije</button> <button class="komentari">Komentari</button> </div><!-- end of #sidebar_news_nav --> <div id="sidebar_news_main"> <ul> <?php $side = Tekst::getSomething("id,naslov,datum", "limit 4"); $db = Singleton::getInstance(); $conn = $db->conn; foreach ($side as $text) { $date = new DateTime($text->datum); $naslov = Functions::titleSanitize($text->naslov); $q = $conn->query("select count(komentar_id) as broj,tekst_id from komentari where tekst_id={$text->id} and status<>0"); $koment = $q->fetchObject(); ?> <li class="news"> <div class="news_img"> <a href="<?php echo $naslov; ?> "> <img src="images/small/<?php
<div id="banner"> <div id="slider"> <?php $banner = Tekst::getSomething("id,naslov", "order by rand() limit 4"); foreach ($banner as $row) { $naslov = $row->naslov; $naslovSanitize = Functions::titleSanitize($naslov); ?> <div> <a href="<?php echo $naslov; ?> "> <img src="images/main/<?php echo $naslovSanitize . ".jpeg"; ?> "/> </a> <div class="text"><a href="<?php echo $naslov; ?> "><?php echo $naslov; ?> </a> </div> </div> <?php } ?> </div> <!-- end of #slider -->