php网页代码问题
来源:百度知道 编辑:UC知道 时间:2024/05/15 10:30:20
<?php
$pageNo = intval($_REQUEST['page']);
$sql = "select count(*) from news WHERE BigClassName = '" . str_replace("'","''",$rs__MMColParam) . "' order by id desc";
$totalNum = dbSelectOne($sql);
$pageSize = 20;
if($totalNum <= 0)
{
echo "没有记录";
}
else
{
$totalPage = ceil($totalNum / $pageSize);
$offset = $pageNo*$pageSize+1;
if($pageNo <= 0)
{
$offset = 0;
$pageNo = 1;
}
elseif ($pageNo >= $totalPage)
{
$offset = ($totalPage-1)*$pageSize+1;
}
$sql = "select * from news WHERE BigClassName = '" . str_replace("'","''",$rs__MMColParam) . "' order by ID DESC limit $offset,$pageSize";
$news = dbSelect($sql);
foreach($news as $RS)
{
?>
<tr>
$pageNo = intval($_REQUEST['page']);
$sql = "select count(*) from news WHERE BigClassName = '" . str_replace("'","''",$rs__MMColParam) . "' order by id desc";
$totalNum = dbSelectOne($sql);
$pageSize = 20;
if($totalNum <= 0)
{
echo "没有记录";
}
else
{
$totalPage = ceil($totalNum / $pageSize);
$offset = $pageNo*$pageSize+1;
if($pageNo <= 0)
{
$offset = 0;
$pageNo = 1;
}
elseif ($pageNo >= $totalPage)
{
$offset = ($totalPage-1)*$pageSize+1;
}
$sql = "select * from news WHERE BigClassName = '" . str_replace("'","''",$rs__MMColParam) . "' order by ID DESC limit $offset,$pageSize";
$news = dbSelect($sql);
foreach($news as $RS)
{
?>
<tr>
$offset = $pageNo*$pageSize+1;是不是有问题?
换成$offset=($pageNo-1)*$pageSize;试试
把每个page=几的sql都打出来。
把sql 运行 看看是不是要的数据。。。
之就知道什么问题了。。。
配合改改。。limit参数。。
//---------原文----------
$offset = $pageNo*$pageSize+1;
if($pageNo <= 0)
{
$offset = 0;
$pageNo = 1;
}
elseif ($pageNo >= $totalPage)
{
$offset = ($totalPage-1)*$pageSize+1;
}
//---------------------
//------修改--------
if($pageNo < 1)
{
$pageNo = 1;
}
if ($pageNo > $totalPage)
{
$pageNo = $totalPage;
}
$offset = ($pageNo-1)*$pageSize;
//----------------------