分页问题: 例:Basicinfolist.php中!应该加入分页的限制: (就你的代码:第95行下,96行上就加入): code=PHP]
while($total>=($currpage-1)*20 && $total<=($currpage*20) //实现限制每一页显示的数据条数
{//第109行下,第108行上加入
}[/code]
while($total>=($currpage-1)*20 && $total<=($currpage*20) //实现限制每一页显示的数据条数
{//第109行下,第108行上加入
}[/code]
你可以用mysql的limit语句来实现.
select * from table limit 0,30;
select * from table limit 30,30;
select * from table limit 60,30;
while($total>=($currpage-1)*20 && $total <=($currpage*20) //实现限制每一页显示的数据条数
{
//第109行下,第108行上加入
}
你用的指针分页阿,用limit分页可能快一点吧
看演示!<?php
require_once('../inc/connect.php');
if(isset($_GET['page'])){
$page=ceil($_GET['page']);
}
else{
$page = "1";
}
$key = $_REQUEST['key'];
$time1 = $_REQUEST['time1'];
$time2 = $_REQUEST['time2'];
if($key != "" && $time1 != "" && $time2 != ""){
$c = "where title like '%".$key."%' and time>='".$time1."' and time<='".$time2."'";
} else {
if ($key == "" && $time1 != "" && $time2 != "") {
$c = "where time>='".$time1."' and time<='".$time2."'";
}
if ($key == "" && $time1 == "" && $time2 != "") {
$c = "where time<='".$time2."'";
}
if ($key == "" && $time1 != "" && $time2 == "") {
$c = "where title like '%".$key."%' and time<='".$time2."'";
}
if ($key != "" && $time1 == "" && $time2 == "") {
$c = "where title like '%".$key."%'";
}
}
if($qs<$size)
{
$limty="";
}else{
$limty="LIMIT $qs,$size";
}$time1 = $_POST[time1];
$time2 = $_POST[time2];
$qs = $size*($page - 1);
//多选择删除
if($_REQUEST[scxz]){
$ids = array();
$ids = $_POST['checkbox'];
if($ids )
{
foreach($ids as $id)
{
$tmp[] = intval($id);
}
$ids = $tmp;
}
$ids = @implode(',',$ids);
$sqlds = "delete from new_article where id ='$ids'";
$result = mysql_query($sqlds);
}
//根据条件获取当前页码的信息
$sql="SELECT id,author,title,source,time,classify FROM new_article $c LIMIT $qs,$size";
$rs=mysql_query($sql);
//根据条件获取所有信息条数
$sqlcount="SELECT id,author,title,source,time,classify FROM new_article $c";
$fyrs = mysql_query($sqlcount);//获取文章总数
$num = mysql_num_rows($fyrs);
$pagecount = ceil($num/$size);//总页数有余数进一取整
$pages = "当前已显示所有文章";
if ($page > 1)
{
$pages='<a href="?page=1&key='.$key.'&time1='.$time1.'&time2='.$time2.'">首页</a>|<a href="?page='.($page-1).'&key='.$key.'&time1='.$time1.'&time2='.$time2.'">上一页</a>';
if ($page < $pagecount){
$pages.='<a href="?page='.($page+1).'&key='.$key.'&time1='.$time1.'&time2='.$time2.'">下一页</a>|<a href="?page='.$pagecount.'&key='.$key.'&time1='.$time1.'&time2='.$time2.'">尾页</a>';
}
}
elseif($pagecount==0)
{
$pages='老大你不添加文章,我去哪里给你找文章啊!';
}
elseif($page < $pagecount)
{
$pages='<a href="?page='.($page+1).'&key='.$key.'&time1='.$time1.'&time2='.$time2.'">下一页</a>|<a href="?page='.$pagecount.'&key='.$key.'&time1='.$time1.'&time2='.$time2.'">尾页</a>';
}?>累死我了!汗!这个应该符合你说的了吧!完全是用LINM一点高深的都没有用!