Detailed introduction to PHP implementation of previous page next page page turning code example

DetailsIntroductionPHP implementation of previous page next page page turning code example

、<?PHP
//1，将数据库的所有记录查询出来，然后再一页一页的显示
$link=mysql_connect(&#39;localhost&#39;,&#39;root&#39;,&#39;123&#39;) ; 
mysql_select_db(&#39;yanhua&#39;);

mysql_query("set names utf8");

//首先要=知道每页显示几条记录 pagesize
//第几页 page
//下一页要掠过之前的几个记录 offset
/*
0 0 0 0 0 0 0 0 0
page offset pagesize
1 0 2
2 2 2
3 4 2
4 6 2
*/
//我们还是通过传递page参数的形式来判断当前是第几页
//?page = 1 第一页 ?page=2 第二页 page=3 第三也
$pagesize = 2;
$page = isset($_GET[&#39;page&#39;])?$_GET[&#39;page&#39;]:1;
//通过page 和 pagesize 求出offset
$offset = $pagesize * ($page-1);
include ("libs/Smarty.class.php");
$smarty = new Smarty();
$smarty->reInitSmarty("demo/templates","demo/templates_c","demo/config","demo/cache");
$array_new=array();
$sql = "select * from news limit $offset,$pagesize";
$res = mysql_query($sql);
while($row = mysql_fetch_assoc($res)){
$array_new[]=$row; 
}
//var_dump($array_new);
$smarty->assign("array_new",$array_new);
$smarty->display("news.tpl");
$sql = "select count(*) as total from news";
$result = mysql_query($sql);
//总的记录数
$row = mysql_fetch_assoc($result);
$total_rows = $row[&#39;total&#39;];
$total_page = ceil($total_rows/$pagesize);
echo &#39;<a href="new.php">首页</a>&#39;;
//第一页的时候没有上一页
if($page > 1){
echo &#39;<a href="new.php?page=&#39;.($page-1).&#39;">上一页</a>&#39;;
echo &#39; &#39;;
}
//尾页的时候不显示下一页
if($page < $total_page){
echo &#39;<a href="new.php?page=&#39;.($page+1).&#39;">下一页</a>&#39;;
echo &#39; &#39;;
}
echo &#39;<a href="new.php?page=&#39;.$total_page.&#39;">尾页</a>&#39;;

The above is the detailed content of Detailed introduction to PHP implementation of previous page next page page turning code example. For more information, please follow other related articles on the PHP Chinese website!