Home > Backend Development > PHP Tutorial > PHP example code to implement paging query

PHP example code to implement paging query

WBOY
Release: 2016-08-08 09:33:41
Original
935 people have browsed it

if(!$whichpage)
{  
$notepage=1;
}
else
{
$notepage=$whichpage;
}
$noterecs=0;
$pagesize=10;
$bbsconn=MySQL_connect("localhost","root");
mysql_select_db("rainwindy",$bbsconn);
$bbsresult=mysql_query("select * from bbs order by id desc",$bbsconn);
$rsnum=mysql_num_rows($bbsresult);
$pagecount=ceil($rsnum/$pagesize);
mysql_data_seek($bbsresult,($notepage-1)*10);
?>




    
      
      
      
      
      
   
while(($bbsrow=mysql_fetch_array($bbsresult)) && ($noterecs<=9))
{

?>

      
      
      
      
      
       

$noterecs=$noterecs+1;
}
?>
编号 用户名 发表人 文章标题 发表时间
" target="disp">








$pad=0;
for($counter=1;$counter<=$pagecount;$counter++)
{
if($counter>=10)
{  
$pad="";
}

echo("".$pad.$counter."  ");
}
?> 

以上就介绍了PHP实现分页查询的例子代码,包括了方面的内容,希望对PHP教程有兴趣的朋友有所帮助。

Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template