Home > Article > Backend Development > php simple paging, php paging_PHP tutorial
php simple paging, php paging_PHP tutorial
- WBOYOriginal
- 2016-07-12 09:00:52980browse
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：Example explanation of the image upload function in the WordPress backend, wordpress example explanation_PHP tutorialNext article：Example explanation of the image upload function in the WordPress backend, wordpress example explanation_PHP tutorial