tuscany-bedandbreakfast.com

$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"\"$img_riga[testo_alt]\""; print"\"".$img_riga['titolo'.$id_lingua]."\""; } $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

"; ?>