php ajax下拉列表,php ajax 仿google 下拉框代码一

php ajax 仿google 下拉框代码一,这里php代码

header('Content-Type:text/html;charset=utf-8');

require('../../admin/include/db_conf.php');

if($_POST['add']){

$keyword = trim($_POST['keyword']);

if(empty($keyword)){

header("LOCATION: suggest.html");

exit;

}

$db = db_connect();

$db->query("set names 'gb2312'");

$sql = "select*from suggest where keyword = '$keyword'";

if($db->query($sql)->num_rows>0){

header("LOCATION: suggest.html");

exit;

}

$num = rand(15, 2008);

$sql = "insert into suggest values(NULL, '$keyword', $num)";

$db->query($sql);

$db = NULL;

header("LOCATION: suggest.html");

exit;

}

$keyword = $_POST['keyword'];

if(empty($keyword)){

echo 'null';

exit;

}

$db = db_connect();

$db->query("set names 'utf8'");

$sql = "select *from suggest where keyword REGEXP '^$keyword'  order by id desc limit 0, 15";

$result = $db->query($sql);

if($result->num_rows<1){

echo 'null';

exit;

}

$arr = array();

while($rows=$result->fetch_object()){

$keyword = $rows->keyword;

$arr[]="['$keyword', '$rows->num ".iconv('gb2312','utf-8','结果')."']";

}

$arr = '['.implode(',',$arr).']';

echo $arr;

?>