最新下载
热门教程
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
php+ajax 仿google 下拉框代码一
时间:2008-10-23 编辑:简简单单 来源:一聚教程网
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;
?>
-
上一个: 文件上传类
相关文章
- php+ajax 仿google 下拉框代码二 10-23
- php+ajax 仿google 下拉框代码三 10-23
- PHP导出数据超时的优化建议解读 10-31
- PHP之mysql位运算解析 10-31
- Laravel实现登录跳转功能解析 10-31
- php双向队列解读 10-31