";
$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
Tabanan is the capital town of the regency of Bali with the same name, located in central Bali area. Tabanan is well-known for its beautiful rice terraces, rolling green landscapes, hills and especially the majestic Mount Batukaru, Bali's second highest peak at 2,276 meters. In the last decade, Tabanan south coast has been rapidly developed due to the spread of private villas from Canggu in the east.
Most of Tabanan hotels and villas are concentrated on the south coast and up north in Antosari-Pupuan area. Tabanan hotels and villas in the northern area are mainly eco resort and green hotels, and upscale Tabanan hotels can be found on the south coast area. If you want to stay in a villa, most Tabanan villas are located close to Canggu in Perean, Beraban and south coast area; but there are also some private villas in Pupuan area.
Tabanan can be reached with the main coastal road from Denpasar to West Bali and can be directly accessed from the main tourist centers in South Bali. The quiet surfing village at Medewi Beach is less than one hour from Tabanan while the ferry port at Gilimanuk can be reached in two hours.
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}