<?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 -->
