How to implement paging query in php
This article mainly introduces the simple implementation code of PHP paging query in detail. It has certain reference value. Interested friends can refer to it.
About PHP, I have learned a lot recently, teacher Let me tell you, what I am 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, and it is not as difficult as when I first started learning. To sum up, I feel that mentality is the most important thing. It was a question of mentality at the beginning. After considering all aspects of the problem, I couldn’t calm down. Moreover, it had been many years since I sat down to study hard. I always felt that I couldn’t sit still. After a period of rest, Including the period of time when I was at home during the Chinese New Year, my mentality has changed a lot after I came back. Learning is no longer boring. Instead, it feels like many years ago when I encountered a mathematical problem and wanted to overcome it.
I have 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 entire content of this article, I hope it will be helpful to everyone's study.
Related recommendations:
think php5 multi-tableQueryCode method to get the total number by paging
##jQuery implementation HTML page text box fuzzy matchingQueryDetailed steps
The above is the detailed content of How to implement paging query in php. For more information, please follow other related articles on the PHP Chinese website!
Hot AI Tools
Undresser.AI Undress
AI-powered app for creating realistic nude photos
AI Clothes Remover
Online AI tool for removing clothes from photos.
Undress AI Tool
Undress images for free
Clothoff.io
AI clothes remover
AI Hentai Generator
Generate AI Hentai for free.
Hot Article
Hot Tools
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
CakePHP Project Configuration
Sep 10, 2024 pm 05:25 PM
In this chapter, we will understand the Environment Variables, General Configuration, Database Configuration and Email Configuration in CakePHP.
PHP 8.4 Installation and Upgrade guide for Ubuntu and Debian
Dec 24, 2024 pm 04:42 PM
PHP 8.4 brings several new features, security improvements, and performance improvements with healthy amounts of feature deprecations and removals. This guide explains how to install PHP 8.4 or upgrade to PHP 8.4 on Ubuntu, Debian, or their derivati
CakePHP Date and Time
Sep 10, 2024 pm 05:27 PM
To work with date and time in cakephp4, we are going to make use of the available FrozenTime class.
CakePHP File upload
Sep 10, 2024 pm 05:27 PM
To work on file upload we are going to use the form helper. Here, is an example for file upload.
CakePHP Routing
Sep 10, 2024 pm 05:25 PM
In this chapter, we are going to learn the following topics related to routing ?
Discuss CakePHP
Sep 10, 2024 pm 05:28 PM
CakePHP is an open-source framework for PHP. It is intended to make developing, deploying and maintaining applications much easier. CakePHP is based on a MVC-like architecture that is both powerful and easy to grasp. Models, Views, and Controllers gu
CakePHP Creating Validators
Sep 10, 2024 pm 05:26 PM
Validator can be created by adding the following two lines in the controller.
CakePHP Working with Database
Sep 10, 2024 pm 05:25 PM
Working with database in CakePHP is very easy. We will understand the CRUD (Create, Read, Update, Delete) operations in this chapter.
