Viewing file: funkcije.inc.php (14 KB) -rwxr-xr-x Select action/file-type: (+) | (+) | (+) | Code (+) | Session (+) | (+) | SDB (+) | (+) | (+) | (+) | (+) | (+) |
<?
function meni ()
{
$result = mysql_query ("SELECT id,title FROM topics_web WHERE meni=1");
if ($row = mysql_fetch_array($result)) {
print "<table width=\"100%\">";
do {
$nivo=$row[id];
print "<tr><td><font size=\"1\" face=\"Arial\" color=\"#FFFFFF\">";
print "<a href=\"index.php?akcija=topic&no=$nivo\">";
print $row[title];
print "</a>";
print "</font></td></tr>";
} while($row = mysql_fetch_array($result));
print "</table>";
} else {}
}
function glavna ()
{
$result = mysql_query ("SELECT ID,title,substring(details,1,300) as details,date,imageID FROM news where topicID=13 ORDER BY ID desc LIMIT 1");
print ("<table>");
if ($row = mysql_fetch_array($result)) {
do {
$no=$row["ID"];
$imageID=$row["imageID"];
print ("<tr>");
print ("<td colspan=\"2\">");
print ("<font face=\"arial\"><font size=\"2\"><font color=\"Black\"><b>");
print $row["title"];
print ("</font></b><br>");
print ("</td> ");
print ("</tr>");
print ("<tr>");
print ("<td>");
print ("<img border=\"1\" src=\"imageShow.php3?id=$imageID\">");
print ("</td>");
print ("<td>");
print ("<font face=\"arial\"><font size=\"1\"><font color=\"Black\">");
print $row["details"];
print ("</font>");
print ("...");
print ("<font size=\"1\"><font color=\"Navy\"><a href=\"index.php?akcija=clanak&idvijesti=$no\">");
print (" >> Opsirnije >>");
print ("</a></font>");
print ("</td>");
print ("</tr>");
} while($row = mysql_fetch_array($result));
print ("</table>");
} else {print "Nema clanaka!";}
}
function tvprogram ()
{
$result = mysql_query ("SELECT idrubrike,nazivrubr FROM rubrike WHERE pripada=27 ");
print "<table width=\"100%\">";
if ($row = mysql_fetch_array($result)) {
do {
$nivo=$row[idrubrike];
print "<tr><td bgcolor=\"#BFEC7D\"><b><font size=\"1\" face=\"Verdana\" color=\"#FFFFFF\"><font size=\"1\" face=\"Verdana\"><b>";
print "<a href=\"index.php?akcija=tvprogram&idtv=$nivo\">";
print $row[nazivrubr];
print "</b></font></a></td></tr>";
} while($row = mysql_fetch_array($result));
print "</table>";
} else {}
}
function prva ()
{
$result = mysql_query ("SELECT idvijesti,naslov,datum,slika,substring(tekst,1,200) as tekst FROM informacije where prvastr=1 order by idvijesti desc limit 11");
if ($row = mysql_fetch_array($result)) {
do {
$slika=$row["slika"];
$no=$row["idvijesti"];
print ("<font face=\"verdana\"><font size=\"1\"><font color=\"Black\"><b>");
print $row["naslov"];
print ("</font></b><br><br>");
print (" ");
echo slika ($slika);
print ("<font face=\"verdana\"><font size=\"1\"><font color=\"Black\">");
print $row["tekst"];
print ("</font>");
print "<a href=\"index.php?akcija=clanak&idvijesti=$no\">";
print " >>Opsirnije>> ";
print "</a>";
print ("<br>");
print ("<br>");
} while($row = mysql_fetch_array($result));
} else {}
}
function sekcije ($topicId, $broj)
{
print ("<table>");
mysql_connect (localhost, us10505a, proba);
mysql_select_db (db10505p);
$result = mysql_query ("SELECT ID,title,imageID,substring(details,1,200) as details FROM news where topicID=$topicId ORDER BY ID desc LIMIT 1");
if ($row = mysql_fetch_array($result)) {
do {
$imageID=$row["imageID"];
print ("<tr>");
print ("<td colspan=\"2\">");
print ("<font face=\"arial\"><b><font size=\"2\"><font color=\"Black\">");
print $row["title"];
print ("</font></b>");
print ("</td>");
print ("</tr>");
print ("<tr>");
print ("<td valign=\"top\" colspan=\"2\">");
print ("<img border=\"1\" width =\"80\" height =\"80\" align=\"left\" src=\"imageShow.php3?id=$imageID\">");
print ("<font face=\"arial\"><font size=\"1\"><font color=\"Black\">");
print $row["details"];
print ("</font>");
print ("...");
print ("<font size=\"1\"><font color=\"Navy\"><a href=\"index.php?akcija=clanak&idvijesti=$no\">");
print (" >> Opsirnije >>");
print ("</a></font>");
print ("</td>");
print ("</tr>");
}
while($row = mysql_fetch_array($result));
}
$result = mysql_query ("SELECT ID,title FROM news where topicID=$topicId ORDER BY ID desc LIMIT $broj");
if ($row = mysql_fetch_array($result)) {
do {
$no=$row["ID"];
print ("<tr>");
print ("<td valign=\"top\">");
print ("<img border=\"0\" src=\"tacka.jpg\" >");
print ("</td>");
print ("<td valign=\"top\">");
print ("<font face=\"arial\"><font size=\"1\"><font color=\"Black\"><a href=\"index.php?akcija=clanak&idvijesti=$no\">");
print $row["title"];
print ("</a></font>");
print ("</td>");
print ("</tr>");
}
while($row = mysql_fetch_array($result));
}
print ("</table>");
}
function clanak($idvijesti){
$result = mysql_query ("SELECT ID,title,details,date,imageID,topicID FROM news where id=$idvijesti ");
if ($row = mysql_fetch_array($result)) {
$idrubrike=$row["topicID"];
do {
$time=$row["date"];
$no=$row["Id"];
$imageID=$row["imageID"];
print ("<font face=\"arial\"><font size=\"1\"><font color=\"Black\">");
print $time;
print ("</font><br>");
print ("<font face=\"arial\"><font size=\"1\"><font color=\"Black\"><b>");
print $row["title"];
print ("</font></b><br><br>");
print (" ");
print ("<img border=\"1\" align=\"left\" src=\"imageShow.php3?id=$imageID\">");
print ("<font face=\"arial\"><font size=\"1\"><font color=\"Black\">");
$cl=nl2br($row["details"]);
print $cl;
print ("</font>");
print ("<br>");
print ("<br>");
} while($row = mysql_fetch_array($result));
} else {}
print "<b>Ostale informacije u ovoj sekciji</b>";
print "<br>";
print "<br>";
print ("<table>");
$result = mysql_query ("SELECT ID,title FROM news where topicID=$idrubrike ORDER BY ID desc LIMIT 15");
if ($row = mysql_fetch_array($result)) {
do {
$no=$row["ID"];
print ("<tr>");
print ("<td valign=\"top\">");
print ("<img border=\"0\" src=\"tacka.jpg\" >");
print ("</td>");
print ("<td valign=\"top\">");
print ("<font face=\"arial\"><font size=\"1\"><font color=\"Black\"><a href=\"index.php?akcija=clanak&idvijesti=$no\">");
print $row["title"];
print ("</font></a>");
print ("</td>");
print ("</tr>");
}
while($row = mysql_fetch_array($result));
}
print ("</table>");
}
function rubrike ($idrubrike)
{
$result = mysql_query ("SELECT ID,title,details,date,imageID,topicID FROM news where topicID=$idrubrike order by Id desc limit 5");
if ($row = mysql_fetch_array($result)) {
$idrubrike=$row["topicID"];
do {
$time=$row["date"];
$no=$row["Id"];
$imageID=$row["imageID"];
print ("<font face=\"arial\"><font size=\"1\"><font color=\"Black\">");
print $time;
print ("</font><br>");
print ("<font face=\"arial\"><font size=\"1\"><font color=\"Black\"><b>");
print $row["title"];
print ("</font></b><br><br>");
print (" ");
print ("<img border=\"1\" align=\"left\" src=\"imageShow.php3?id=$imageID\">");
print ("<font face=\"arial\"><font size=\"1\"><font color=\"Black\">");
$cl=nl2br($row["details"]);
print $cl;
print ("</font>");
print ("<br>");
print ("<br>");
} while($row = mysql_fetch_array($result));
} else {}
print "<b>Ostale informacije u ovoj sekciji</b>";
print "<br>";
print "<br>";
print ("<table>");
$result = mysql_query ("SELECT ID,title FROM news where topicID=$idrubrike ORDER BY ID desc LIMIT 15");
if ($row = mysql_fetch_array($result)) {
do {
$no=$row["ID"];
print ("<tr>");
print ("<td valign=\"top\">");
print ("<img border=\"0\" src=\"tacka.jpg\" >");
print ("</td>");
print ("<td valign=\"top\">");
print ("<font face=\"arial\"><font size=\"1\"><font color=\"Black\"><a href=\"index.php?akcija=clanak&idvijesti=$no\">");
print $row["title"];
print ("</font></a>");
print ("</td>");
print ("</tr>");
}
while($row = mysql_fetch_array($result));
}
print ("</table>");
}
function program($idtv){
$result4 = mysql_query ("SELECT idvijesti,naslov,tekst,datum,slika FROM informacije where rubrika=$idtv order by idvijesti desc limit 7");
if ($row = mysql_fetch_array($result4)) {
do {
$idvijesti=$row["idvijesti"];
print "<font size=\"1\">";
print $row["datum"];
print "</font> ";
print "<font face=\"verdana\" size=\"1\">";
print "<a href=\"index.php?akcija=clanak&idvijesti=$idvijesti\">";
print $row["naslov"];
print "</a>";
print "</font> ";
print "<br>";
} while($row = mysql_fetch_array($result4));
} else {}
}
function prvameni ($idrubrike)
{
$result = mysql_query ("SELECT idvijesti,naslov,substring(tekst,1,400) as tekst,datum,slika FROM informacije where rubrika=$idrubrike order by idvijesti desc limit 6");
if ($row = mysql_fetch_array($result)) {
do {
$slika=$row["slika"];
$idvijesti=$row["idvijesti"];
print ("<font face=\"verdana\"><font size=\"1\"><font color=\"Black\"><b>");
print $row["naslov"];
print ("</font></b><br><br>");
print (" ");
echo slika ($slika);
print ("<font face=\"verdana\"><font size=\"1\"><font color=\"Black\">");
print $row["tekst"];
print ("</font>");
print "<a href=\"index.php?akcija=clanak&idvijesti=$idvijesti\">";
print " Opsirnije...>>>";
print "</a>";
print ("<br>");
print ("<br>");
} while($row = mysql_fetch_array($result));
} else {}
echo naslovi($idrubrike);
}
function naslovi($idrubrike){
$result2 = mysql_query ("SELECT idvijesti,naslov,tekst,datum,slika FROM informacije where rubrika=$idrubrike and portal=1 order by idvijesti desc limit 15");
if ($row = mysql_fetch_array($result2)) {
do {
$idvijesti=$row["idvijesti"];
print "<font face=\"verdana\" size=\"1\">";
print "<a href=\"index.php?akcija=clanak&idvijesti=$idvijesti\">";
print ">> ";
print $row["naslov"];
print "</a>";
print "</font> ";
print "<br>";
} while($row = mysql_fetch_array($result2));
} else {}
}
function naslovi2($idrubrike){
$result2 = mysql_query ("SELECT idvijesti,naslov,tekst,datum,slika FROM informacije where rubrika=$idrubrike and portal=1 order by idvijesti desc limit 6");
if ($row = mysql_fetch_array($result2)) {
do {
$slika=$row["slika"];
$idvijesti=$row["idvijesti"];
print "<font face=\"verdana\" size=\"1\">";
print "<a href=\"index.php?akcija=clanak&idvijesti=$idvijesti\">";
print ">> ";
print $row["naslov"];
print "</a>";
print "</font> ";
print "<br>";
} while($row = mysql_fetch_array($result2));
} else {}
}
function nasloviwap(){
$result2 = mysql_query ("SELECT idvijesti,naslov,tekst,datum,slika FROM informacije where portal=0 order by idvijesti desc limit 25");
if ($row = mysql_fetch_array($result2)) {
do {
$slika=$row["slika"];
$idvijesti=$row["idvijesti"];
print "<font face=\"verdana\" size=\"1\">";
print ">> ";
print $row["naslov"];
print "</font> ";
print "<br>";
} while($row = mysql_fetch_array($result2));
} else {}
}
function pregled ()
{
mysql_connect (localhost, us10505a, proba);
mysql_select_db (db10505c);
$result = mysql_query ("SELECT ID,title,details FROM news where topicID=12 ORDER BY ID desc LIMIT 1");
if ($row = mysql_fetch_array($result)) {
do {
print ("<br>");
print ("<font face=\"arial\"><font size=\"1\"><font color=\"navy\">");
$cl=nl2br($row["details"]);
print $cl;
print ("</font>");
print ("<br>");
} while($row = mysql_fetch_array($result));
} else {print "Nema clanaka!";}
}
?>
|