Re: Display mysql query results divided in dynamic numbered pages
| From: | Ivan Rodriguez | Date: | Thu, 20 May 2004 14:10:22 +0000 |
| Subject: | Re: Display mysql query results divided in dynamic numbered pages | ||
| References: | 1 | Groups: | php.general.es |
| Request: | Send a blank email to general-es+get-48709@lists.php.net to get a copy of this message | ||
This list is to spanish speakers, if you want to ask in english ask in
general@lists.php.net
Now I put you some code to dispaly some results in some pages.
$SQL = "SELECT * FROM table";
$consulta = mysql_query($SQL, $conexion) or die(mysql_error());
$total = mysql_num_rows($consulta);
$limit = 10;
if(empty($_GET['page'])){
$page = 1;
} else {
$page = $_GET['page'];
}
$limitvalue1 = $page*$limit-($limit);
$SQL = "SELECT * FROM table LIMIT $limitvalue1, $limit";
$consulta = mysql_query($SQL, $conexion) or die(mysql_error());
echo '<table cellpadding="0" cellspacing="0" border="0"
width="100%">';
0;
while($datos = mysql_fetch_array($consulta)) {
echo '<tr><td>' .$datos[...]. '</td></tr>';
}
mysql_close();
echo '</table>';
$numofpages = $total/$limit;
echo '<table cellpadding="0" cellspacing="0" border="0"
width="100%"><tr><td style="padding-left: 5px; padding-top:
15px"><p>'.ucfirst($idioma[89]).': ';
for($i = 1; $i <= $numofpages; $i++) {
if($i != $page) {
echo "<a href=\"?page=$i\" style=\"font-weight:
normal\">" . $i .
"</a> ";
} else {
echo "<b>" . $i . "</b> ";
}
}
if($total%$limit != 0) {
if($i != $page) {
echo "<a href=\"?page=$i\" style=\"font-weight:
normal\">" . $i .
"</a> ";
} else {
echo "<b>" . $i . "</b>";
}
}
echo '</p></td></tr></table>';
----- Original Message -----
From: "Kpromos" <info@kpromos.com>
To: <php-es@lists.php.net>
Sent: Thursday, May 20, 2004 3:34 PM
Subject: [PHP-ES] Display mysql query results divided in dynamic numbered
pages
> 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 Spanish Localization Talk Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>