<?php
$path  = $_SERVER['DOCUMENT_ROOT'];
include_once $path.'/connect_db.php';
//get the GET parameter from URL
$name = $_GET["hint"];
$num = $_GET["num"];
$j_id=1;
$prev_id=0;
$display = '';
//$cat_sql = mysql_query("SELECT cat_name,type FROM cats WHERE active='1' AND cat_name LIKE '%{$name}%' ORDER BY pop DESC LIMIT 20");
// $cat_sql = $connect->query("SELECT cat_name,type FROM cats WHERE cat_name LIKE '%{$name}%' ORDER BY pop DESC, cat_name ASC LIMIT 20") or die($connect->error);
$cat_sql = $connect->query("SELECT * FROM `google_suggest` WHERE `keyword` Like '{$name}% near me' ORDER BY pop DESC, keyword  ASC LIMIT 20") or die($connect->error);
/*while($cat_row = $cat_sql->fetch_array()){
	$db_catname=ucwords($cat_row['cat_name']);
	$type=$cat_row['type'];

	$dis = preg_replace('/(' . $name . ')/i', '<b>\1</b>', $db_catname); // to make matching string bold
	$display .= '<div id="j_'.$j_id.'" onmouseover="set_cat('.$j_id.','.$prev_id.',\''.$type.'\')" onclick="cl(\'ff\')">'.$dis.'</div>';
	$display .= '<span id="t_'.$j_id.'" style="display:none;">'.$type.'</span>';
	//echo '<div style="cursor:pointer;" onclick="updCatSrch(\''.$cat_row['cat_name'].'\')" style="font-weight:bold;">'.$cat_row['cat_name'].'</div>';
	$j_id++;
	$prev_id++;
}*/

function regex($str, $name){
	$pattern = "/(".$name.")/";
	$str = preg_replace($pattern, '<span class="highlight">$1</span>', $str);
 	return $str;
}

while($cat_row = $cat_sql->fetch_object()){
	$str = regex(str_replace(" near me", "", $cat_row->keyword), $name);
	$cat_row->keyword = trim($str);
	// $cat_row->keyword = trim(str_replace(" near me", "", $cat_row->keyword));
    $data[] = $cat_row;
}
echo json_encode(['status'=>'success',"data"=>$data]);
?>