86400*20
);
// backend options
$backendOptions = array(
'cache_dir' => 'cache' // Directory where to put the cache files
);
// make object
$cache = Zend_Cache::factory('Output',
'File',
$frontendOptions,
$backendOptions);
// make an id
$cacheID='area_other_80673';
// everything before this is not cached
if (!($cache->start($cacheID))) {
// begin cache
include($_SERVER['DOCUMENT_ROOT'].'/dbinfo.inc.php'); $mysqli=mysqli_connect('localhost',$username,$password,$database); mysqli_set_charset($mysqli,"utf8"); if (mysqli_connect_errno()) { trigger_error('Database connection failed: ' . mysqli_connect_error(), E_USER_ERROR);}
$query="SELECT countries_divided.country_divided_path, countries_divided.atoz_cap, ahotels.country_id, ahotels.area_name, ahotels.area_name_path, area_name2, ahotels.city_id, city_name, city_links, city_name_lower, city_name_path, city_map, ad1_url, ad1_img_src, ad1_alttext, img2, US_state, state_name, state_name_lower, ahotels.country_id, ahotels.country_name, ahotels.country_name_lower, ahotels.continent_name, ahotels.continent_name_lower FROM ahotels
LEFT JOIN agoda_cities ON ahotels.city_id = agoda_cities.city_id
LEFT JOIN ahotels_img ON ahotels.hotel_id = ahotels_img.hotel_id
LEFT JOIN agoda_areasx ON ahotels.area_name_path = agoda_areasx.area_name_path
LEFT JOIN countries_divided ON ahotels.country_id = countries_divided.country_id AND regexp_cd LIKE CONCAT('%',LEFT(ahotels.city_name_lower , 1),'%')
WHERE ahotels.area_name_path = 'asiahotels/indonesiahotels/tanatorajahotels/otherhotels'
LIMIT 1";
$result = mysqli_query($mysqli,$query) or trigger_error("Query Failed! SQL: $query - Error: ". mysqli_error($mysqli), E_USER_ERROR);
while($row = mysqli_fetch_assoc($result)) {
$ad1_url = $row['ad1_url'];
$ad1_img_src = $row['ad1_img_src'];
$ad1_alttext = $row['ad1_alttext'];
$img2 = $row['img2'];
$area_id = '80673';
$area_name2 = $row['area_name2'];
$area_name_lower = 'other';
$area_name_path = $row['area_name_path'];
$city_links = $row['city_links'];
$city_map = $row['city_map'];
$city_name = $row['city_name'];
$city_name_lower = $row['city_name_lower'];
$city_name_path = $row['city_name_path'];
$country_name = $row['country_name'];
$country_divided_path = $row['country_divided_path'];
$atoz_cap = $row['atoz_cap'];
$US_state = $row['US_state'];
$state_name = $row['state_name'];
$state_name_lower = $row['state_name_lower'];
$continent_name = $row['continent_name'];
$country_name_lower = $row['country_name_lower'];
$continent_name_lower = $row['continent_name_lower'];
$city_id = $row['city_id'];
$country_id = $row['country_id'];
if(!empty($area_name2)) :
$area_name = $area_name2;
else :
$area_name = $row['area_name'];
endif;
include($_SERVER['DOCUMENT_ROOT'].'/fluidarea6.min.php');
}
// end cache
$cache->end();
}
// everything after this is not cached
?>