php+ajax 仿google 下拉框代码一,这里php代码
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    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;
?>