Simple sample code sharing for PHP paging query (picture)
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!
Hot AI Tools
Undress AI Tool
Undress images for free
AI Clothes Remover
Online AI tool for removing clothes from photos.
Undresser.AI Undress
AI-powered app for creating realistic nude photos
ArtGPT
AI image generator for creative art from text prompts.
Stock Market GPT
AI powered investment research for smarter decisions
Hot Article
Popular tool
Notepad++7.3.1
Easy-to-use and free code editor
SublimeText3 Chinese version
Chinese version, very easy to use
Zend Studio 13.0.1
Powerful PHP integrated development environment
Dreamweaver CS6
Visual web development tools
SublimeText3 Mac version
God-level code editing software (SublimeText3)
Hot Topics
20516
7
13629
4
How to dynamically set arbitrary depth value of nested array in PHP
Mar 04, 2026 am 11:15 AM
This article introduces a safe and efficient method to use key path arrays (such as ['key1', 'key2', 'key3']) to assign values to the last nodes of multi-dimensional associative arrays, solve the problem of reference failure caused by value transfer, and take into account key existence verification.
![How to install Redis cluster on Linux_Linux distributed cache deployment solution [Advanced]](https://img.php.cn/upload/article/202602/08/2026020819395340210.jpg)
How to install Redis cluster on Linux_Linux distributed cache deployment solution [Advanced]
Feb 08, 2026 pm 07:39 PM
The Redis6 cluster must be created with redis-cli--cluster. It requires a minimum of 3 masters and 3 slaves, a total of 6 nodes. The client port and the corresponding cluster bus port (10000) must be opened. Correct configuration but blocked ports is a common cause of failure.
How to import SQL files in mysql_mysql SQL file import method
Feb 09, 2026 pm 05:24 PM
The most common and reliable way to import SQL files into MySQL is the command line tool mysql, which supports cross-platform, high efficiency and stability, and is suitable for files of all sizes. It can also be executed in the client through the source command, or using graphical tools such as phpMyAdmin and MySQL Workbench.
PHP batch processing of color mode and resolution of pictures in PPT
Mar 02, 2026 am 10:18 AM
To read PPTX images with PHP, you need to decompress the ZIP package first, because the images are stored in the ppt/media/ directory; directly calling the image function will report an error; you must use ZipArchive to decompress, Imagick to process CMYK to RGB conversion and scaling, and update the rels and [Content_Types].xml files simultaneously.
![Where can I see the PHP operator priority table_php official operator priority [Reference]](https://img.php.cn/upload/article/202603/02/2026030211450568785.jpg)
Where can I see the PHP operator priority table_php official operator priority [Reference]
Mar 02, 2026 am 11:45 AM
The official description of PHP operator precedence is located at https://www.php.net/manual/en/language.operators.precedence.php. You need to directly search for "operatorprecedence" or manually enter the URL to access; == and === have the same priority and belong to the same level; error-prone combinations include &&/|| and and/or, ?: and ??, new and []; complex expressions must be bracketed.
Number statistics in pyramid loop in PHP: correct counting method of total, odd and even numbers
Mar 04, 2026 pm 01:30 PM
This article explains in detail how to accurately count the total number, odd number and even number of all generated numbers in the PHP pyramid printing loop, correct common logic errors (such as misuse of variables, confusion of counting objects), and provide runnable examples and key precautions.
How to deal with character sets after mysql upgrade_mysql encoding migration instructions
Feb 09, 2026 pm 07:17 PM
After the MySQL 8.0 upgrade, the default character set becomes utf8mb4, but the old table character set remains unchanged; latin1/utf8 tables need to be manually migrated, and the source character set must be specified when exporting. ALTERTABLECONVERT will re-encode the data, and the connection layer must explicitly declare utf8mb4.
How to install ThinkPHP with composer_Steps to deploy TP framework using composer
Feb 12, 2026 am 06:27 AM
The ThinkPHP stable version should be clearly specified, such as using composercreate-projecttopthink/thinktp6^6.3 to install the TP6.3LTS version to avoid pulling non-production-ready beta versions because dev-master has switched to the TP8 preview version.
