Home > Backend Development > PHP Tutorial > PHP MySQL pagination display_PHP tutorial

PHP MySQL pagination display_PHP tutorial

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB
Release: 2016-07-13 10:58:12
Original
964 people have browsed it

Web development is the mainstream of distributed program development in the future. Usually web development involves dealing with the database. The client reads from the server and usually displays it in the form of paging, page by page. It is both convenient and beautiful to read. Therefore, writing paging programs is an important part of web development. Here, we will study the writing of paging programs together.

1. Principle of paging program

The paging program has two very important parameters: how many records are displayed on each page ($pagesize) and what page is the current page ($page). With these two parameters, we can easily write a paging program. We use the MySql database as the data source. In mysql, if you want to remove a specific piece of content in the table, you can use the T-SQL statement: select * from table limit offset, rows to achieve. The offset here is the record offset, and its calculation method is offset=$pagesize*($page-1), rows is the number of records to be displayed, here is $page. In other words, the statement select * from table limit 10,10 means to take out the 20 records starting from the 11th record in the table.

2. Main code analysis

$pagesize=10; //Set the number of records displayed on each page
$conn=mysql_connect("localhost","root",""); //Connect to the database
$rs=mysql_query("select count(*) from tb_product",$conn); //Get the total number of records $rs
$myrow = mysql_fetch_array($rs);
$numrows=$myrow[0];

//Calculate the total number of pages

$pages=intval($numrows/$pagesize);

//Determine page number setting

if (isset($_GET['page'])){
​$page=intval($_GET['page']);
}
else{
$page=1; //Otherwise, set to the first page
}

3. Create the use case table myTable

create table myTable(id int NOT NULL auto_increment,news_title varchar(50),news_cont text,add_time datetime,PRIMARY KEY(id))

4. Complete code



php paging example




​$conn=mysql_connect("localhost","root","");
//Set the number of records displayed on each page
​$pagesize=1;
mysql_select_db("mydata",$conn);
//Get the total number of records $rs, use
to calculate the total number of pages ​$rs=mysql_query("select count(*) from tb_product",$conn);
​$myrow = mysql_fetch_array($rs);
​$numrows=$myrow[0];
//Calculate the total number of pages

​$pages=intval($numrows/$pagesize);
if ($numrows%$pagesize)
​$pages ;
//Set the number of pages
if (isset($_GET['page'])){
​$page=intval($_GET['page']);
}
else{
//Set as the first page
​$page=1;
}

www.bkjia.comtruehttp: //www.bkjia.com/PHPjc/632021.htmlTechArticleWeb development is the mainstream of distributed program development in the future. Usually web development involves dealing with databases. Customers Reading from the server side is usually displayed in the form of paging, one...
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Issues
php data acquisition?
From 1970-01-01 08:00:00
0
0
0
PHP extension intl
From 1970-01-01 08:00:00
0
0
0
How to learn php well
From 1970-01-01 08:00:00
0
0
0
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template