php过滤搜索内容mysql并显示,PHP+MYSQL+JQUERY实现内容的筛选或实时搜索

include ("menu.php");

include ("head.php");

?>

$(function(){

$("#filterName").keyup(function(){

$("table tbody tr")

.hide()

.filter(":contains('"+( $(this).val() )+"')")

.show();

}).keyup();

})

通讯录

账号姓名手机电话科室级别编号

$sqlgroups="select * from user order by jibie";

$resultgroups=mysql_query($sqlgroups);

$numrows=mysql_num_rows($resultgroups);

if ($numrows>0)

{

while($data=mysql_fetch_array($resultgroups))

{

?>

<?php echo $data['username'];?><?php echo $data['realname'];?><?php echo $data['mobile'];?><?php echo $data['bgdh'];?><?php echo $data['keshi'];?><?php echo $data['jibie'];?><?php echo $data['bianhao'];?>

}

}?>

require('foot.php');

?>