$wherelist=array();
$urlist=array();
if(!empty($_get['title']))
{
$wherelist[]= title like '%.$_get['title'].%';
$urllist[]=title=.$_get['title'];
}
if(!empty($_get['keywords']))
{
$wherelist[]= keywords like '%.$_get['keywords'].%';
$urllist[]=keywords=.$_get['keywords'];
}if(!empty($_get['author']))
{
$wherelist[]= author like '%.$_get['author'].%';
$urllist[]=author=.$_get['author'];
}
$where=;
if(count($wherelist)>0)
{
$where= where .implode(' and ',$wherelist);
$url='&'.implode('&',$urllist);
}
//分页的实现原理
//1.获取数据表中总记录数
$sql=select count(*) from news $where ;
$result=mysql_query($sql);
$totalnum=mysql_num_rows($result);
//每页显示条数
$pagesize=5;
//总共有几页
$maxpage=ceil($totalnum/$pagesize);
$page=isset($_get['page'])?$_get['page']:1;
if($page $maxpage)
{
$page=$maxpage;
}
$limit= limit .($page-1)*$pagesize.,$pagesize;
$sql1=select * from news {$where} {$limit};
//$sql1=select * from news {$where} {$limit};
$res=mysql_query($sql1);
?>
标题：
关键字
作者：
编号
标题
关键字
作者
日期
内容
