require_once 'conn.php';
//1.查询总记录数
require_Once "DbHelper.class.php";
$arr=array("host"=>"localhost","uid"=>"root","pwd"=>"","dbname"=>"aaa","charset"=>"utf8");
$db=new DbHelper($arr);
$recordcount=$db->getRecordCount("select count(*) from user");
//2.设置每页大小
$perpage=5;
if(isset($_GET['jieshou'])){
$perpage=$_GET['jieshou'];
}
//3.创建分页类对象
require_once "Pager.class.php";
$pager=new Pager(array("total"=>$recordcount,"perpage"=>$perpage));
if (isset($_GET['key'])) {
$key = $_GET['key'];
$sql="select * from user where (uname like '%$key%') or (contacts like '%$key%') or (tele like '%$key%') or
(mobile_phone like '%$key%') or (qq like '%$key%') or (email like '%$key%') or (url like '%$key%') or
(remarks like '%$key%') order by id asc limit $pager->offset,$perpage";
} else{
$sql="select * from user order by id asc limit $pager->offset,$perpage ";
}
$arr=$db->execDql($sql);
echo "
$peopie=array("id"=>"id","uname"=>"uname","contacts"=>"contacts","tele"=>"tele",
"mobile_phone"=>"mobile_phone","qq"=>"qq","email"=>"email","url"=>"url","remarks"=>"remarks");
foreach ( $peopie as $mychars )
sort($peopie);
rsort($peopie);
echo "
id 客户名 联系人 电话 手机 QQ邮箱 地址 备注 ";
foreach ($arr as $row ) {
?>
<?php echo $row['id'];?><?php echo $row['uname'];?><?php echo $row['contacts'];?><?php echo $row['tele'];?><?php echo $row['mobile_phone'];?><?php echo $row['qq'];?><?php echo $row['email'];?><?php echo $row['url'];?><?php echo $row['remarks'];?>&jieshou=<?php echo $perpage;?>"'>删除修改
}
sort($peopie);
echo "
";
?>
标记地方改怎么改？
