PHP MySQL pagination display_PHP tutorial

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