How to create next/previous page

[myfafa]

hi

The out put of this code is more than 10 records, i want to create a numeric page (1 , 2, ...)or next/previous page to show these record, any idea?

---

<?php
$rs['create'] = "true";
$counter=1;
if(Util::executeQuery("SELECT ID,name FROM category ORDER BY name",$rs) > 0){
foreach ($rs as $row){
echo "<tr align='right'>";
echo "<td><span class='style2'>$counter</span></td>";
echo "<td><span class='value'>".$row['name']."</span></td>";

				echo "<td align='center'><span><a href ='Categories.php?remove=".$row['ID']."'><img border ='0' src='../images/remove.gif' alt=\"delete from db!\"/></a></span></td>";
				echo "</tr>\n";

			 if($counter == 10){
					break;
				}  					$counter ++;
			}
		}else{ ?>
			<tr>
			<td>&nbsp;</td>
			<td colspan="2"><span class="value">no category was found!</span></td>
			<td>&nbsp;</td>
			</tr>
	<? }?>

---

thanks alot

[HuwPioden]

http://www.codewalkers.com/c/a/Database-Articles/PHP-Previous-and-Next-Links/

Is this what you want?

[FlyingBeyond]

The following is one method I used frequently,and I am sure it will do help you after your fully understanding about it.
This code is free for you to use. :)

There are total three files to achieve the function of 'page division':
1) page.php: the main file in which you can see the result of using "previous/next" page division function.
2) header.php:to define some variables which will hold the value from $_REQUEST['...'].
3) footer.php: to show the "PREVIOUS\NEXT" button , of couse , you can replace them with image.

<?php 

//header.php

$onepagelist=20;

if(!isset($page)) 
	$page=1;

if($total%$onepagelist==0)
	$pagenum=$total/$onepagelist;
else
	$pagenum=(int)($total/$onepagelist)+1;

$lastpage=$page-1;
$nextpage=$page+1;
$querybegin=($page-1)*$onepagelist;
?>



<?

// page.php

$query="select count(*) as total from document";
$result = mysql_query($query) or die("Query failed : " . mysql_error());
$line=mysql_fetch_assoc($result);
$total=$line['total'];

require('header.php');

$query="select * from document order by time DESC limit $querybegin,$onepagelist";
$result = mysql_query($query) or die("Query failed : " . mysql_error());

  for($i=0;$line=mysql_fetch_assoc($result);$i++)
	{
           echo $line['...'];
        }


require('footer.php');

?>



<?php 

// footer.php

if($pagenum>1)
{
if($page<=1)
echo "TOTAL".$pagenum."Pages &nbsp;Current page".$page." &nbsp;&nbsp;&nbsp;&nbsp;First|Previous|<a href='".$path."?page=".$nextpage."' target='_self'>Next</a>|<a href='".$path."?page=".$pagenum."' target='_self'>Final</a>";
elseif($page>=$pagenum)
echo "TOTAL".$pagenum."Pages &nbsp;Current page".$page." &nbsp;&nbsp;&nbsp;&nbsp;<a href='".$path."?page=1' target='_self'>First</a>|<a href='".$path."?page=".$lastpage."' target='_self'>First</a>|Next|Final";
else 
echo "TOTAL".$pagenum."Pages &nbsp;Current page".$page." &nbsp;&nbsp;&nbsp;&nbsp;<a href='".$path."?page=1' target='_self'>First</a>|<a href='".$path."?page=".$lastpage."' target='_self'>Previous</a>|<a href='".$path."?page=".$nextpage."' target='_self'>Next</a>|<a href='".$path."?page=".$pagenum."' target='_self'>Final</a>";
}
else 
echo "Total:1 page&nbsp;Current Page:1&nbsp;&nbsp;&nbsp;&nbsp;First|Previous|Next|Final";
?>

[myfafa]

Thanks buddy. ill try and inform you😉

[i-keng]

Example function

echo display_paging($all_record,$limit_perpage,$this_page,"?page=");

<?
         function display_paging( $total, $limit, $pagenumber, $baseurl ){

	$showpages = "10"; // 1,3,5,7,9...

	$icon_path =	'icons/';
	$icon_param =	'align="middle" style="border:0px;" ';
	$icon_first=	'[First Page] ';
	$icon_last=	'[Last Page]';
	$icon_previous=	'<< Previous';
	$icon_next=	'Next >>';

	$pages = ceil($total / $limit);
	$offset = ($pagenumber * $limit) - $limit;
	$end = $offset + $limit;

	$html .= '<div id="pageLinks">';
	if($pagenumber > 1) { $previous = $pagenumber -1;
		$html .= '<a href="'.$baseurl.'1">'.$icon_first.'</a> ';
	}
	if($pagenumber > 2) {    $previous = $pagenumber -1;
		$html .= '<a href="'.$baseurl.''.$previous.'">'.$icon_previous.'</a> ';
	}
	if ($pages>=2) { $p=1;
		$html .= "| Page: ";
		$pages_before = $pagenumber - 1;
		$pages_after = $pages - $pagenumber;
		$show_before = floor($showpages / 2);
		$show_after = floor($showpages / 2);
		if ($pages_before < $show_before){
			$dif = $show_before - $pages_before;
			$show_after = $show_after + $dif;
		}
		if ($pages_after < $show_after){
			$dif = $show_after - $pages_after;
			$show_before = $show_before + $dif;
		}
		$minpage = $pagenumber - ($show_before+1);
		$maxpage = $pagenumber + ($show_after+1);

		if ($pagenumber > ($show_before+1) && $showpages > 0) {
			$html .= " ... ";
		}
		while ($p <= $pages) {
			if ($p > $minpage && $p < $maxpage) {
				if ($pagenumber == $p) {
						$html .= " <b>".$p."</b>";
				} else {
					$html .= ' <a href="'.$baseurl.$p.'">'.$p.'</a>';
				}
			}
			$p++;
		}
		if ($maxpage-1 < $pages && $showpages > 0) {
			$html .= " ... ";
		}
	}
	if($end < $total) { $next = $pagenumber +1;
		if ($next != ($p-1)) {
			$html .= ' | <a href="'.$baseurl.$next.'">'.$icon_next.'</a>';
		} else {$html .= ' | ';}
	}
	if($end < $total) { $last = $p -1;
		$html .= ' <a href="'.$baseurl.$last.'">'.$icon_last.'</a>';
	}
	$html .= '</div>';

	return $html;
}	
?>

[myfafa]

Hi FlyingBeyond,
i used your code but the footer page didnt work, no link working, should i change something in it?
by the way thanks to everyone who reply.

[FlyingBeyond]

myfafa wrote:

Hi FlyingBeyond,
i used your code but the footer page didnt work, no link working, should i change something in it?
by the way thanks to everyone who reply.

In footer.php, there is a variable "

$path

"

You should set its value properly according to your requirements.

some reference code about this variable settings:

$path = $_SERVER['PHP_SELF'];
$path = basename("$path");
$path = $path . '?action=' . $action;     // maybe some changes you need make to this line

perhaps you should add the three lines above to your code in page.php , and I feel quite sorry for my ignoring in describing this point !!!!

Hope you can understand it better and work with it.
More to say, i just did a guestbook with paging code, so I am sure you can do it!🙂

[myfafa]

Dear FlyingBeyond
i did what you said but nothing change again🙁
i added lines 3,4,5,6,7 IN:
mainPage:

<?php 

include("connection.php");
[COLOR="DarkRed"]
if(!isset($page)) 
$page=1;
$path = $_SERVER['PHP_SELF']; 
$path = basename("$path"); 
$path = $path . '?page=' . $page;[/COLOR]     

$query="select count(*) as total from category"; 
$result = mysql_query($query) or die(mysql_error()); 
$line=mysql_fetch_assoc($result); 
$total=$line['total']; 

require('header.php'); 
echo "<hr>";

$query="select * from category order by name DESC limit $querybegin,$onepagelist"; 
$result = mysql_query($query) or die("Query failed : " . mysql_error()); 

  for($i=0;$line=mysql_fetch_assoc($result);$i++) 
    { 
           echo $line['name']."</br>"; 
        } 

echo "<hr>";
require('footer.php'); 

?>

headerPage:

<?php 
$total=0;
$onepagelist=10; 

if(!isset($page)) 
    $page=1; 

if($total%$onepagelist==0) 
    $pagenum=$total/$onepagelist; 
else 
    $pagenum=(int)($total/$onepagelist)+1; 

$lastpage=$page-1; 
$nextpage=$page+1; 
$querybegin=($page-1)*$onepagelist; 
?>

footerpage:

<?php 

if($pagenum>1) 
{ 
if($page<=1) 
echo "TOTAL".$pagenum."Pages &nbsp;Current page".$page." &nbsp;&nbsp;&nbsp;&nbsp;First|Previous|<a href='".$path."?page=".$nextpage."' target='_self'>Next</a>|<a href='".$path."?page=".$pagenum."' target='_self'>Final</a>"; 
elseif($page>=$pagenum) 
echo "TOTAL".$pagenum."Pages &nbsp;Current page".$page." &nbsp;&nbsp;&nbsp;&nbsp;<a href='".$path."?page=1' target='_self'>First</a>|<a href='".$path."?page=".$lastpage."' target='_self'>First</a>|Next|Final"; 
else 
echo "TOTAL".$pagenum."Pages &nbsp;Current page".$page." &nbsp;&nbsp;&nbsp;&nbsp;<a href='".$path."?page=1' target='_self'>First</a>|<a href='".$path."?page=".$lastpage."' target='_self'>Previous</a>|<a href='".$path."?page=".$nextpage."' target='_self'>Next</a>|<a href='".$path."?page=".$pagenum."' target='_self'>Final</a>"; 
} 
else 
echo "Total:1 page&nbsp;Current Page:1&nbsp;&nbsp;&nbsp;&nbsp;First|Previous|Next|Final"; 
?>

[FlyingBeyond]

myfafa wrote:

Dear FlyingBeyond
i did what you said but nothing change again🙁
i added lines 3,4,5,6,7 IN:

I test your code and made several changes such as adding , deleting , and changing.Now ,all is OK , I post the code here and I also upload the three files.Remember to download the attachment.
so , have fun ,myfafa !🙂

mainpage

<?php
include("connection.php");
$page = $_GET['page'];						// add  this line ! 
if(!isset($page))
$page=1;

$path = $_SERVER['PHP_SELF'];
$path = basename("$path");
//$path = $path . '?page=' . $page;  				//   delete this line
$query="select count(*) as total from category";
$result = mysql_query($query) or die(mysql_error());
$line=mysql_fetch_assoc($result);
$total=$line['total'];

require('header.php');
echo "<hr>";

$query="select * from category order by name DESC limit $querybegin,$onepagelist";
$result = mysql_query($query) or die("Query failed : " . mysql_error());

  for($i=0;$line=mysql_fetch_assoc($result);$i++)
    {
           echo $line['name']."</br>";
        }

echo "<hr>";
require('footer.php');

?> 

headerpage

<?php
//$total=0;					// the error~~~~, this line should be deleted
$onepagelist=10;			// change  the value to accommodate your need

if(!isset($page))
    $page=1;

if($total%$onepagelist==0)
    $pagenum=$total/$onepagelist;
else
    $pagenum=(int)($total/$onepagelist)+1;

$lastpage=$page-1;
$nextpage=$page+1;
$querybegin=($page-1)*$onepagelist;
?> 

footerpage

<?php

if($pagenum>1)
{
if($page<=1)
	echo "TOTAL&nbsp;".$pagenum."&nbsp;Pages &nbsp;Current page&nbsp;".$page." &nbsp;&nbsp;&nbsp;&nbsp;First|Previous|<a href='".$path."?page=".$nextpage."' target='_self'>Next</a>|<a href='".$path."?page=".$pagenum."' target='_self'>Final</a>";
elseif($page>=$pagenum)
	echo "TOTAL&nbsp;".$pagenum."&nbsp;Pages &nbsp;Current page&nbsp;".$page." &nbsp;&nbsp;&nbsp;&nbsp;<a href='".$path."?page=1' target='_self'>First</a>|<a href='".$path."?page=".$lastpage."' target='_self'>Previous</a>|Next|Final";// 'first' in this line shoud be  'previous ' 
else
echo "TOTAL&nbsp;".$pagenum."&nbsp;Pages &nbsp;Current page&nbsp;".$page." &nbsp;&nbsp;&nbsp;&nbsp;<a href='".$path."?page=1' target='_self'>First</a>|<a href='".$path."?page=".$lastpage."' target='_self'>Previous</a>|<a href='".$path."?page=".$nextpage."' target='_self'>Next</a>|<a href='".$path."?page=".$pagenum."' target='_self'>Final</a>";
}
else
echo "Total:1 page&nbsp;Current Page:1&nbsp;&nbsp;&nbsp;&nbsp;First|Previous|Next|Final";
?> 

[myfafa]

wow🙂

hey dude, you are wonderful, thank you so much,its ok

[FlyingBeyond]

My pleasure , and glad to know u .
🙂