<?php
$path  = $_SERVER['DOCUMENT_ROOT'];
include_once  $path."/connect_db.php";


//get the GET parameter from URL
$name = $_GET["hint"];
$k_id=1;
$prev_id=0;

$loc_sql = $connect->query("SELECT area_id,area_name,area_parent_name,area_lon,area_lat FROM locations WHERE area_name LIKE '{$name}%' ORDER BY pop DESC, area_name ASC LIMIT 20");
/*while($loc_row = $loc_sql->fetch_array()){
	
	$display      = preg_replace('/(' . $name . ')/i','<b>\1</b>',$loc_row['area_name'].', '.$loc_row['area_parent_name']); // to make matching string bold
	echo '<div id="k_'.$k_id.'" onmouseover="set_area('.$k_id.','.$prev_id.')" onclick="cl(\'ff_2\');">'.$display.'</div>';
	echo '<span id="k_'.$k_id.'_hid" style="display:none;">'.$loc_row['area_lon'].'|'.$loc_row['area_lat'].'</span>';
	echo '<span id="k_'.$k_id.'_aid" style="display:none;">'.$loc_row['area_id'].'</span>';
	$k_id++;
	$prev_id++;
}*/
while($loc_row = $loc_sql->fetch_object()){
$data[] = $loc_row;
}
echo json_encode(['status'=>'success',"data"=>$data]);
?>