Viewing file:  pretraga.php (6.06 KB) -rwxr-xr-x
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<meta http-equiv="Content-Type" content="text/html; charset=windows-1250">
<meta name="GENERATOR" content="Microsoft FrontPage 5.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<SCRIPT language="php">
if ($akcija==arhivabiz){
;
mysql_connect (localhost, us10505a, proba);
mysql_select_db (db10505e);
if ( $limit == "" && $from == "" ) {
$limit = 100;
$from = 0;
}
$result = mysql_query ("SELECT title,ID,date,Slag FROM news 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=\"pretraga.php?akcija=clanakbiz&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=\"pretraga.php?akcija=arhivabiz&from=$from&limit=$limit\"><b><font size=\"2\">Sledecih $limit clanaka</font><b><a>");
}
elseif ($akcija==clanakbiz){
mysql_connect (localhost, us10505a, proba);
mysql_select_db (db10505e);
$result = mysql_query ("SELECT title,details,date,Slag,topicId FROM news WHERE ID=$no ");
if ($row = mysql_fetch_array($result)) {
do {
$tip=$row["topicId"];
$before=$row["details"];
$after=str_replace("#","'",$before);
$prazno=nl2br($after);
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 ("<center><font face=\"verdana\"><font size=\"2\"><font color=\"Black\"><b>");
print $row["title"];
print ("</font></b></center><br>");
print (" ");
if($tip==3){
print $after;}
else{
print $prazno;}
print ("<p>");
print ("<br>");
} while($row = mysql_fetch_array($result));
} else {print "Nema clanaka!";}
}
elseif ($akcija==pretragabiz){
mysql_connect (localhost, us10505a, proba);
mysql_select_db (db10505e);
$query = mysql_query("SELECT * FROM news WHERE $metode LIKE '%$search%' ORDER BY ID desc");
while ($row = mysql_fetch_array($query))
{
$variable1=$row["title"];
$variable2=$row["details"];
$variable3=$row["Slag"];
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=\"pretraga.php?akcija=clanakbiz&no=$no\">");
print $row["title"];
print ("</a></font></b>");
print (" ");
print ("<hr size=1>");
} while($row = mysql_fetch_array($query));}}
elseif ($akcija==arhiva){
mysql_connect (localhost, us10505a, proba);
mysql_select_db (db10505c);
if ( $limit == "" && $from == "" ) {
$limit = 200;
$from = 0;
}
$result = mysql_query ("SELECT title,ID,date,Slag FROM news 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=\"pretraga.php?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=\"pretraga.php?akcija=arhiva&from=$from&limit=$limit\"><b><font size=\"2\">Sledecih $limit clanaka</font><b><a>");
}
elseif ($akcija==clanak){
mysql_connect (localhost, us10505a, proba);
mysql_select_db (db10505c);
$result = mysql_query ("SELECT title,details,date,Slag,topicId FROM news WHERE ID=$no ");
if ($row = mysql_fetch_array($result)) {
do {
$tip=$row["topicId"];
$before=$row["details"];
$after=str_replace("#","'",$before);
$prazno=nl2br($after);
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 ("<center><font face=\"verdana\"><font size=\"2\"><font color=\"Black\"><b>");
print $row["title"];
print ("</font></b></center><br>");
print (" ");
if($tip==3){
print $after;}
else{
print $prazno;}
print ("<p>");
print ("<br>");
} while($row = mysql_fetch_array($result));
} else {print "Nema clanaka!";}
}
elseif ($akcija==pretraga){
mysql_connect (localhost, us10505a, proba);
mysql_select_db (db10505c);
$query = mysql_query("SELECT * FROM news WHERE $metode LIKE '%$search%' ORDER BY ID desc");
while ($row = mysql_fetch_array($query))
{
$variable1=$row["title"];
$variable2=$row["details"];
$variable3=$row["Slag"];
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=\"pretraga.php?akcija=clanak&no=$no\">");
print $row["title"];
print ("</a></font></b>");
print (" ");
print ("<hr size=1>");
} while($row = mysql_fetch_array($query));}}
else {
}
</SCRIPT>
|