<?php
$path  = $_SERVER['DOCUMENT_ROOT'];
include_once $path.'/connect_db.php';
include_once $path.'/ajax/singular.php';
//get the GET parameter from URL
$name = addslashes($_GET["hint"]);
$num = addslashes($_GET["num"]);

if (empty($name)) {
	die();
}

// if (empty($num)) {
// 	die();
// }

$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 15") 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++;
}*/
$data = array();
while($cat_row = $cat_sql->fetch_array()){
    $cat = ucwords(trim($cat_row['cat_name']));
    $cat = Inflect::singularize($cat);

	if(!in_array($cat, $data)){
		array_push($data, $cat);
	}
}
echo json_encode($data);
?>