你是说查询出结果然后分页显示吧?
php重是这样实现的:
$sql = "select id,company,roomid,indate,telephone,contanctman from company_info";
$db->query($sql);
$num = $db->nf();
if($num!=0)
{
if(empty($_GET['offset']) || $_GET['offset'] < 0)
{
$_GET['offset'] = 0;
}
$sql .=sprintf(" limit %d,10",$_GET['offset']);
$db->query($sql);
while($row = $db->records())
{
show_recoders($row);
}
$pages = ceil($num/10);
echo "<tr bgcolor=$trbgcolor><td align=center colspan=5>";
echo "<font color=#ff0000>〖共{$pages}页〗</font>\n\n\n\n";
if($_GET['offset'] >=10) //$offset大于9,在第二页面以上就会显示前一页
{
$preoffset = $_GET['offset']-10;
echo sprintf("<a href=%s?offset=%d>前一页</a> \n",$_SERVER['PHP_SELF'],$preoffset);
}
for($i=1; $i<=$pages; $i++)
{
$newoffset = 10*($i-1);
echo sprintf("<a href=%s?offset=%d><b><font size=2>%d</b></font></a> \n",$_SERVER['PHP_SELF'],$newoffset,$i);
}
if ($pages!=0 && ($_GET['offset']/10+1) < $pages)
{
echo sprintf("<a href=%s?offset=%d>下一页</a>\n",$_SERVER['PHP_SELF'],$_SEVER['PHP_SELF']+10);
}
echo "</td></tr></table>";
}
php重是这样实现的:
$sql = "select id,company,roomid,indate,telephone,contanctman from company_info";
$db->query($sql);
$num = $db->nf();
if($num!=0)
{
if(empty($_GET['offset']) || $_GET['offset'] < 0)
{
$_GET['offset'] = 0;
}
$sql .=sprintf(" limit %d,10",$_GET['offset']);
$db->query($sql);
while($row = $db->records())
{
show_recoders($row);
}
$pages = ceil($num/10);
echo "<tr bgcolor=$trbgcolor><td align=center colspan=5>";
echo "<font color=#ff0000>〖共{$pages}页〗</font>\n\n\n\n";
if($_GET['offset'] >=10) //$offset大于9,在第二页面以上就会显示前一页
{
$preoffset = $_GET['offset']-10;
echo sprintf("<a href=%s?offset=%d>前一页</a> \n",$_SERVER['PHP_SELF'],$preoffset);
}
for($i=1; $i<=$pages; $i++)
{
$newoffset = 10*($i-1);
echo sprintf("<a href=%s?offset=%d><b><font size=2>%d</b></font></a> \n",$_SERVER['PHP_SELF'],$newoffset,$i);
}
if ($pages!=0 && ($_GET['offset']/10+1) < $pages)
{
echo sprintf("<a href=%s?offset=%d>下一页</a>\n",$_SERVER['PHP_SELF'],$_SEVER['PHP_SELF']+10);
}
echo "</td></tr></table>";
}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货