通过ajax查询mysql数据并将查询数据返回

　　通过ajax查询mysql数据，并将返回的数据显示在待选列表中，再通过选择最终将选项加入到已选区，可以用在许多后台管理系统中。

MYSQL数据表结构

CREATE TABLE IF NOT EXISTS `t_mult` (

`id` int(11) NOT NULL auto_increment,

`username` varchar(32) NOT NULL,

`phone` varchar(20) NOT NULL,

PRIMARY KEY (`id`)

) ENGINE=MyISAM DEFAULT CHARSET=utf8;

调用Multiselect插件

$("#liOption").multiselect2side({

selectedPosition: 'right',

moveOptions: false,

labelsx: '待选区',

labeldx: '已选区'

});

Ajax查询数据操作

$("#searchOption").click(function(){

var keys=$("#keys").val();

$.ajax({

type: "POST",

url: "action.php",

data: "title="+keys,

success: function(msg){

if(msg==1){

$("#msg_ser").show().html("没有记录！");

}else{

$("#liOptionms2side__sx").html(msg);

$("#msg_ser").html("");

}

}

});

$("#msg_ser").ajaxSend(function(event, request, settings){

$(this).html("");

});

});

HTML代码

<form id="sel_form" action="post.php" method="post">

<p><input type="text" name="keys" id="keys" value="输入姓名或手机号码" onclick="this.value=''" />

<input type="button" id="searchOption" value="搜索" /> <span id="msg_ser"></span></p>

<div id="sel">

<select name="liOption[]" id='liOption' multiple='multiple' size='8'>

</select>

</div>

<input type="submit" value="提 交" />

</form>

PHP代码

$conn=mysql_connect("localhost","root","");

mysql_select_db("demo",$conn);

mysql_query("SET names UTF8");

$keys=trim($_POST['title']);

$keys=mysql_real_escape_string($keys,$conn);

if(!empty($keys)){

$sql="select * from t_mult where username like '%$keys%' or phone='$keys'";

}else{

$sql="select * from t_mult";

}

$query=mysql_query($sql);

$count=mysql_num_rows($query);

if($count>0){

while($row=mysql_fetch_array($query)){

$str.="<option value='".$row['id']."'>".$row['username']."-".$row['phone']."</option>";

}

echo $str;

}else{

echo "1";

}

$selID=$_POST['liOptionms2side__dx'];

if(!empty($selID)){

$str=implode(",",$selID);

echo $str;

}else{

echo "没有选择任何项目！";

}