sbf123官网

php+ajax 仿google 下拉框代码一

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

?phpheader(‘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_rows0){ 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_rows1){ 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;?

发表评论

电子邮件地址不会被公开。 必填项已用*标注

相关文章