Go4Expert - how to creat a pagination in PHP?

Go4Expert (http://www.go4expert.com/)

- PHP (http://www.go4expert.com/forumdisplay.php?f=26)

- - how to creat a pagination in PHP? (http://www.go4expert.com/showthread.php?t=24979)

how to creat a pagination in PHP?

As a php developer, you will often be tasked to display large amounts of data to the user in some kind of easy to read format.
I have some records, I want to display records page by page!
Any one give tutorial about pagination in php?
I found some php pagination scripts listed on the site PHPKode.com

Re: how to creat a pagination in PHP?

i send you my simple code for pagination

PHP Code:


		
			
<?php
$q="SELECT * FROM table_name";
$p=mysql_query($q);
$nr=mysql_num_rows($p);
$t=$nr/5;
$lim=$_GET['start']*5 ;

$q="SELECT * FROM table_name LIMIT $lim,5";
$p=mysql_query($q) or die('query error');
while($r=mysql_fetch_array($p))
{
    echo $r['user']."<br>";   // fetching data
}

for($i=0;$i<=$t;$i++)
{
    $j=$i+1;
    echo " [ <a href=index.php?p=5&start=$i>".$j."</a>] | "; // change according to you page
}


?>

may be there would some easy method but i like to use this simple code :)

Re: how to creat a pagination in PHP?

Instead of fetching the complete data at the top you could use count(*) as well to make it more efficient.