".$arrayx['Name']." (".$arrayx['Category'].")

   "; for($i=0;$i<$arrayx['O_Rating'];$i++) { $Data .="star"; } $data = '../css/style.css'; $css = "#di_".$p."{ display:block !important;}\n"; if( strpos(file_get_contents("$data"),$css) == false) { file_put_contents($data, $css, FILE_APPEND | LOCK_EX); } $Data .= "

".add3dots($arrayx['Review'], "...",135)."

"; } array_push($arrpg,$Data); } $p++; } } $sqlhc=mysql_query("Select * from tbl_TagConfi where `Status`='Active' and `Tag_Type` like '%Hotel Category%' "); $sqlhb=mysql_query("Select * from tbl_TagConfi where `Status`='Active' and `Tag_Type` like '%Hotel Budget%'"); $sqlrt=mysql_query("Select * from tbl_TagConfi where `Status`='Active' and `Tag_Type` like '%Rating%'"); $sqlhi=mysql_query("Select * from tbl_TagConfi where `Status`='Active' and `Tag_Type` like '%Htl by Interest%'"); $sql = "SELECT th.*, tcc.City_Name as City , ts.State_Name as State, tg.Tag_Name as Region FROM `tbl_Hotel` th inner join `tbl_CityConfi` tcc on th.City_Id = tcc.CityC_Id inner join `tbl_State` ts on th.State = ts.State_Id inner join `tbl_TagConfi` tg on th.Region_Id = tg.Tag_Id where th.Hotel_Id = '$hid' "; $result = mysql_query($sql); if (!$result) { echo 'Could not run query: ' . mysql_error(); exit; } $row = mysql_fetch_row($result); $hotelurl = stripslashes($row[5]); $hoteln = stripslashes($row[1]); $pagee = $hoteln; $urle= "http://".$_SERVER["SERVER_NAME"].$_SERVER["REQUEST_URI"]; $title = stripslashes($row[2]); $description = stripslashes($row[3]); $keywords = stripslashes($row[4]); $region = stripslashes($row[22]); $brief = stripslashes($row[9]); $cityn = stripslashes($row[20]); $state = $row[21]; $tname = unserialize($row[11]); $ttitle = unserialize($row[10]); $tdes = unserialize($row[12]); $text1 = unserialize($row[13]); $text2 = unserialize($row[14]); $stext = unserialize($row[15]); $seq = unserialize($row[17]); $fseq = array_flip($seq); $countf = count($fseq); ksort($fseq); $images = unserialize($row[16]); $flipseq = array_flip($seq); $keyseq = array_keys($flipseq); $flipkey = array_flip($keyseq); ksort($flipkey); $arraytg = array(); while($rowt = mysql_fetch_array($sqltag)) { $arraytg[$rowt['Tag_Id']]=$rowt['Tag_Name']; } ksort($arraytg); $arrayhc = array(); while($rowh = mysql_fetch_array($sqlhc)) { array_push($arrayhc,$rowh['Tag_Id']); } $arrayhb = array(); while($rowhb = mysql_fetch_array($sqlhb)) { array_push($arrayhb,$rowhb['Tag_Id']); } $arrayrt = array(); while($rowrt = mysql_fetch_array($sqlrt)) { array_push($arrayrt,$rowrt['Tag_Id']); } $arrayhi = array(); while($rowhi = mysql_fetch_array($sqlhi)) { array_push($arrayhi,$rowhi['Tag_Id']); } function add3dots($string, $repl, $limit) { if(strlen($string) > $limit) { return substr($string, 0, $limit) . $repl; } else { return $string; } } $sqlitn=mysql_query("Select Itinerary_Id,B_Hotel1,B_Hotel2,D_Hotel1,D_Hotel2,L_Hotel1,L_Hotel2 from tbl_Itinerary where `Status`='Active' "); $arrayitn=array(); while($rowitn = mysql_fetch_array($sqlitn)) { $arrayhtl=array(); $itid=''; $bhotel1 = unserialize($rowitn['B_Hotel1']); $bhotel2 = unserialize($rowitn['B_Hotel2']); $dhotel1 = unserialize($rowitn['D_Hotel1']); $dhotel2 = unserialize($rowitn['D_Hotel2']); $lhotel1 = unserialize($rowitn['L_Hotel1']); $lhotel2 = unserialize($rowitn['L_Hotel2']); $itid = $rowitn['Itinerary_Id']; foreach($bhotel1 as $bh1){if($bh1!='-Please Select'){array_push($arrayhtl,$bh1);}} foreach($bhotel2 as $bh2){if($bh2!='-Please Select'){array_push($arrayhtl,$bh2);}} foreach($dhotel1 as $dh1){if($dh1!='-Please Select'){array_push($arrayhtl,$dh1);}} foreach($dhotel2 as $dh2){if($dh2!='-Please Select'){array_push($arrayhtl,$dh2);}} foreach($lhotel1 as $lh1){if($lh1!='-Please Select'){array_push($arrayhtl,$lh1);}} foreach($lhotel2 as $lh2){if($lh2!='-Please Select'){array_push($arrayhtl,$lh2);}} array_unique($arrayhtl); foreach($arrayhtl as $arhtl){if($arhtl==$hid){array_push($arrayitn,$itid);}} //array_push($arrayitn, unserialize($rowitn['Itinerary_City'])); } array_unique($arrayitn); $regionid = $row[7]; $sqlhotel = mysql_query("Select th.Hotel_Id,th.Region_Id from tbl_Hotel th where th.`Status`='Active' and th.Region_Id = '$regionid' "); $arrayhotel=array(); while($rowhtl = mysql_fetch_array($sqlhotel)) { $htyid = $rowhtl['Hotel_Id']; if($htyid==$hid){continue;} array_push($arrayhotel,$htyid); //array_push($arrayitn, unserialize($rowitn['Itinerary_City'])); } /* session_start(); $_SESSION['pageid'][]="h".$hid; $arrayre = array_unique($_SESSION['pageid']);*/ $hoteln1 = preg_replace('/\s+/', '%20', $hoteln); $server = $_SERVER['HTTP_HOST']; ?> <?php echo $title; ?> "; } echo $datam;?>
'.$text1[$fseq[$j]].'
'.$text2[$fseq[$j]].'
'.$stext[$fseq[$j]].'
'; } echo $divt; ?>

    ";}}}?>

,

This Hotel is Suitable for

".$arraytg[$hi]."
";}}?>

Location

Related Itineraries

"; for($k=$i;$k<($i+2);$k++) { if(!empty($arrayitn[$k])){ $sqlitny = "Select Itinerary_Id,Itinerary_Name,Image,Sequence,Itinerary_Url from tbl_Itinerary where `Status`='Active' and `Itinerary_Id` = '".$arrayitn[$k]."' "; $resultny = mysql_query($sqlitny); $rowitny = mysql_fetch_row($resultny); $image = unserialize($rowitny[2]); $seq = unserialize($rowitny[3]); $server = $_SERVER['HTTP_HOST']; $flipseq = array_flip($seq); $keyseq = array_keys($flipseq); $flipkey = array_flip($keyseq); ksort($flipkey); $fimg = $image[$flipkey[1]]; $namei = preg_replace('/\s+/', '%20', $rowitny[1]); $nameni = htmlspecialchars($namei); $datat .="
"; $datat .=" ".
ameni.""; $datat .="

".$rowitny[1]."

"; $datat .="
"; } } $datat .="
"; $j++;} echo $datat;?>

Nearby Properties

"; for($n=$m;$n<($m+2);$n++) { if(!empty($arrayhotel[$n])){ $sqlitnyc = "Select th.Hotel_Id,th.Hotel_Url,tcc.City_Name as City,th.Image,th.Sequence,th.Hotel_Name from tbl_Hotel th inner join tbl_CityConfi tcc on th.City_Id=tcc.CityC_Id where th.`Status`='Active' and th.`Hotel_Id` = '".$arrayhotel[$n]."'"; $resultnyc = mysql_query($sqlitnyc); $rowitnyc = mysql_fetch_row($resultnyc); $imagec = unserialize($rowitnyc[3]); $seqc = unserialize($rowitnyc[4]); $serverc = $_SERVER['HTTP_HOST']; $flipseqc = array_flip($seqc); $keyseqc = array_keys($flipseqc); $flipkeyc = array_flip($keyseqc); ksort($flipkeyc); $fimgc = $imagec[$flipkeyc[1]]; $namel = preg_replace('/\s+/', '%20', $rowitnyc[5]); $namenl = htmlspecialchars($namel); $namec = preg_replace('/\s+/', '%20', $rowitnyc[2]); $namenc = htmlspecialchars($namec); $datath .="
"; $datath .=" ".$rowitnyc[5].""; $datath .="

".$rowitnyc[5]."

"; $datath .="
"; } } $datath .="
"; $p++;} echo $datath;?>