Easy PHP Pagination

Thank you SO SO SO SO much! This was a HUGE help, and I really appreciate you posting this! Best pagination I’ve seen

Hi,
This is Great and simple script…Thanks for sharing it.
If i need to add ‘first and last’ option before and after ‘previous and next’ button, what will be the changes in code??

Thank You so much ! been so useful and easy to use this pagination code !
Thanks again

This is THE easiest and simplest tutorial I’ve seen on pagination till date.

Awesome job man! Works like a charm and super easy to plug in.

Hi David, yes it can be done, go to our childrens toys site http://www.jadremtoys.com.au. The category menu on the left will deliver paginated results, a menu is just like a search it provides the database with a parameter

Cheers
Sam

When first time browse i got this error “Notice: Undefined index: page in” if click pagination it’s disapper

thanks for sharing… It really helped me to get rid of headache, caused to do pagination.

If you want the pagination images at the bottom of your list just move the code for the repeating loop above the pagination code

http://www.jadremtoys.com.au/catalogue/toy-group.php?grpid=101&name=Action-Figures-And-Toys

cheers

Thanks for sharing. u very helpful.Excellent

Nicely done. one thing i like to ask. how can i add the pagination to bottom of the page? thanks

Hi ashley,

Thanks for the great post.. However, im getting this error.. dont know why.. see below

Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in C:\PHP\pagination\index.php on line 67

Notice: Use of undefined constant num – assumed ‘num’ in C:\PHP\pagination\index.php on line 68

Notice: Undefined index: page in C:\PHP\pagination\index.php on line 71
Results

Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in C:\PHP\pagination\index.php on line 187

It refers to this line
$total_pages = $total_pages[num];

and this line

$page = mysql_escape_string($_GET['page']);

Im confused.. Help please.. thanks ashley..

Thatś great, I’m changing my script from Wp to a mine from the scracth and comes perfect this pagination, thank you for the tutorial!

display records from dbase page wise in php, page numbers should be displayed in a drop down combo box (using ). instead of like this: page numbers 1, 2, 3, …. till last.

Thanks. Very nice tutorial.

absolutely great and easiest tutorial in the whole net. I needed one and here it is in my website you can check the result http://www.turkishpropertiesabroad.com
it paginates the houses…
Thanx Man

Thanks Ashley, the code worked perfect. Only one question, when I changed the SQL query to $query = SELECT COUNT(*) as num FROM $tableName order by ID DESC it didn’t work. Please let me know how to fix this. The results are displayed random because of this.

Again Thanks

Hello,

Just downloaded the files and they are corrupt also when viewing this website I get the code displayed ina funny way.

<?php

002 include(‘connect.php’);

003

004 $tableName="countries_list";

005 $targetpage = "index.php";

006 $limit = 10;

007

008 $query = "SELECT COUNT(*) as num FROM $tableName";

009 $total_pages = mysql_fetch_array(mysql_query($query));

010 $total_pages = $total_pages[num];

011

012 $stages = 3;

013 $page = mysql_escape_string($_GET['page']);

014 if($page){

015 $start = ($page – 1) * $limit;

016 }else{

017 $start = 0;

018 }

019

020 // Get page data

021 $query1 = "SELECT * FROM $tableName LIMIT $start, $limit";

022 $result = mysql_query($query1);

023

024 // Initial page num setup

025 if ($page == 0){$page = 1;}

026 $prev = $page – 1;

027 $next = $page + 1;

028 $lastpage = ceil($total_pages/$limit);

029 $LastPagem1 = $lastpage – 1;

030

031 $paginate = ”;

032 if($lastpage > 1)

033 {

034

035 $paginate .= "<div class=’paginate’>";

036 // Previous

037 if ($page > 1){

038 $paginate.= "<a href=’$targetpage?page=$prev’>previous</a>";

039 }else{

040 $paginate.= "<span class=’disabled’>previous</span>"; }

041

042 // Pages

043 if ($lastpage < 7 + ($stages * 2)) // Not enough pages to breaking it up

044 {

045 for ($counter = 1; $counter <= $lastpage; $counter++)

046 {

047 if ($counter == $page){

048 $paginate.= "<span class=’current’>$counter</span>";

049 }else{

050 $paginate.= "<a href=’$targetpage?page=$counter’>$counter</a>";}

051 }

052 }

053 elseif($lastpage > 5 + ($stages * 2)) // Enough pages to hide a few?

054 {

055 // Beginning only hide later pages

056 if($page < 1 + ($stages * 2))

057 {

058 for ($counter = 1; $counter < 4 + ($stages * 2); $counter++)

059 {

060 if ($counter == $page){

061 $paginate.= "<span class=’current’>$counter</span>";

062 }else{

063 $paginate.= "<a href=’$targetpage?page=$counter’>$counter</a>";}

064 }

065 $paginate.= "…";

066 $paginate.= "<a href=’$targetpage?page=$LastPagem1′>$LastPagem1</a>";

067 $paginate.= "<a href=’$targetpage?page=$lastpage’>$lastpage</a>";

068 }

069 // Middle hide some front and some back

070 elseif($lastpage – ($stages * 2) > $page && $page > ($stages * 2))

071 {

072 $paginate.= "<a href=’$targetpage?page=1′>1</a>";

073 $paginate.= "<a href=’$targetpage?page=2′>2</a>";

074 $paginate.= "…";

075 for ($counter = $page – $stages; $counter <= $page + $stages; $counter++)

076 {

077 if ($counter == $page){

078 $paginate.= "<span class=’current’>$counter</span>";

079 }else{

080 $paginate.= "<a href=’$targetpage?page=$counter’>$counter</a>";}

081 }

082 $paginate.= "…";

083 $paginate.= "<a href=’$targetpage?page=$LastPagem1′>$LastPagem1</a>";

084 $paginate.= "<a href=’$targetpage?page=$lastpage’>$lastpage</a>";

085 }

086 // End only hide early pages

087 else

088 {

089 $paginate.= "<a href=’$targetpage?page=1′>1</a>";

090 $paginate.= "<a href=’$targetpage?page=2′>2</a>";

091 $paginate.= "…";

092 for ($counter = $lastpage – (2 + ($stages * 2)); $counter <= $lastpage; $counter++)

093 {

094 if ($counter == $page){

095 $paginate.= "<span class=’current’>$counter</span>";

096 }else{

097 $paginate.= "<a href=’$targetpage?page=$counter’>$counter</a>";}

098 }

099 }

100 }

101

102 // Next

103 if ($page < $counter – 1){

104 $paginate.= "<a href=’$targetpage?page=$next’>next</a>";

105 }else{

106 $paginate.= "<span class=’disabled’>next</span>";

107 }

108

109 $paginate.= "</div>";

110

111 }

112 echo $total_pages.’ Results’;

113 // pagination

114 echo $paginate;

115 ?>

116

117 <ul>

118

119 <?php

120

121 while($row = mysql_fetch_array($result))

122 {

123

124 echo ‘<li>’.$row['country'].’</li>’;

125

126 }

127

128 ?>

129 </ul>

Thats the code I get when viewing, does anyone have an ammended version to this please.

My email is qakbar@hotmail.co.uk

Thank you

thank u soo much .its working perfectly

Thanks a lot. You saved my day.

Hello.I optain the “Notice: Undefined index: page in C:\wamp\www\top50brands\index.php on line 13″
What its wrong?

Thanks for this. It is working very well

Thx a lot Ashley it worked perfectly

Thanks for this, works perfectly and is by far the easiest to use!!!

Excellent Post,

Perfectly working…..Need this kinds of post to help us…

Regards
Limno.