$num=8;
print"
$home_04
";
$conn = mysql_connect($host,$user,$pass) or die("Errore nella connessione MySQL: " . mysql_error());
mysql_select_db($db,$conn) or die("Errore nella selezione del database: " . mysql_error());
$query1 = 'SELECT Count('.$pref.'appartamenti.id_app) as numero';
$query2 = 'SELECT '.$pref.'appartamenti.*,'.$pref.'contenuti.titolo,'.$pref.'contenuti.abstract,'.$pref.'luoghi.luogo'.$id_lingua.' as luogo,'.$pref.'posti.bed'.$id_lingua.' as bed,'.$pref.'tariffe.*';
//$query =(SELECT '.$pref.'tariffe.p1 UNION SELECT '.$pref.'tariffe.p2 UNION SELECT '.$pref.'tariffe.p3 UNION SELECT ' UNION SELECT '.$pref.'tariffe.p5 group by '.$pref.'tariffe.p1)';
$query =' FROM ((('.$pref.'appartamenti';
$query = $query. ' Inner Join '.$pref.'contenuti ON '.$pref.'appartamenti.id_app='.$pref.'contenuti.id_app)';
$query = $query. ' Inner Join '.$pref.'luoghi ON '.$pref.'appartamenti.id_luogo='.$pref.'luoghi.id)';
$query = $query.' Inner Join '.$pref.'posti ON '.$pref.'appartamenti.id_bed='.$pref.'posti.id)';
$query = $query. ' Inner Join '.$pref.'tariffe ON '.$pref.'appartamenti.id_app='.$pref.'tariffe.id_app';
$query = $query. ' WHERE '.$pref.'appartamenti.pubblica=1 and '.$pref.'contenuti.id_lingua='.$id_lingua;
if ($_GET['tipologia']!="" or $_GET['luoghi']!="" or $_GET['budget']!="" or $_GET['pets']!="" or $_GET['pool']!="" or $_GET['posti']!="" or $_GET['ricerca']!="") {
if ($_GET['tipologia']!="") $query = $query.' AND ('.$pref.'appartamenti.id_tipo='.$_GET['tipologia'];
if ($_GET['tipologia2']!="") $query = $query.' OR '.$pref.'appartamenti.id_tipo='.$_GET['tipologia2'];
if ($_GET['tipologia']!="")$query = $query.')';
if ($_GET['luoghi']!="") $query = $query.' AND ('.$pref.'appartamenti.id_luogo='.$_GET['luoghi'];
if ($_GET['luoghi2']!="") $query = $query.' OR '.$pref.'appartamenti.id_luogo='.$_GET['luoghi2'];
if ($_GET['luoghi3']!="") $query = $query.' OR '.$pref.'appartamenti.id_luogo='.$_GET['luoghi3'];
if ($_GET['luoghi']!="") $query = $query.')';
//if ($_GET['posti']!="") $query = $query.' AND '.$pref.'appartamenti.id_bed='.$_GET['posti'];
//if ($_GET['posti']!="") {
// $query_p = 'SELECT id FROM '.$pref.'posti WHERE bed3 like \'%'.$_GET['posti'].'%\'';
// $rs_p = mysql_query($query_p,$conn) or die("Errore nella query:" . mysql_error());
// while($riga_p=mysql_fetch_array($rs_p)) {
// $pippo=$riga_p['id'];
// }
// $query = $query.' AND '.$pref.'appartamenti.id_bed='.$pippo;
// }
if ($_GET['pets']!="") $query = $query.' AND '.$pref.'appartamenti.opzioni like \'%'.$_GET['pets'].'%\'';
if ($_GET['pool']!="") $query = $query.' AND '.$pref.'appartamenti.opzioni like \'%'.$_GET['pool'].'%\'';
if ($_GET['budget']!="") {
$query_budget = 'SELECT * FROM '.$pref.'budget where id=' .$_GET['budget']. ' Limit 1';
$rs_budget = mysql_query($query_budget,$conn) or die("Errore nella query:" . mysql_error());
while($riga_budget=mysql_fetch_array($rs_budget)) {
$budget_min=$riga_budget[budget_min];
$budget_max=$riga_budget[budget_max];
}
$query = $query.' AND (('.$pref.'tariffe.p1<='.$budget_max.' AND '.$pref.'tariffe.p1>'.$budget_min.') ';
$query = $query.' OR ('.$pref.'tariffe.p2<='.$budget_max.' AND '.$pref.'tariffe.p2>'.$budget_min.') ';
$query = $query.' OR ('.$pref.'tariffe.p3<='.$budget_max.' AND '.$pref.'tariffe.p3>'.$budget_min.') ';
$query = $query.' OR ('.$pref.'tariffe.p4<='.$budget_max.' AND '.$pref.'tariffe.p4>'.$budget_min.') ';
$query = $query.' OR ('.$pref.'tariffe.p5<='.$budget_max.' AND '.$pref.'tariffe.p5>'.$budget_min.')) ';
}
if ($_GET['ricerca']!="") {
$query = $query.' AND ('.$pref.'contenuti.titolo like \'%'.$_GET['ricerca'].'%\' OR '.$pref.'contenuti.abstract like \'%'.$_GET['ricerca'].'%\')';
}
print"
$text_risult
";
}
$query1= $query1 . $query;
//print $query1;
$rs = mysql_query($query1,$conn) or die("Errore nella query:" . mysql_error());
while($riga=mysql_fetch_array($rs)) {
$totali=round($riga[numero]/8+0.49);
}
if ($totali>0.5) {
$str_page= "page ".($page+1)." di ".$totali." ";
for ($i=0;$i<=$totali-1;$i++) {
$str_page.="[".($i+1)."] "; }
print $str_page."
";
} else {
print $text_sorry."";
}
$query2 = $query2.$query. ' order by visibilita desc Limit '.$page*$num.',8';
//print $query2;
$indice=0;
$ii=0;
$rs = mysql_query($query2,$conn) or die("Errore nella query:" . mysql_error());
while($riga=mysql_fetch_array($rs)) {
if ($indice!=$riga[id_app]) {
print"
";
$ii+=1;
print"";
// fase di estrazione di una sola miniatura per ogni appartamento
$img_query = 'SELECT * FROM '.$pref.'immagini where id_app=' .$riga[id_app]. ' order by id Limit 1';
$img_rs = mysql_query($img_query,$conn) or die("Errore nella query:" . mysql_error());
while($img_riga=mysql_fetch_array($img_rs)) {
//print"";
print"";
}
$indice=1;
for($i=1;$i<6;$i++){
if (($riga['p'.$i]!="")&&($riga['p'.$i]!=0)) {
$lst[$base+$indice] = $riga['p'.$i];
$indice++;
}
$base+=$indice;
}
print"• $riga[titolo] [$riga[luogo]] \n";
//print "[$riga[bed]]
";
print"
$riga[abstract]... ";
if (count($lst)!=0) print "".$text_price.min($lst)."€ ". $text_to .max($lst)."€\n";
unset($lst);
print"» ".$text_piu."
\n";
$indice=$riga[id_app];
}
}
print "
".$str_page." » $text_home
";
?>
include("inc/footer.php"); ?>