Codice PHP:
sql1="SELECT * from tblproperties where active= '1' and venta = '1'" . $addsql ;$sq1l=$sql1."" ;$SearchResult = mysql_query($sql1);$NumberOfResults = mysql_num_rows($SearchResult );$NumberOfPages = ceil ( $NumberOfResults / $Limit );mysql_query('set names ISO-8859-1');$sql="SELECT * from tblproperties ";$sql=$sql." where active= '1' and venta = '1' " . $addsql ;$sql=$sql." order by parea, p_price DESC" ;$sql=$sql." LIMIT " . ( $page - 1 )* $Limit . ",$Limit ";$SearchResult = mysql_query($sql);$SearchString = $addsql;$colonne = 2;
<?$Nav = "" ;If( $page > 1 ) {$Nav .= "<A HREF=\"showpropertiess.php?page=" . ( $page - 1 ) . "&addsql=" . urlencode ( $addsql ) . "\"><img src='listing/flecha2.jpg' alt='flecha' width='35' height='26' align='absmiddle' /></A>" ;}For( $i = 1 ; $i <= $NumberOfPages ; $i ++) {If( $i == $page ) {$Nav .= "<font size='3' color='#FF0000'>$i</font>" ;}Else{$Nav .= " <A HREF=\"showpropertiess.php?page=" . $i . "&addsql=" . urlencode ( $addsql ) ."\"><font size='3' color='#000000'>$i</font></A> " ;}}If( $page < $NumberOfPages ) {$Nav .= "<A HREF=\"showpropertiess.php?page=" . ( $page + 1 ) . "&addsql=" . urlencode ( $addsql ) . "\"><img src='listing/flecharight2.jpg' alt='flecha' width='35' height='26' align='absmiddle' border='0'/></A>" ;}?><table width="900" border="0" cellspacing="0" cellpadding="0">
<? if($NumberOfResults <= 0) { ?>
<tr><td colspan="9" align="center" class=""><div align="center">NoProperties Results found<br />Try Again</div></td>
</tr> <? } ?><?$res = mysql_query($sql);if(($righe = mysql_num_rows($res))>0){
for($i = 0; $i < $righe; $i++) {$r = mysql_fetch_array($res);
$tema = $r['ptitle'];
$fid = $r['p_id'];$image = $r['p_small1'];$idcity= $r['parea'];$beds = $r['bedrooms'];$bath= $r['bathrooms'];$pcaracter= $r['pcaracter_rent'];$ptype= $r['categorytype'];$p_price= $r['p_price'];$price_rent_night= $r['price_rent_night'];$p_price= $r['p_price'];$p_price_unf= $r['p_price_unf'];$p_price_kit= $r['p_price_kit'];$pinfo= $r['pinfo'];$tipo = $r['type'];
$price = $p_price;
$resultshow2 = mysql_query("SELECT * FROM city where id_city=$idcity");$rowtype2 = mysql_fetch_array($resultshow2);$city= $rowtype2['nome_city'];$id_pro= $rowtype2['id_pro'];$numero2 = $r['psize'];$numero = ($r['psize']*10.7639104);$resultshow4 = mysql_query("SELECT * FROM province where id_pro='$id_pro'");$rowtype4 = mysql_fetch_array($resultshow4);$provincia= $rowtype4['nome_provincia'];
$resultshow5 = mysql_query("SELECT * FROM caracteristica where id='$pcaracter'");$rowtype5 = mysql_fetch_array($resultshow5);$caratteristica= $rowtype5['descripcion_en'];
$stringa = strtolower($tema);
$occorrenze = array(" ", ",", "?",".");
$sostituti = array("-", "", "","");
$stringa = str_replace($occorrenze, $sostituti, $stringa);
$result1 = mysql_query("SELECT * FROM tblcategory where cat_id = $ptype");$row1 = mysql_fetch_array($result1);
$category = $row1['cat_name_en'];
$result2 = mysql_query("SELECT * FROM tbltype");while($row2 = mysql_fetch_array($result2)){if ($row2['id']==$r['type']){$type = $row2['descripcion_en'];
}}
if($i % $colonne == 0) {
echo '<table "padding-left:40px; padding-right:40px" align="left" cellpadding="0" cellspacing="20">';echo '<tr>';}echo '<td width="446" align="center" ><a href="'.$fid.'_'.$stringa.'.html"><img src="propertyimages/'.$r['p_small1'].'" BORDER="0" width="446" height="259"></a>';
echo '<div style="background-color:#000000; width:105; float: right;" class="titulopropiedades">'.$beds.'</font> <img src="listing/bed.jpg" alt="bed" width="45" height="27" align="absmiddle"/>'.$bath.' <img src="listing/tina.jpg" alt="tub" width="45" height="27" align="absmiddle"/></div><div style="background-color:#000000; width:160;" class="titulopropiedades" >'.$r['ptitle'].'<img src="listing/negro.jpg" alt="bed" width="45" height="27" align="absmiddle"/></div>';
echo '<div style="background-color:#C41B20; width:265; line-height:8px" align="left" valign="middle" class="descripcionpropiedad1"> </div>';
echo '<div style="background-color:#ffffff; width:265; line-height:4px" align="left" valign="middle" class="descripcionpropiedad1"> </div>';
echo '<div style="background-color:#ffffff; width:105; float: right;" class="textonegrotablas"><img src="listing/blanco.jpg" width="10" height="22" align="absmiddle"/>'.$category.'</div><div style="background-color:#ffffff; width:160;" class="textonegrotablas" >For Sale<img src="listing/blanco.jpg" width="10" height="22" align="absmiddle"/></div>';$formattato = number_format($numero2, 2, '.',',');
$formattato2 = number_format($numero, 2, '.',',');
echo '<div style="background-color:#ffffff; width:105; float: right;" class="textonegrotablas"><img src="listing/blanco.jpg" width="10" height="22" align="absmiddle"/></div><div style="background-color:#ffffff; width:160;" class="textonegrotablas" >'.$city.', '.$provincia.'<img src="listing/blanco.jpg" width="10" height="22" align="absmiddle"/><br>Size: '. $formattato .' m≤ / '. $formattato2 .' ft≤</div>';
$caratt = $r['pcaracter'];$sql2="SELECT * from caracteristica where id = '$caratt'";$result2 = mysql_query($sql2) or die(mysql_error());$rowcar = mysql_fetch_array($result2);$cara = $rowcar['descripcion_en'];$price = $r['p_price'];
$priceformat= number_format($price, 0, '.',',');
echo '<div style="background-color:#ffffff; width:265; align="left" valign="middle" class="textonegrotablas">US$ '.$priceformat.' '.$cara.'<img src="listing/blanco.jpg" width="10" height="22" align="absmiddle"/></div>';
echo '<div style="background-color:#ffffff; width:105; float: right;" class="textonegrotablas"><img src="listing/blanco.jpg" width="10" height="22" align="absmiddle"/><a href="gallery.php?fid='.$fid.'"><img src="details/view2.jpg" BORDER="0"></a></div><div style="background-color:#ffffff; width:160;" class="textonegrotablas" ><a href="'.$fid.'_'.$stringa.'.html"><img src="details/info.jpg" BORDER="0"></a></div>';
echo '<div style="background-color:#ffffff; width:105; float: right;" class="textonegrotablas"><img src="listing/blanco.jpg" width="10" height="22" align="absmiddle"/></div><div style="background-color:#ffffff; width:160;" class="textonegrotablas" ><img src="listing/blanco.jpg" width="10" height="22" align="absmiddle"/></div>';
echo '<div style="background-color:#D6D6D6; width:265" align="left" valign="middle" class="descripcionpropiedad1"><img src="listing/linea.jpg" width="446" /></div>';
echo '</td>'; if(($i % $colonne) == ($colonne - 1) || ($i + 1) == $righe) {
echo '</tr>';
}
}
}?>