PHP Help with pagination

Prev: Need Help
Next: Storing images

From: Karl DeSaulniers on 29 Jan 2010 01:48

---

Hey nagendra,
I tried to post this a while ago, but it may be too long for the list.

<?php
if ($Submit) { // perform search only if correct form was entered.
$db = mysql_connect ($Host, $User, $Password);
mysql_select_db ($DBName) or die ("Cannot connect to database");

//check if the starting row variable was passed in the URL or not
if (!isset($_GET['pg']) or !is_numeric($_GET['pg'])) {
//we give the value of the starting row to 1 because this is the
first page
$pg = 1;
//otherwise we take the value from the URL
} else {
$pg = $_GET['pg'];
}
?>

<?php // I used the results from a dropdown menu for the users
selection from the previous page that called this one.
if ($fieldTwentyOne == 'All Users Last Login Date') {
$fieldTwentyOne = "%";
}

$srch="%".$Submit."%";
?>

<?php
/// Variables

$max_results = 5; /// Number of results per page

$min = (($pg * $max_results) - $max_results);
?>

<?php
/// Count total
$query_total_users = "SELECT COUNT(*) as Num FROM users";
$totals = mysql_result(mysql_query($query_total_users, $db),0);
$total_pgs = ceil($totals / $max_results);
?>

<?php
$query_UserLastLogin = "SELECT * FROM users WHERE UserLastLogin LIKE
'$fieldTwentyOne' ";
$UserLastLogin = mysql_query($query_UserLastLogin, $db) or die
(mysql_error());
if(!get_magic_quotes_gpc()) { $UserLastLogin = stripslashes
($UserLastLogin); }
$row_UserLastLogin = mysql_fetch_assoc($UserLastLogin);
?>

<?php
/// Page limiter & result builder

// Access table properties

$query_users = "SELECT * FROM users LIMIT $min, $max_results";
$result = mysql_query($query_users, $db) or die(mysql_error());
$num_sql = mysql_numrows($result);

if ($result) {

// Build paging
if($pg > 1) {
$prev = ($pg - 1); // Previous Link
$paging = "<a href='".$_SERVER['PHP_SELF']."?Submit=".$Submit."&pg=".
$prev."'>Previous page&nbsp;</a>";
//$paging = "<a href=\"{$_SERVER['PHP_SELF']}?pg=$prev\">Previous
page</a>";
}


for($j = 1; $j <= $total_pgs; $j++) { /// Numbers
$paging .= "<a href='".$_SERVER['PHP_SELF']."?Submit=".
$Submit."&pg=".$j."'>&nbsp;".$j."&nbsp;</a>";
//$paging .= "<a href=\"{$_SERVER['PHP_SELF']}?pg=$ij\">$j</a> "; }}
}

if($pg < $total_pgs) {
$next = ($pg + 1); // Next Link
$paging .= "<a href='".$_SERVER['PHP_SELF']."?Submit=".
$Submit."&pg=".$next."'>&nbsp;Next page</a>";
}
?>

//--------------------

In my html I have a table cel displaying info

For the page numbers:

<td colspan="22" width="90%" align="left" valign="top"
bgcolor="#5E5E5E"><font size="2" face="Verdana, Arial, Helvetica,
sans-serif">&nbsp;&nbsp;<p align="left"><?php echo $paging?></p></td>

For showing current page and database totals:

<td colspan="22" width="10%" align="left" valign="bottom"
bgcolor="#5E5E5E"><font size="2" face="Verdana, Arial, Helvetica,
sans-serif">Here are the results:<br>Num_sql Rows: <?php echo
$num_sql?><br>Number of Users: <?php echo $totals?><br>Total Pages: <?
php echo $total_pgs?><br>Number of Results: <?php echo $totals?
><br>Viewing page <?php echo $pg?> of <?php echo $total_pgs?><br></td>

Then I close the html and php

<?php
} // End if($Submit)
?>

Use this if you want, I took bits and pieces and put this together
for you, but hope that helps.

Karl DeSaulniers
Design Drumm
http://designdrumm.com

 | 
Pages: 1
Prev: Need Help
Next: Storing images