php 模糊关键字查询,jq.ajax+php+mysql实现关键字模糊查询(示例讲解)

*{margin:0;padding:0;}

.text{width:200px;height:30px;line-height:30px;font-size:14px;outline:none;}

ul{width:200px;height:auto;border:1px solid #999;border-top:none;}

ul li{width:200px;height:30px;line-height:30px;font-size:14px;}

li:hover{background:#ddd;}

$(".text").bind("input", function() {

if($(this).val().length>0){

search();

}else{

$(".sea").html('');

}

})

function search(){

$.ajax({

type:"GET",

url:"sea.php",

data:{"text":$(".text").val()},

success:function(response){

//转换成json对象

eval("var json="+response);

//console.log(json)

var str="";

for(var i=0;i

str += "

" + json[i].sea + "";

}

$(".sea").html(str);

}

})

}

sea.php

$con = mysqli_connect("localhost","username","password");

if(!$con){

echo "数据库链接失败";

exit;

}

mysqli_select_db($con,'jwhuang');

mysqli_query($con,'set names utf-8');

$text= isset($_GET['text']) ? trim($_GET['text']) : '';

$result=mysqli_query($con,"select * from search where sea LIKE '{$text}%' ");

$search=array();

while($row=mysqli_fetch_assoc($result)){

//判断是否有对应的数据

if(!$row){

$search='';

exit;

}else{

//对查询关键字进行标记

$row['sea'] = str_replace($text, '' .$text. '', $row['sea']);

$search[]=$row;

}

}

echo json_encode($search);

?>