how to display this pagination in bottom instead of top of the records.

Thanks, So awesome and easy.

Hi there, thank you so much, at first I got the problem on the code but when I fixed the mysql_real_escape_string, it worked!

I used this script its nice, Thanks for sharing. can we manage pagination like this, suppose we are on page 10 show the backup record like we show 10 item on per page, when we are on 10 no page he show me record 1 of 100.

Thank You.

http://www.creativekube.com/topupbd/index.html
user: admin
pass: admin

PAGINATION LINK: Complete History, Pending History & Cancel History
—————————————–

please help me out to finished pagination:
<?php

function paginate_three($reload, $page, $tpages, $adjacents) {

$prevlabel = "‹ Prev";
$nextlabel = "Next ›";

$out = "\n”;

// previous
if($page==1) {
$out.= “” . $prevlabel . “\n”;
}
elseif($page==2) {
$out.= “” . $prevlabel . “\n”;
}
else {
$out.= “” . $prevlabel . “\n”;
}

// first
if($page>($adjacents+1)) {
$out.= “1\n”;
}

// interval
if($page>($adjacents+2)) {
$out.= “…\n”;
}

// pages
$pmin = ($page>$adjacents) ? ($page-$adjacents) : 1;
$pmax = ($page<($tpages-$adjacents)) ? ($page+$adjacents) : $tpages;
for($i=$pmin; $i<=$pmax; $i++) {
if($i==$page) {
$out.= "” . $i . “\n”;
}
elseif($i==1) {
$out.= “” . $i . “\n”;
}
else {
$out.= “” . $i . “\n”;
}
}

// interval
if($page<($tpages-$adjacents-1)) {
$out.= "…\n";
}

// last
if($page<($tpages-$adjacents)) {
$out.= "” . $tpages . “\n”;
}

// next
if($page<$tpages) {
$out.= "” . $nextlabel . “\n”;
}
else {
$out.= “” . $nextlabel . “\n”;
}

$out.= “”;

return $out;
}
?>

<?php

$rpp = 50; // results per page
$adjacents = 4;

$page = intval($_GET["page"]);
if($page<=0) $page = 1;

$reload = $_SERVER['PHP_SELF'];

// select appropriate results from DB:
$sql = "SELECT * FROM 'topup' ".$pagestatus." ORDER BY field_name";
$result = mysql_query($sql, $link_id);

// count total number of appropriate listings:
$tcount = mysql_num_rows($result);

// count number of pages:
$tpages = ($tcount) ? ceil($tcount/$rpp) : 100; // total pages, last page number

$count = 0;
$i = ($page-1)*$rpp;
while(($count<$rpp) && ($i<$tcount)) {
mysql_data_seek($result,$i);
$query = mysql_fetch_array($result);

// output each row:
echo "” . $query['table_field_1'] . “, ” . $query['table_field_2'] . “\n”;

$i++;
$count++;
}

?>

Hi there, I’ve also wrote an tutorial about how to paginate database results usign PHP. I’ve wrote a PHP function which can be used very easy. Please read it at http://www.lampcoder.com/how-to-paginate-mysql-database-results-using-php-function/

ithu peru easy aana coding ah?poi easy na enna nu dictionary le theduda crack….

poda goyya…is this an easy code?un moonchiyum neeyum….

This is really helpful,thank you…..

Hi,

I have saved my youtube link in my db,and trying to retrieve it to my website using pagination.

{[$row['ylink']]} // ylink is the youtube link

i used as above but its not helping me.

Please support ,how can i get it?

Thanks for sharing ….

this pagination is great and working properly in simple phpmysql queries but for search query it is not working ….
plz help

<?php
include("config.php");
ini_set("display_errors",0);

if(isset($_POST['search']))
{

$pro_for=$_POST["pro_for"];

$pro_cat=$_SESSION['pro_cat'];

$pro_type=$_POST["pro_type"];
$city=$_POST["city"];
$city=$_POST["city"];
if($pro_cat=='')
{

echo'alert(“Please select Property category.”);window.location=”index.php”;’;

}
elseif($pro_type==”)
{

echo’alert(“Please select Property type.”);window.location=”index.php”;’;

}
elseif($city==”)
{

echo’alert(“Please select city.”);window.location=”index.php”;’;

}
elseif($pro_for==”)
{

echo’alert(“Please select property you want for.”);window.location=”index.php”;’;

}
else
{
$pro_for=$_POST["pro_for"];
$pro_cat=$_POST["pro_cat"];
$pro_type=$_POST["pro_type"];
$city=$_POST["city"];
$area=$_POST["area"];
$min_buget=$_POST["min_buget"];
$max_buget=$_POST["max_buget"];

if($pro_for!==” && $pro_cat!=”&& $pro_type!=”&&$city!=”&&$area!=”&& $max_buget==”&& $min_buget==”)
{
$tableName=”property”;
$targetpage = ‘index.php?c=search-results’;
$limit = 1;
$query2=”select COUNT(*) as num from $tableName where pro_for=’”.$pro_for.”‘ and cat=’”.$pro_cat.”‘ and pro_type=’”.$pro_type.”‘ and city=’”.$city.”‘ and area=’”.$area.”‘”;
$query = $query2;
$total_pages = mysql_fetch_array(mysql_query($query));
$total_pages = $total_pages[num];

$stages = 3;
$page = mysql_escape_string($_GET['page']);
if($page){
$start = ($page – 1) * $limit;
}else{
$start = 0;
}

// Get page data
echo $query1=”select * FROM $tableName where pro_for=’”.$pro_for.”‘ and cat=’”.$pro_cat.”‘ and pro_type=’”.$pro_type.”‘ and city=’”.$city.”‘ and area=’”.$area.”‘ LIMIT $start, $limit”;
$result = mysql_query($query1);

// Initial page num setup
if ($page == 0){$page = 1;}
$prev = $page – 1;
$next = $page + 1;
$lastpage = ceil($total_pages/$limit);
$LastPagem1 = $lastpage – 1;

$paginate = ”;

}
elseif($pro_for!==” && $pro_cat!=”&& $pro_type!=”&&$city!=”&&$area!=”&& $max_buget==!”&& $min_buget==!”)
{
$tableName=”property”;
$targetpage = ‘index.php?c=search-results’;
$limit = 1;
$query2=”select COUNT(*) as num from $tableName where pro_for=’”.$pro_for.”‘ and cat=’”.$pro_cat.”‘ and pro_type=’”.$pro_type.”‘ and city=’”.$city.”‘ and area=’”.$area.”‘ and exp_rate BETWEEN ‘”.$_POST['min_buget'].”‘ and ‘”.$_POST['max_buget'].”‘”;

$query = $query2;
$total_pages = mysql_fetch_array(mysql_query($query));
$total_pages = $total_pages[num];

$stages = 2;
$page = mysql_escape_string($_GET['page']);
if($page){
$start = ($page – 1) * $limit;
}else{
$start = 0;
}

// Get page data
echo $query1=”select * FROM $tableName where pro_for=’”.$pro_for.”‘ and cat=’”.$pro_cat.”‘ and pro_type=’”.$pro_type.”‘ and city=’”.$city.”‘ and area=’”.$area.”‘ and exp_rate BETWEEN ‘”.$_POST['min_buget'].”‘ and ‘”.$_POST['max_buget'].”‘ LIMIT $start, $limit”;
$result = mysql_query($query1);

// Initial page num setup
if ($page == 0){$page = 1;}
$prev = $page – 1;
$next = $page + 1;
$lastpage = ceil($total_pages/$limit);
$LastPagem1 = $lastpage – 1;

$paginate = ”;

}

}

}

?>

searched data to comes here

1)
{

$paginate .= “”;
// Previous
if ($page > 1){
$paginate.= “previous“;
}else{
$paginate.= “previous”; }

// Pages
if ($lastpage < 7 + ($stages * 2)) // Not enough pages to breaking it up
{
for ($counter = 1; $counter <= $lastpage; $counter++)
{
if ($counter == $page){
$paginate.= "$counter”;
}else{
$paginate.= “$counter“;}
}
}
elseif($lastpage > 5 + ($stages * 2)) // Enough pages to hide a few?
{
// Beginning only hide later pages
if($page < 1 + ($stages * 2))
{
for ($counter = 1; $counter < 4 + ($stages * 2); $counter++)
{
if ($counter == $page){
$paginate.= "$counter”;
}else{
$paginate.= “$counter“;}
}
$paginate.= “…”;
$paginate.= “$LastPagem1“;
$paginate.= “$lastpage“;
}
// Middle hide some front and some back
elseif($lastpage – ($stages * 2) > $page && $page > ($stages * 2))
{
$paginate.= “1“;
$paginate.= “2“;
$paginate.= “…”;
for ($counter = $page – $stages; $counter <= $page + $stages; $counter++)
{
if ($counter == $page){
$paginate.= "$counter”;
}else{
$paginate.= “$counter“;}
}
$paginate.= “…”;
$paginate.= “$LastPagem1“;
$paginate.= “$lastpage“;
}
// End only hide early pages
else
{
$paginate.= “1“;
$paginate.= “2“;
$paginate.= “…”;
for ($counter = $lastpage – (2 + ($stages * 2)); $counter <= $lastpage; $counter++)
{
if ($counter == $page){
$paginate.= "$counter”;
}else{
$paginate.= “$counter“;}
}
}
}

// Next
if ($page < $counter – 1){
$paginate.= "next“;
}else{
$paginate.= “next”;
}

$paginate.= “”;

}
$total_pages.’ Results’;
// pagination
echo $paginate;
?>

plz help me

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.

&lt;?php

002 include(‘connect.php’);

003

004 $tableName=&quot;countries_list&quot;;

005 $targetpage = &quot;index.php&quot;;

006 $limit = 10;

007

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

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 = &quot;SELECT * FROM $tableName LIMIT $start, $limit&quot;;

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 &gt; 1)

033 {

034

035 $paginate .= &quot;&lt;div class=’paginate’&gt;&quot;;

036 // Previous

037 if ($page &gt; 1){

038 $paginate.= &quot;&lt;a href=’$targetpage?page=$prev’&gt;previous&lt;/a&gt;&quot;;

039 }else{

040 $paginate.= &quot;&lt;span class=’disabled’&gt;previous&lt;/span&gt;&quot;; }

041

042 // Pages

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

044 {

045 for ($counter = 1; $counter &lt;= $lastpage; $counter++)

046 {

047 if ($counter == $page){

048 $paginate.= &quot;&lt;span class=’current’&gt;$counter&lt;/span&gt;&quot;;

049 }else{

050 $paginate.= &quot;&lt;a href=’$targetpage?page=$counter’&gt;$counter&lt;/a&gt;&quot;;}

051 }

052 }

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

054 {

055 // Beginning only hide later pages

056 if($page &lt; 1 + ($stages * 2))

057 {

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

059 {

060 if ($counter == $page){

061 $paginate.= &quot;&lt;span class=’current’&gt;$counter&lt;/span&gt;&quot;;

062 }else{

063 $paginate.= &quot;&lt;a href=’$targetpage?page=$counter’&gt;$counter&lt;/a&gt;&quot;;}

064 }

065 $paginate.= &quot;…&quot;;

066 $paginate.= &quot;&lt;a href=’$targetpage?page=$LastPagem1′&gt;$LastPagem1&lt;/a&gt;&quot;;

067 $paginate.= &quot;&lt;a href=’$targetpage?page=$lastpage’&gt;$lastpage&lt;/a&gt;&quot;;

068 }

069 // Middle hide some front and some back

070 elseif($lastpage – ($stages * 2) &gt; $page &amp;&amp; $page &gt; ($stages * 2))

071 {

072 $paginate.= &quot;&lt;a href=’$targetpage?page=1′&gt;1&lt;/a&gt;&quot;;

073 $paginate.= &quot;&lt;a href=’$targetpage?page=2′&gt;2&lt;/a&gt;&quot;;

074 $paginate.= &quot;…&quot;;

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

076 {

077 if ($counter == $page){

078 $paginate.= &quot;&lt;span class=’current’&gt;$counter&lt;/span&gt;&quot;;

079 }else{

080 $paginate.= &quot;&lt;a href=’$targetpage?page=$counter’&gt;$counter&lt;/a&gt;&quot;;}

081 }

082 $paginate.= &quot;…&quot;;

083 $paginate.= &quot;&lt;a href=’$targetpage?page=$LastPagem1′&gt;$LastPagem1&lt;/a&gt;&quot;;

084 $paginate.= &quot;&lt;a href=’$targetpage?page=$lastpage’&gt;$lastpage&lt;/a&gt;&quot;;

085 }

086 // End only hide early pages

087 else

088 {

089 $paginate.= &quot;&lt;a href=’$targetpage?page=1′&gt;1&lt;/a&gt;&quot;;

090 $paginate.= &quot;&lt;a href=’$targetpage?page=2′&gt;2&lt;/a&gt;&quot;;

091 $paginate.= &quot;…&quot;;

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

093 {

094 if ($counter == $page){

095 $paginate.= &quot;&lt;span class=’current’&gt;$counter&lt;/span&gt;&quot;;

096 }else{

097 $paginate.= &quot;&lt;a href=’$targetpage?page=$counter’&gt;$counter&lt;/a&gt;&quot;;}

098 }

099 }

100 }

101

102 // Next

103 if ($page &lt; $counter – 1){

104 $paginate.= &quot;&lt;a href=’$targetpage?page=$next’&gt;next&lt;/a&gt;&quot;;

105 }else{

106 $paginate.= &quot;&lt;span class=’disabled’&gt;next&lt;/span&gt;&quot;;

107 }

108

109 $paginate.= &quot;&lt;/div&gt;&quot;;

110

111 }

112 echo $total_pages.’ Results’;

113 // pagination

114 echo $paginate;

115 ?&gt;

116

117 &lt;ul&gt;

118

119 &lt;?php

120

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

122 {

123

124 echo ‘&lt;li&gt;’.$row['country'].’&lt;/li&gt;’;

125

126 }

127

128 ?&gt;

129 &lt;/ul&gt;

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

My email is [email protected]

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.