JIYIK CN >

This article will show you a way to perform paging in PHP using the LIMIT clause and the SQLINSERT SELECTstatement in PHP. We will use LIMITthe LIMIT clause to select a specific number of rows starting from a specific index to display as paging.

PreviousWe will also demonstrate another method of adding and navigation functionality in PHP paging Next. This method simply adds the additional functionality of navigating the corresponding page to the first method.

In PHP SQL, use LIMITthe clause and SELECTthe statement to page rows

We can use LIMITthe clause and SELECTthe statement to specify the first n results to be displayed on the page. We can anchorprovide the page number as GETa method in the tag to navigate through the pages. In this method, we define the number of rows to be displayed per page and retrieve all rows from the database to calculate the total number of pages required. We can use $_GETthe array and isset()the function to get the page number requested by the user.

For example, create a variable $results_per_pageand store it in it 2. Use mysqli_num_rows()the function to find the number of rows in the database and store it in $number_of_resultsthe variable. Use ceil()the function to determine the total number of pages required to display the rows. Divide $number_of_resultsthe variable by the variable ceil()inside the function $results_per_page. Use $_GETthe superglobal variable and isset()the function to check pageif the variable is set. If it is not set, $pageset the variable to 1. If the variable is set, assign the value to $pagethe variable. 1Subtract $pagethe variable from and multiply it by $this_page_first_resultthe variable. Store the operation in the variable $this_page_first_result. Write an LIMITif statement with a while SQLclause to SELECT * FROM alpha LIMIT ' . $this_page_first_result . ',' . $results_per_page.run the query and display the results. Finally, create a forloop to loop between $pagethe variables and $number_of_page. Inside the loop, echo anchortags and hrefset the value of the property to index.php?page'.$page. anchorWrite $pagethe variable between the tags.

In the example below, alphathe table in the database contains six rows. After paging is performed, two rows are displayed per page. ceil()The function determines the total number of pages required to display the rows. Initially, $pagethe variables are not set, so the pages start at page 1. $this_page_first_resultThe variables determine the page number the user is currently on. The variable $this_page_first_resultrepresents the first row of the page. The variable $results_per_pagerepresents the number of results per page. The output section displays index.phppages. When page is clicked 2, it outputs the next two rows from the database.

Sample code:

#php 7.x
<?php
$number_of_pages = ceil($number_of_results/$results_per_page);
if (!isset($_GET['page'])) {
    $page = 1;
} else {
    $page = $_GET['page'];
}
$this_page_first_result = ($page-1)*$results_per_page;
$sql='SELECT * FROM alpha LIMIT ' . $this_page_first_result . ',' . $results_per_page;
$result = mysqli_query($con, $sql);
while($row = mysqli_fetch_array($result)) {
    echo $row['id'] . ' ' . $row['value']. '<br>';
}
for ($page=1;$page<=$number_of_pages;$page++) {
    echo '<a href="index.php?page=' . $page . '">' . $page . '</a> ';
}
?>

Output:

1 A 
2 B 
1 2 3

PreviousAdding and Nextnavigation functions to PHP paging

PreviousWe can add some additional code snippets to the code example of the first method to provide and navigation functionality in pagination Next. We can $pageincrement and decrement the variable by 1 to point to the previous and next pages. We can use anchorthe increment and decrement variables in the tags to implement the Nextand Previousfunctionality.

For example, create two variables, $prevand $next. Subtract $pagethe variable from 1 and assign the operation to $prevthe variable. Similarly, add 1 to $pagethe variable and assign it to the variable. Echo a tag before the loop $nextfor the page number that says . Assign the attribute of the tag to . In the same way, create another tag for using the variable as the value of in the attribute .foranchorPreviousanchorhrefindex.php?page=' . $prev .$nexthrefpageNextanchor

In the output section below, it shows the second page. Click Previousto go to the first page and click Nextto go to the third page.

Sample code:

# php 7.x
<?php
$prev = $page -1;
$next = $page +1;
echo ' <a href="index.php?page=' . $prev . '"> Previous </a> ';
for ($page=1;$page<=$number_of_pages;$page++) {
    echo '<a href="index.php?page=' . $page . '">' . $page . '</a> ';
}
echo ' <a href="index.php?page=' . $next . '"> Next </a> ';
?>

Output:

3 C 
4 D 
Previous 1 2 3 Next