Home > Article > Backend Development > php 简单分页，php分页_PHP教程
php 简单分页，php分页_PHP教程
- WBOYOriginal
- 2016-07-12 09:00:52951browse
php 简单分页，php分页
$conn=mysql_connect("localhost","root","123");
mysql_select_db("qq",$conn);
mysql_query("set names utf8");
$length=5;
$pagenum=isset($_GET['page'])?$_GET['page']:1;
$totsql="select count(*) from q1";
$totarr=mysql_fetch_row(mysql_query($totsql));
$pagetot=ceil($totarr[0]/$length);
if($pagenum>=$pagetot){
$pagenum=$pagetot;
}
$offset=($pagenum-1)*$length;
$sql="select * from q1 order by id limit {$offset},{$length}";
$ret=mysql_query($sql);
echo "
echo "
| {$row['id']} | ";{$row['name']} | ";{$row['pass']} | ";
$prevpage=$pagenum-1;
$nextpage=$pagenum+1;
echo "
上|下
";echo "
mysql_close($conn);
?>
Statement：
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
Previous article：WordPress后台中实现图片上传功能的实例讲解，wordpress实例讲解_PHP教程Next article：简单了解WordPress开发中update_option()函数的用法，wordpressgetoption_PHP教程