";
$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
Denpasar is the largest city and capital of the island of Bali. Denpasar is a bustling, multi-cultural city and bristling with temples, palaces and museums. This is also a notable shopping city with options to please even the most jaded of world shoppers. The city center is just one-hour drive from Ngurah Rai International Airport and 20-30 minutes away from Kuta, Legian and Seminyak; Sanur is just 15 minutes to the east and Ubud about 30 minutes to the north.
There are many small budget hotels in Denpasar which are primarily aimed at domestic business travellers. These are reasonably priced and comfortable enough.
Denpasar budget
hotels are mainly located around the city center, Jalan Kepundung, Jalan Sudirman and Jalan Mahendradatta. Mid-range Denpasar hotels can be found in Jalan Teuku Umar Barat, Jalan Sudirman and city center. Deluxe Denpasar hotels are mainly located at Jalan Teuku Umar, Jalan Gatot Subroto and Jalan Gatot Subroto Barat.
Denpasar is and its occupants are outstandingly friendly. You will be off the beaten tourist track here, so bring lots of time for a chat with the locals and a decent map of town. You can see many of the main sights comfortably on foot, especially around the city center including Bali Museum, Puputan Badung Park and Jagatnatha Temple.
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}