Example of paging using php and mysql

We all know that the implementation of PHP paging needs to cooperate with the data in the database to achieve the effect. In the previous article, we also gave you a brief introduction, so how does PHP+mysql achieve the paging effect? Well, let’s take you through it today!

The statement to display data in paging in mysql is: limit 5,1. 5 indicates the search starting position, 1 indicates displaying 1 page

So in PHP, the previous page and the next page must be implemented The page needs to pass a data page to the limit, and it can be paging.

can be understood as three steps:

1) Connect to the database, and display the data on the front end;

2) Pass page (page number value) from the front end to php. Here we also need to determine the page number that meets the range: that is, it is not less than 1 and not greater than the total number of pages;

3) PHP obtains the page number, makes a judgment, performs the corresponding -+ operation, and changes the limit value.

ps: The data has been built in the database, and php here is only responsible for the connection.

First you need to know how to display the information in the database on the front end:

php file:

//连接数据库:
$link = mysqli_connect("localhost","root","123456","test") or die ("错误：连接数据库失败");   //一次为：服务器，用户名，密码，库名
mysqli_query($link,"set names 'utf8'"); //输出的编码方式，这句一定要有。

//连接表:
$sql = "SELECT * FROM wordspace WHERE sa_id IS NOT NULL";   //mysql查询语句
$sqlcount = mysqli_query($link,$sql) or die ("查询失败");  //将其输出.
$info = mysqli_fetch_ array($sqlcount);
while($info){
	$result[ ] = $info;  //传值给一个数组
}

mysqli_free_result($info);  //查询完后要释放该表
mysqli_close($link);  //关闭数据库

Display the array just obtained from the database on the front end.

<table border="1">
	<tr>
		<td>id</td>
		<td>Price</td>
		<td>customer</td>
	</tr>
<!---用php将数据显示-->
	<?php foreach($result as $val)   {?>
	<tr>
		<td><?php echo $val[&#39;id&#39;];?></td>
		<td><?php echo $val[Price&#39;];?></td>
		<td><?php echo $val[&#39;customer&#39;];?></td>
	</tr>
	<?php  }  ?>
</table>

After displaying the table data, paging is implemented on this basis.

Add previous page and next page connections. A judgment must be made here to make the passed value meet the requirements:

<!--显示首页和上一页的条件-->
<?php if($page > 1)  {?>        
	<a href="?page=1">首页</a>
	<a href="?page=<?php echo $prevpage;">上一页</a>
<?php  }  ?>

<!--显示下一页和尾页的条件-->
<?php if($page < $ numpages)  {?>
	<a href="?page=<?php echo $nextpage;?">下一页</a>
	<a href="?page=<?php echo $numpages;?>尾页
<?php  }  ?>

The language for connecting to the database in php needs to be changed:

//获取总记录数:
$sqls  = "SELECT COUNT(*)  as totalFROM wordspace where sa_id  IS NOT NULL";
$sqlcount = mysqli_query($link,$sqls) od die("查询失败");
$pagecount  = mysqli_fetch_array($sqlcount);
$pagecount = $pagecount['total'];
mysqli_free_result($sqlcount);   //查询完记得释放空间
//获取页数,判断是否符合要求
$page = intval($_GET['page']);
if($page <=0) {$page= 1;}
elseif($page > $pagecount){ $page = $pagecount; }

//定义每页显示的页数：
$pageshow = 5;
$pagesize = ($page-1) * $pageshow;
//计算总页数:
$numpages = ceil($pagecount/$pageshow);   //向上取整；

//连接要显示的数据库
$sql = "SELECT * FROM wordcpace where IS NOT NULL limit $pagesize,$pageshow";
$sqlinfo = mysqli_query($sql);
$pide = mysqli_fetch_array($sqlinfo)or die("分页查询失败");
while($pide){
	$result[ ] = $pide;
}

$prevpage = $page - 1;

$nextpage = $page + 1;

mysqli_free_result($sqlinfo);
musqli_close($link);  //最后要关闭数据库

Summary:

After reading this, do you think PHP paging is very simple? It is to extract the data from the database and display it first, and then transfer it. Value, a series of judgment operations, when you master the essentials, nothing is a problem. I hope it will be helpful to you!

Related recommendations:

implementation of php paging class

The implementation principle of php paging

## Example of PHP paging effect

How to write PHP paging code

The above is the detailed content of Example of paging using php and mysql. For more information, please follow other related articles on the PHP Chinese website!