php+ajax仿google下拉框代码一-PHP源码

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;
?>