Home > Article > Backend Development > Simple sample code sharing for PHP paging query (picture)
Simple sample code sharing for PHP paging query (picture)
- 黄舟Original
- 2017-03-17 09:37:231462browse
This article mainly introduces the simple implementation code of phppaginationquery in detail. It has certain reference value. Interested friends can refer to it
Regarding php, I have learned a lot recently. The teacher told us that what we are learning now are all the core parts of php, so I paid more attention and practiced it a few more times. It is relatively easy to understand, no It was so difficult when I first started studying. To sum up, I feel that mentality is the most important thing. At the beginning, it was a question of mentality. Considering all aspects of the problem, I couldn’t calm down, and it has been many years since I sat down to study hard. I feel like I can't sit still. After a period of rest, including a period of time at home during the Chinese New Year, my mentality has changed a lot after returning. I feel that learning is not so boring anymore. Instead, I feel like I met someone many years ago. Mathematics problems are something that I especially want to overcome.
There are a lot of complaints, haha. The main thing I learned this morning was paging query: if there is a lot of data, it will look a lot when displayed on one page, and it will look very tiring. Then we use paging, which has been written before, and it looks like It's relatively clear. What we learned today is paging query. It's relatively simple. It just adds a query condition on the basis of paging. This time the chinastates table is used:
The first three columns are mainly used, namely the region code, region name and parent code. When performing paging queries, please note that get is used to obtain elements. When we perform paging queries, we will see the title bar displayed as shown in the figure:
It will be more troublesome if you use post to obtain it. In this case, you need to modify it on the new page and write the third condition in the brackets. In the code identification, There are annotations, and the results are also displayed in the uploaded pictures. The query is "medium", and then I see the second page. There are no problems
<body>
<h1>分页查询</h1>
<?php
include("DADB.class.php");
$db=new DADB();
$tj= " 1=1 ";
$area="";
if(!empty($_GET["area"]))
{
$area=$_GET["area"];
$tj=" areaname like '%{$area}%'";
}
?>
<form action="fenyechaxun.php" method="get" >
//这里用的是get 来获取
<p>地区名称：<input type="text" name="area" value="<?php echo $area; ?>"/>
//这里如果没有传入value值 如果查询内容的数量比较多，
那么在第二页的时候将与需要查询的内容不符
<input type="submit" value="查询"/></p>
</form>
<table border="1" cellpadding="0" cellspacing="0" width="100%">
<tr>
<td>地区代号</td>
<td>地区名称</td>
<td>父级代号</td>
</tr>
<?php
include("page.class.php");
$sqg="select count(*) from chinastates WHERE {$tj}";
//因为是需要查询，所以 select语句都要有条件
$arg=$db->Query($sqg);
$page=new page($arg[0][0],20);
//如果前面用的是post 那么这里 可以改为new page（, , "areaname='{$area}'" ）
$sql="select * from chinastates where {$tj}" .$page->limit;
$arr=$db->Query($sql);
foreach($arr as $v)
{
echo"<tr>
<td>{$v[0]}</td>
<td>{$v[1]}</td>
<td>{$v[2]}</td>
</tr>";
}
?>
</table>
<p> <?php
echo $page->fpage();
?></p>
</body>
The above is the detailed content of Simple sample code sharing for PHP paging query (picture). For more information, please follow other related articles on the PHP Chinese website!