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

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 = "%";


/// Variables

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

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

/// 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);

$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);

/// 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

} // 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

Reply via email to