";
$rst = open_mysql("partners_abldata", $sql);
open_mysql("close");
$line = mysql_fetch_array($rst, MYSQL_ASSOC);
if ($line[rate] > 0) {
if ($line[hotdeals] > 0) {
$out = "from USD " . round($line[rate] / 1.21) ." " . round($line[hotdeals] / 1.21)." ";
} else {
$out = "from USD ".round($line[rate] / 1.21);
}
} else {
$sql3 = "SELECT MIN(rate) as 'rate' FROM rate_availability
WHERE org_id='{$oid}' AND date like '%$year%' AND rate !=0";
//echo $sql3."
In and around
Sanur is Bali's oldest upscale resort area and is a mature beach-side town in the Southeastern coast of Bali. Sanur has quiet and relaxed atmosphere despite the abundance of restaurants, hotels and villas.
Sanur hotels and
villas are mainly medium and high class but you can find many budget hotels or villas in Sanur. In general terms, it is on par with Kuta but cheaper than Seminyak. Sanur tends to appeal most to middle-aged and older families, especially Europeans.
The Sanur area is sandwiched between the main Jalan Ngurah Rai bypass and the beach. One main route called Jalan Danau Tamblingan runs north to south through the town. Jalan Danau Tamblingan, the main street in Sanur, has the highest concentration of hotels and villas in Sanur, restaurants, art shops, a number of outlets for car, motorbike and bicycle rental. A large number of metered taxis patrol the streets looking for passengers.
Sanur is also a great place to walk. Distances are not large, the streets are relatively quiet, and there is a splendid, paved beach front path which runs the whole length of the district. Sanur also offers good range of water sports activities. Sanur is a town with a wealth of cultural, natural and historical attractions, as well as the obvious shopping and beach-related sights.
Sanur is just 20-minute drive from Kuta, Legian and Seminyak as well as Ngurah Rai International Airport and 30-minute drive to Ubud.
Hotels Villas Travel Tips
Hotels Villas Blog
All Destinations
Top Selling Cities
";
while ($org_cit = mysql_fetch_array($result_cit, MYSQL_ASSOC)) {
$u_slug = toAscii($org_cit["org_city"]);
if(strpos(strtolower($org_cit["org_state"]), "java") || strtolower($org_cit["org_state"]) == "jakarta" || strtolower($org_cit["org_state"]) == "yogyakarta"){
$h_state = "java";
}elseif(strtolower($org_cit["org_state"]) == "west nusa tenggara"){
$h_state = "west-nusa-tenggara";
}elseif(strpos(strtolower($org_cit["org_state"]), "sulawesi")){
$h_state = "sulawesi";
}elseif(strpos(strtolower($org_cit["org_state"]), "kalimantan")){
$h_state = "kalimantan";
}elseif(strtolower($org_cit["org_state"]) == "east nusa tenggara"){
$h_state = "east-nusa-tenggara";
}elseif(strpos(strtolower($org_cit["org_state"]), "sumatra")){
$h_state = "sumatra";
}else{
$h_state = $org_cit["org_state"];
}
//$url_cit = "
";
$url_cit = " ";
echo "".$url_cit.$org_cit["org_city"]." ";
if ($iii == 10){echo "
"; }else{
$iii++;
}
}
echo " ";
?>
Subscribe to get special offers
Travel Tool
true (at main header page) or false (at others)
########################################################################################
function form_search_hotel_auto($main_header){
global $PHP_SELF;
global $HTTP_POST_VARS;
global $type;
global $location;
global $config_abl;
global $checkin;
global $nights;
global $rooms;
global $org;
global $gmode;
global $gtype;
global $ghotel;
global $glocation;
global $grategt;
global $gratelt;
global $gcheckin;
global $gnights;
global $grooms;
global $gsort;
global $affiliate_id;
global $gview;
$hotel = $HTTP_POST_VARS["Hotel"];
if($hotel==""){$hotel = $ghotel;}
if($hotel==""){$hotel = "all";}
if ($hotel == "all"){
$type = $HTTP_POST_VARS["Type"];
if($type==""){$type = $gtype;}
if($type==""){$type = "all";}
//$location = $HTTP_POST_VARS["Location"];
if($location==""){$location = $glocation;}
if($location==""){$location = "all";}
$rate_gt = $HTTP_POST_VARS["Rate-gt"];
if($rate_gt==""){$rate_gt = $grategt;}
if($rate_gt==""){$rate_gt = $config_abl["default_rate_gt"];}
$rate_lt = $HTTP_POST_VARS["Rate-lt"];
if($rate_lt==""){$rate_lt = $gratelt;}
if($rate_lt==""){$rate_lt = $config_abl["default_rate_lt"];}
}else{
$type = "";
$location = "";
$rate_gt = "all";
$rate_lt = "all";
}
$nights = $HTTP_POST_VARS["nights"];
if($nights==""){$nights = $gnights;}
if ($nights==""){$nights=$config_abl["default_nights"];}
$rooms = $HTTP_POST_VARS["rooms"];
if($rooms==""){$rooms = $grooms;}
if ($rooms==""){$rooms=$config_abl["default_rooms"];}
if($checkin==""){$checkin = $gcheckin;}
if(strlen($checkin)!=10){$checkin = "";}
$sortby = $HTTP_POST_VARS["sortby"];
if($sortby==""){$sortby = $gsort;}
if($sortby==""){$sortby = "0";}
$view = $HTTP_POST_VARS["view"];
if($view==""){$view = $gview;}
if($view==""){$view = "0";}
$ID = $org["id"];
$submit_title = "Search";
$hidden_fields = "
";
$form_action = "/hotel/search.html";
if ($ID != ""){
$type = $org["type"];
$hotel = $org["name"];
$location = $org["city"];
$submit_title = "Check Rooms Availability";
$form_action = "/".$type."/".$type."_detail/super_saver/".$ID.".html";
$hidden_fields = "
";
$hidden_fields .= "
";
$hidden_fields .= "
";
}
$hidden_fields .= "
";
//list city dalam combo box
/*$sqlcity = "SELECT DISTINCT org_city,org_state FROM organization order by org_state,org_city ";
$resultcity = open_mysql ("abldata", $sqlcity);
$listcity = "
";
$listcity .= "All City ";
while ($orgCity = mysql_fetch_array($resultcity, MYSQL_ASSOC)) {
if($location != "" && strtolower($orgCity["org_city"])==strtolower($location)){
$listcity .= "".$orgCity["org_state"]." -> ".$orgCity["org_city"]." ";
}else{
$listcity .= "".$orgCity["org_state"]." -> ".$orgCity["org_city"]." ";
}
}
$listcity .= " \n";
$resultcity = open_mysql ("close"); */
$sqlcity = "SELECT DISTINCT org_city,org_state,org_country FROM organization order by org_country,org_state,org_city ";
$resultcity = open_mysql("abldata", $sqlcity);
$listcity = "
";
$listcity .= "All City ";
while ($orgCity = mysql_fetch_array($resultcity, MYSQL_ASSOC)) {
if ($location != "" && strtolower($orgCity["org_city"]) == strtolower($location)) {
$listcity .= "" . $orgCity["org_country"] .
" -> " . $orgCity["org_state"] .
" -> " . $orgCity["org_city"] . " ";
} else {
$listcity .= "" . $orgCity["org_country"] .
" -> " . $orgCity["org_state"] .
" -> " . $orgCity["org_city"] . " ";
}
}
$listcity .= " \n";
$resultcity = open_mysql("close");
$arr_type = array(0=>"hotel", 1=>"villa", 2=>"preferred", 3=>"homestay", 4=>"hotdeals", 5=>"all");
if ($type==""){$type = "all";}
$output_type = '
';
for ($i=0;$i<=5;$i++){
if ($arr_type[$i] == $type){
$output_type .= ''.ucwords($arr_type[$i]).' ';
}else{
$output_type .= ''.ucwords($arr_type[$i]).' ';
}
}
$output_type .= ' ';
$bgcolor="#CCCCCC";
if ($type=="hotdeals"){$bgcolor="#CCFFCC";}
if ($checkin==""){
$tomorrow = mktime (0,0,0,date("m"),date("d")+$config_abl["default_start_checkin"],date("Y"));
$checkin = date("Y-m-d",$tomorrow);
}else{
#validate the date;
$checkin = date ("Y-m-d", mktime (0,0,0,substr($checkin,5,2)+0,substr($checkin,8,2)+0,substr($checkin,0,4)));
}
$org["checkin"] = $checkin;
$org["rooms"] = $rooms;
$org["nights"] = $nights;
$bln = (int) substr($checkin,5,2);
$thn = (int) substr($checkin,0,4);
$dt = (int) substr($checkin,8,2);
$output_ci = '
';
for ($i=1;$i<=12;$i++){
$month_name = date("F",mktime (0,0,0,$i,date("n"),date("Y")));
if ($i == $bln){
$output_ci .= ''.$month_name.' ';
}else{
$output_ci .= ''.$month_name.' ';
}
}
$output_ci .= ' ';
$output_ci .= '
';
for ($i=1;$i<=31;$i++){
if ($i == $dt){
$output_ci .= ''.$i.' ';
}else{
$output_ci .= ''.$i.' ';
}
}
$output_ci .= ' ';
$output_ci .= '
';
if ($thn>BaliNow("Y")){$min=$thn-BaliNow("Y");}else{$min=0;}
for ($i=$thn-$min;$i<=$thn+1;$i++){
if ($i == $thn){
$output_ci .= ''.$i.' ';
}else{
$output_ci .= ''.$i.' ';
}
}
$output_ci .= ' ';
$output_ni = '
';
for ($i=1;$i<=$config_abl["max_nights"];$i++){
if ($i == $nights+0){
$output_ni .= ''.$i.' ';
}else{
$output_ni .= ''.$i.' ';
}
}
$output_ni .= ' ';
$output_ro = '
';
for ($i=1;$i<=$config_abl["max_rooms"];$i++){
if ($i == $rooms+0){
$output_ro .= ''.$i.' ';
}else{
$output_ro .= ''.$i.' ';
}
}
$output_ro .= ' ';
$arr_sort = array(0=>"Hits", 1=>"Name", 2=>"Room Rate", 3=>"Location", 4=>"Star");
$output_sort = '
';
for ($i=0;$i<=3;$i++){
if ($i == $sortby){
$output_sort .= ''.ucwords($arr_sort[$i]).' ';
}else{
$output_sort .= ''.ucwords($arr_sort[$i]).' ';
}
}
$output_sort .= ' ';
if($gmode=="availability"){$view="1";}
$arr_sava = array(0=>"All", 1=>"Instant Confirm");
/*$output_sava = '
';
for ($i=0;$i<=1;$i++){
if ($i == $view){
$output_sava .= ''.ucwords($arr_sava[$i]).' ';
}else{
$output_sava .= ''.ucwords($arr_sava[$i]).' ';
}
}
$output_sava .= ' ';
*/
//GANTI DENGAN RADIO GROUP
$output_sava .= '
All ';
if ($view !=1){
$output_sava .= '
Instant Confirm ';
}else{
$output_sava .= '
Instant Confirm ';
}
if (!$main_header){
if ($ID != ""){
//check availability for hotel that selected
echo <<
EOT;
}else{
//if id == blank so nothing to display
}
}else{
if ($ID!=""){$hotel = "all";}
echo <<
Hotel Name
Destination
{$listcity}
Check-in date
{$output_ci}
Night
{$output_ni}