query('select count(*) from library.messages')->fetchcolumn(0);
$sql = 'select * from library.messages'. limit $perpage offset .($offset-1);
$result = $db->query($sql);
if ($result)
{
foreach ($result->fetchall() as $row)
{
echo subject: .$row[5].
;
}
}
else
{
$error = $db->errorinfo();
echo error happened...$error[2];
exit();
}
buildindex($perpage, $total);//1,50,3500
/////////////////////////////////////////////////////////////////
function buildlink($index, $offset)
{
echo $index;
}
function buildindex($perpage, $total)
{
$separator = '|';
//buildlink($offset==1, 'fetchcolumn(0);
$sql = 'select * from library.messages limit '. ($offset -1)*$perpage., $perpage ;
$result = $db->query($sql);
if ($result)
{
foreach ($result->fetchall() as $row)
{
echo subject: .$row[5].
;
}
}
else
{
$error = $db->errorinfo();
echo error happened...$error[2];
exit();
}
$numpage = $total%$perpage;
if($total%$perpage) $numpage++;
$cur = $offset;
if ($cur 0)
{
echo prev page
;
}
?>
问题如下：每次点击下一页，或者上一页，显示的都是同样的内容，即首页内容。 当数据表的内容有3000行...是怎么回事啊？
------解决方案--------------------
42 行有 ...setpage02.php?offset=$i'>$i....
而第 2 行是 $offset = isset($_get['ofset']) ? intval($_get['offset']) : 1;
知道问题在哪了吧？