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
i send you my simple code for pagination PHP: <?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
Instead of fetching the complete data at the top you could use count(*) as well to make it more efficient.