RE: Display mysql query results divided in dynamic numbered pages

["Gary Every" <Gary.Every@xxxxxxxxxxxxxxxxxxxxxxx>]

Look at:
http://www.phpclasses.org/browse/package/92.html

It's a pager class that does:
<< Previous 1 2 3 4 5 6 7 8 9 10 Next >>



Gary Every
Sr. UNIX Administrator
Ingram Entertainment Inc.
2 Ingram Blvd, La Vergne, TN 37089
"Pay It Forward!"

-----Original Message-----
From: Kpromos [mailto:info@xxxxxxxxxxx] 
Sent: Thursday, May 20, 2004 8:35 AM
To: php-db@xxxxxxxxxxxxx
Subject:  Display mysql query results divided in dynamic
numbered pages
Importance: High

Dears, I'm new to php, so I'm not able to solve the following problem. I
have a function with a while loop that generates the results of a mysql
query. I'd need to generate a flow of the results, divided in pages as
... <Previous> 1 2 3 4 <Next> ...

The function I'm using follows .. and also the script that should
generate the numbered pages. Someone could help me in incorporating the
script that follows too?

===== function displaying the results ======

function display($show_what) {
	switch ($show_what) {
		case "":
		$sql = "select * from news2 ORDER BY date DESC, time
DESC";
		break;
}
	display_posts($sql);
	}
	
function display_posts($sql) {
	connect();
	$result = mysql_query($sql) or die(mysql_error()); 
	
	?>
      <table width="100%" border="0" cellpadding="5" align="CENTER">
        <tr>
          <td> <hr align="RIGHT" size="1" width="100%" noshade> </td>
        </tr>
    <?
	while($row = mysql_fetch_array($result)) {
	?> 	<tr><td> <?
	if($last_date == $row["date"]):?>
	<p class="date"><b><?echo $row["time"]?></b>
	<?else:?>
	<p class="date"><?echo $row["time"]?> - <b><?echo
$row["date"]?></b>
	<?endif;
	$cat_num = $row["category_id"];
	$cat_result = mysql_query("select categories.category from
news2, categories where news2.category_id = categories.category_id and
news2.category_id = '$cat_num'");
	$cat = mysql_fetch_array($cat_result);
	?>

	              <br>
................
..........
         </tr>
        <?
	}
	?>
      </table>
      <?
	}
	
=== script for generating the pages ===

$table = 'news2'; // The name of your table in the database
$limit = '2'; // How many results should be shown at a time
$scroll = '10'; // How many elements to the navigation bar are shown at
a time

// Get the total number of rows in a database
$query1 = mysql_query ("SELECT * FROM news2");
$numrows = mysql_num_rows ($query1);
//

if (!isset ($_GET[show])) {
	$display = 1; // Change to $NUMROWS if DESCENDING order is
required
} else {
	$display = $_GET[show];
}

// Return results from START to LIMIT
$start = (($display * $limit) - $limit);
$query2 = mysql_query ("SELECT * FROM $table LIMIT $start,$limit");

while ($myrow = mysql_fetch_array ($query2)) {
	echo "<p>".$myrow[ROW]."</p>"; // EDIT TO REFLECT YOUR RESULTS
}
//

$paging = ceil ($numrows / $limit);

// Display the navigation
if ($display > 1) {
	$previous = $display - 1;
	echo "<a href=\"$_SERVER[PHP_SELF]?show=1\"><< First</a> | ";
	echo "<a href=\"$_SERVER[PHP_SELF]?show=$previous\"><
Previous</a> | ";

}

if ($numrows != $limit) {
	if ($paging > $scroll) {
		$first = $_GET[show];
		$last = ($scroll - 1) + $_GET[show];
	} else {
		$first = 1;
		$last = $paging;
	}
		if ($last > $paging ) {
			$first = $paging - ($scroll - 1);
			$last = $paging;
	}
	for ($i = $first;$i <= $last;$i++){
		if ($display == $i) {
			echo "<b>$i</b> ";
		} else {
			echo "<a
href=\"$_SERVER[PHP_SELF]?show=$i\">$i</a> ";
		}
	}
}

if ($display < $paging) {
	$next = $display + 1;
	echo "| <a href=\"$_SERVER[PHP_SELF]?show=$next\">Next ></a> |
";
	echo "<a href=\"$_SERVER[PHP_SELF]?show=$numrows\">Last >></a>";
}
//
?>

Thanks for all,
	Alessandro Folghera

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php