Qui c'è qualcosa di utile? 
codice:
<?php
//MESS NOT WITH THIS CODE (UNLESS YOU KNOW WHAT YOU'RE DOING, OF COURSE)
include("./common.php");
//set up SQL connection
$link = mysql_connect ($server, $user, $password);
if (! $link)
{
die ("Couldn't connect to mySQL server");
}
if (!mysql_select_db ($db, $link) )
{
die ("Coldn't open $db: ".mysql_error() );
}
function makelisting($querystring, $link, $guidestring, $cur_page, $listings_per_page, $sort)
{
global $use_city_state;
if ($sort == "") {$sort = "price DESC";}
$querystring = $querystring." ORDER BY $sort";
$result = mysql_query("$querystring;",$link);
$num_rows = mysql_num_rows($result);
$page_num = $cur_page + 1;
$total_num_page = ceil($num_rows/$listings_per_page);
print "<left>";
if ($num_rows == "1") {Print "C'è un annuncio che soddisfa la tua ricerca.
";}
else {Print "<font color=#ff6600>Attualmente ci sono $num_rows annunci che soddisfano la tua ricerca.
";}
if ($total_num_page != 0)
{
Print "Questa è la pagina $page_num di $total_num_page. Mostro $listings_per_page annunci per pagina.
";
$prevpage = $cur_page-1;
$nextpage = $cur_page+1;
if ($page_num != 1){print "<a href=\"./view.php?$guidestring&cur_page=$prevpage&sort=$sort\">Pagina precedente</a> ";}
if ($page_num != $total_num_page){print " <a href=\"./view.php?$guidestring&cur_page=$nextpage&sort=$sort\">Pagina seguente</a> ";}
}
if ($total_num_page > 1)
{
print "<FORM name=pagejump_top>";
Print "<SELECT NAME=\"selectpage\" onChange=\"window.location.href=document.pagejump_top.selectpage.options[document.pagejump_top.selectpage.selectedIndex].value\"> ";
Print "<OPTION VALUE=\"./view.php?$guidestring&cur_page\" SELECTED>Vai a ";
for ($counter=0; $counter<=$total_num_page-1; $counter++)
{
$page_jump = $counter +1;
print "<OPTION VALUE=\"./view.php?$guidestring&cur_page=$counter&sort=$sort\">Pagina $page_jump ";
}
print "</SELECT>";
Print "</FORM>";
}
print "
";
//handle sort functions
print "[ Ordina per: ";
print "  <a href=\"./view.php?$guidestring&sort=price%20DESC\">";
if ($sort == "price DESC") {print "Prezzo";}
else {print "Prezzo";}
print "</a>  <a href=\"./view.php?$guidestring&sort=id%20DESC\">";
if ($sort == "id DESC") {print "Ultimi annunci";}
else {print "Ultimi annunci";}
print "</a>  <a href=\"./view.php?$guidestring&sort=miles%20DESC\">";
if ($sort == "miles DESC") {print "Km";}
else {print "Km";}
print "</a>  <a href=\"./view.php?$guidestring&sort=year%20DESC\">";
if ($sort == "year DESC") {print "Anno";}
else {print "Anno";}
print "</a>  <a href=\"./view.php?$guidestring&sort=state\">";
if ($sort == "state") {print "Provincia";}
else {print "Provincia";}
print "</a> ]
";
//end sort functions
$limit_str = "LIMIT ". $cur_page * $listings_per_page .",$listings_per_page";
$query = "$querystring $limit_str";
$result = mysql_query("$query;",$link);
print "<table width=\"65%\" align=left border=0 cellspacing=0 cellpadding=0>";
print "<TR>";
print "</tr>";
print "<TR bgcolor=black height=3>";
print "<td align=center> </td>";
if ($use_city_state == "Y") {print "<td align=center> </td>";}
print "<td align=center> </td>";
print "</tr>";
print "<TR height=5>";
print "<td align=center> </td>";
if ($use_city_state == "Y") {print "<td align=center> </td>";}
print "<td align=center> </td>";
print "</tr>";
print "";
while ($a_row =mysql_fetch_array ($result) )
{
//strip slashes so input appears correctly
$a_row[$title] = stripslashes($a_row[$title]);
$a_row[$address] = stripslashes($a_row[$address]);
$a_row[city] = stripslashes($a_row[city]);
$a_row[previewdesc] = stripslashes($a_row[previewdesc]);
$a_row[fulldesc] = stripslashes($a_row[fulldesc]);
$a_row[type] = stripslashes($a_row[type]);
$a_row[transmission] = stripslashes($a_row[transmission]);
$a_row[color] = stripslashes($a_row[color]);
$a_row[doors] = stripslashes($a_row[doors]);
$a_row[stereo] = stripslashes($a_row[stereo]);
$a_row[cavalli] = stripslashes($a_row[cavalli]);
$a_row[notes] = stripslashes($a_row[notes]);
//format price & miles
$a_row[price] = number_format ($a_row[price]);
$a_row[miles] = number_format ($a_row[miles]);
print "<TR>";
//select images connected to a given listing
$query = "SELECT * FROM tbl_Files WHERE prop_num = $a_row[id] LIMIT 1";
$output = mysql_query("$query",$link);
$count = 0;
while ($image_row =mysql_fetch_array ($output) )
{
print "<td valign=top align=center width=115 bgcolor=#d9e1f0><a href=\"./view.php?view=$a_row[id]\">[img]image.php?Id=$image_row[id_files][/img]</a>
</td>";
$count++;
}
if ($count == 0)
{
print "<td valign=top align=center width=115 bgcolor=#d9e1f0><a href=\"./view.php?view=$a_row[id]\"><img src=\"./images/nophoto.gif\" border=0 width=75 alt=\"View Listing\"></a>
</td>";
}
print "</td>";
if ($use_city_state == "Y") {print "<td align=left valign=top bgcolor=white><font color=#0000ff font size=2>$a_row[make] $a_row[model] $a_row[type]
<font color=#000066 font size=2>$a_row[zip] - $a_row[state], Anno $a_row[year], $a_row[type], $a_row[color], $a_row[miles] km, $a_row[cavalli] cv</td>";}
print "<td align=center bgcolor=#d9e1f0><font color=#000066 font size=2>€ $a_row[price]</td>";
print "</tr>";
print "<TR>";
if ($use_city_state == "Y") {print "<td align=center> </td>";}
print "</tr>";
print "<TR height=2>";
if ($use_city_state == "Y") {print "<td align=center> </td>";}
print "</tr>";
print "<TR bgcolor=black height=1>";
if ($use_city_state == "Y") {print "<td align=center> </td>";}
print "<td align=center> </td>";
print "<td align=center> </td>";
print "</tr>";
print "<TR height=3>";
print "<td align=center> </td>";
print "</tr>";
}
print "</table>";
if ($total_num_page > 1)
{
}
if ($total_num_page != 0)
{
}
Print "</center>";
}
Rispondi quotando
)
