show 3 records per page

clodia · Joined: 12 Jul 2007 Posts: 16

How can i show 3 records per page by using PHP if i have 20 records?

Thanks,

clodia

lostboy · Joined: 02 May 2004 Posts: 6033 Location: toronto, canada

http://www.weberdev.com/get_example-4092.html is one example...search on paging to find more

clodia · Joined: 12 Jul 2007 Posts: 16

Thanks for the reply.

I did not know that paging is the exact keyword for showing records in multi pages. I did find a lot of examples with that keyword.

Thanks,

Clodia

Rupom · Joined: 12 Jun 2005 Posts: 15 Location: Dhaka, Bangladesh

If you are fetching records from database, then you can use LIMIT in your query string. For example, when you want 3 records per page and your DB table has 20, you can use something like:

$records = 20;
$per_page = 3;
$total_pages = ceil($records/$per_page);

Now you know $total_pages. So you can create pagination links as following:

for($page = 1; $page <= $total_pages; $page++)
{
echo "- <a href='example.php?current_page=$page'>Page $page</a> -";
}

Upon clicking on any of the page links use this code:

$current_page = 1; //by default 1

if(is_numeric($_GET['current_page']))
{
$current_page = $_GET['current_page'];
}

$record_start = ($current_page - 1) * $per_page;
$record_end = $per_page;

$query = "SELECT * FROM $table_name LIMIT $record_start, $record_end";

---------------

This is a very basic sample of pagination. I think it will help you.

Thanks.