Viewing file:  nina.inc (5.57 KB) -rwxr-xr-x
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?
if ($akcija==article){
mysql_connect (localhost, nina, nina);
mysql_select_db (nina);
$result = mysql_query ("SELECT title,details,date,Slag,imageID FROM website WHERE ID=$no ");
if ($row = mysql_fetch_array($result)) {
do {
$before=$row["details"];
$after=str_replace("#","'",$before);
$prazno=nl2br($after);
$id2=$row["imageID"];
print ("<font face=\"verdana\"><font size=\"1\">");
print $row["date"];
print ("</font>");
print ("<br>");
print ("<font face=\"verdana\"><font size=\"1\">");
print $row["Slag"];
print ("</font>");
print ("<br>");
print ("<font face=\"verdana\"><font size=\"2\"><font color=\"Black\"><b>");
print $row["title"];
print ("</font></b><br>");
print ("<br>");
print ("<img src=\"imageShow.php3?id=$id2\">");
print ("<font face=\"verdana\"><font size=\"2\">");
print ("<br>");
print $prazno;
print ("</font>");
print ("<p>");
print ("<br>");
} while($row = mysql_fetch_array($result));
} else {print "Nema clanaka!";}
}
elseif ($akcija==archives){
mysql_connect (localhost, nina, nina);
mysql_select_db (nina);
if ( $limit == "" && $from == "" ) {
$limit = 100;
$from = 0;
}
$result = mysql_query ("SELECT title,ID,date,Slag FROM website ORDER BY ID desc limit $from, $limit ");
if ($row = mysql_fetch_array($result)) {
do {
$no=$row["ID"];
print ("<font face=\"verdana\"><font size=\"1\">");
print $row["date"];
print ("</font>");
print ("<br>");
print ("<font face=\"verdana\"><font size=\"1\">");
print $row["Slag"];
print ("</font>");
print ("<br>");
print ("<b><font face=\"verdana\"><font size=\"1\"><font color=\"Navy\"><a href=\"servisbiz.php3?akcija=clanak&no=$no\">");
print $row["title"];
print ("</a></font></b>");
print (" ");
print ("<hr size=1>");
} while($row = mysql_fetch_array($result));
} else {print "Nema clanaka!";}
$from = $from + $limit;
print ("<br><a href=\"index.php3?akcija=arhiva&from=$from&limit=$limit\"><b><font size=\"2\">Next $limit articles</font><b><a>");
print ("<br>");
print ("<br>");
}
elseif ($akcija==topic){
mysql_connect (localhost, nina, nina);
mysql_select_db (nina);
$result = mysql_query ("SELECT title,details,date,Slag,imageID FROM website WHERE topicID=$no and lang=1 ORDER BY ID desc LIMIT 10 ");
if ($row = mysql_fetch_array($result)) {
do {
$before=$row["details"];
$imageID=$row["imageID"];
$after=str_replace("#","'",$before);
$prazno=nl2br($after);
print ("<font face=\"arial\"><font size=\"1\">");
print $row["date"];
print ("</font>");
print ("<br>");
print ("<font face=\"verdana\"><font size=\"2\">");
print $row["Slag"];
print ("</font>");
print ("<br>");
print ("<font face=\"verdana\"><font size=\"2\"><font color=\"Black\"><b>");
print $row["title"];
print ("</font></b><br>");
print ("<img align=left border=\"1\" src=\"imageShow.php3?id=$imageID\">");
print (" ");
print ("<font face=\"arial\"><font size=\"1\"><font color=\"Black\">");
print $prazno;
print ("</font></b><br>");
} while($row = mysql_fetch_array($result));
} else {print "Nema clanaka!";}
}
elseif ($akcija==search){
mysql_connect (localhost, nina, nina);
mysql_select_db (nina);
$query = mysql_query("SELECT * FROM website WHERE $metode LIKE '%$search%' ORDER BY ID desc");
while ($row = mysql_fetch_array($query))
{
$variable1=$row["title"];
$variable2=$row["details"];
$variable3=$row["ID"];
do {
$no=$row["ID"];
print ("<font face=\"verdana\"><font size=\"1\">");
print $row["date"];
print ("</font>");
print ("<br>");
print ("<font face=\"verdana\"><font size=\"1\">");
print $row["Slag"];
print ("</font>");
print ("<br>");
print ("<b><font face=\"verdana\"><font size=\"1\"><font color=\"Navy\"><a href=\"index.php3?akcija=article&no=$no\">");
print $row["title"];
print ("</a></font></b>");
print (" ");
print ("<hr size=1>");
} while($row = mysql_fetch_array($query));}
}
else {
$result = mysql_query ("SELECT ID, Slag,title,substring(details,1,300) as details,date,imageID FROM website where lang=1 ORDER BY ID desc LIMIT 10");
print ("<table>");
if ($row = mysql_fetch_array($result)) {
do {
$no=$row["ID"];
$imageID=$row["imageID"];
print ("<font face=\"arial\"><font size=\"1\">");
print $row["date"];
print ("</font>");
print ("<br>");
print ("<font face=\"arial\"><font size=\"1\">");
print $row["Slag"];
print ("</font>");
print ("<br>");
print ("<font face=\"arial\"><font size=\"5\"><font color=\"Black\"><b>");
print $row["title"];
print ("</font></b><br>");
print ("<img align=left border=\"1\" src=\"imageShow.php3?id=$imageID\">");
print ("<font face=\"arial\"><font size=\"2\"><font color=\"Black\">");
print $row["details"];
print ("</font>");
print ("...");
print ("<font size=\"1\"><font color=\"Navy\"><a href=\"index.php?akcija=article&no=$no\">");
print (" >> More >>");
print ("</a></font>");
} while($row = mysql_fetch_array($result));
print ("</table>");
} else {print "Nema clanaka!";}
}
?>
|