Learn VBA & Macros in 1 Week!

PHP - Php Mysql Pagination

Full Excel VBA Course - Beginner to Expert

Php Mysql Pagination	View Content

Full Excel VBA Course - Beginner to Expert

Pagination In Php/mysql

Similar Tutorials

View Content

ARGHHHHH pagination, again? I know!

OK here is a code that I worked on to get a grocery store items list displayed in a table in a paginated design. Everything is working fine except I don't know how to dynamically display auto incremented indexID range on that particular page, like 1-10 11-20 21-30 31-40 and so on (something like amazon items in cart) instead of page numbers << < 1 2 3 4 > >> as pagination hyperlink to move between different pages. Any help will be greatly appreciated.

Code: [Select]
<?php
// database connection info
$conn = mysql_connect('host','user','password') or trigger_error("SQL", E_USER_ERROR);
$db = mysql_select_db('dbName',$conn) or trigger_error("SQL", E_USER_ERROR);

// find out how many rows are in the table
$sql = "SELECT COUNT(*) FROM store";
$result = mysql_query($sql, $conn) or trigger_error("SQL", E_USER_ERROR);
$r = mysql_fetch_row($result);
$numrows = $r[0];

// number of rows to show per page
$rowsperpage = 10;
// find out total pages
$totalpages = ceil($numrows / $rowsperpage);

// get the current page or set a default
if (isset($_GET['currentpage']) && is_numeric($_GET['currentpage'])) {
   // cast var as int
   $currentpage = (int) $_GET['currentpage'];
} else {
   // default page num
   $currentpage = 1;
} // end if

// if current page is greater than total pages...
if ($currentpage > $totalpages) {
   // set current page to last page
   $currentpage = $totalpages;
} // end if
// if current page is less than first page...
if ($currentpage < 1) {
   // set current page to first page
   $currentpage = 1;
} // end if

// the offset of the list, based on current page
$offset = ($currentpage - 1) * $rowsperpage;

// get the info from the db
$sql = "SELECT indexID, item, price FROM store LIMIT $offset, $rowsperpage";
$result = mysql_query($sql, $conn) or trigger_error("SQL", E_USER_ERROR);

// while there are rows to be fetched...
echo "<p><table><tr><td><strong>Item</strong></td><td><strong>Price</strong></td></tr>";
while ($list = mysql_fetch_assoc($result)) {
   echo "<tr>";
   echo "<td>" . $list['item'] . "</td>";
   echo "<td>$" . $list['price'] . "</td>";
   echo "</tr>";
} // end while
echo "</table></p><br /><br />";

/******  build the pagination links ******/
// range of num links to show

$range = 3;

// if not on page 1, don't show back links
if ($currentpage > 1) {
   // show << link to go back to page 1
   echo " <a href='{$_SERVER['PHP_SELF']}?currentpage=1'><<</a> ";
   // get previous page num
   $prevpage = $currentpage - 1;
   // show < link to go back to 1 page
   echo " <a href='{$_SERVER['PHP_SELF']}?currentpage=$prevpage'><</a> ";
} // end if

// loop to show links to range of pages around current page
for ($x = ($currentpage - $range); $x < (($currentpage + $range) + 1); $x++) {
   // if it's a valid page number...
   if (($x > 0) && ($x <= $totalpages)) {
      // if we're on current page...
      if ($x == $currentpage) {
         // 'highlight' it but don't make a link
         echo " <b>$x</b> ";
      // if not current page...
      } else {
         // make it a link
         echo " <a href='{$_SERVER['PHP_SELF']}?currentpage=$x'>$x</a> ";
      } // end else
   } // end if
} // end for

// if not on last page, show forward and last page links
if ($currentpage != $totalpages) {
   // get next page
   $nextpage = $currentpage + 1;
    // echo forward link for next page
   echo " <a href='{$_SERVER['PHP_SELF']}?currentpage=$nextpage'>></a> ";
   // echo forward link for lastpage
   echo " <a href='{$_SERVER['PHP_SELF']}?currentpage=$totalpages'>>></a> ";
} // end if
/****** end build pagination links ******/
?>

Help In Pagination Without Mysql

Similar Tutorials

View Content

hi every one thanks for this forum i want help please i want add pagination to this script and listed the floder by last modification

<table width='100%' border='0'>
<?php
$gr = "music/Musique-Maghreb/";
$gr="music/$cat/";
$rep=opendir($gr);
$c=1;
while ($file = readdir($rep)){
	if($file != '..' && $file !='.' && $file !=''){ 
if (file_exists("images/$file.jpg")) {
$img="images/$file.jpg";
} else {
$img="images/nophoto.jpg";
}
if ($c==1) {
echo "<tr>";
}
?>
<?php echo $file;?>
</tr>
              <TR>
<tr>
    <td>
 
</td>
</tr>
</tbody>
</table><?php
if($c==5) {
echo "</tr>";
$c=0;
}
$c++;
}
}
 
closedir($rep);
clearstatcache();
?>
 
</td>
</center></div>
</table>

Similar Tutorials

View Content

Pagination Help

Similar Tutorials

View Content

Hello friends. I have a pagination script and there are 3 issues I cant seem to figure out. Here is the code:

Code: [Select]
<?php
// page_name.php

$page = $_GET['page'];

//some code

$your_db = @ new mysqli("hostname", "username", "password");
if (mysqli_connect_errno())
{
    echo 'ERROR!<br />'.mysqli_connect_errno()
            .' - Not connected : '.mysqli_connect_error().'<br />';
    die;
}
else
{
    $db_connect = $your_db->select_db("database");
    if (!$db_connect)
    {
        echo 'ERROR CONNECT DATA BASE';
        die;
    }
}

$query = "select fldIconMedium, fldTitle, fldLink from games";
//$result = $db_connect->query($query);
$result = $your_db->query($query);
$number_of_records = $result->num_rows;
$num_pages = $number_of_records / 16;
if (($number_of_records % 16) > 0 )
{
    $num_pages++;
}

if (strlen($page) == 0)
{
    $page = 0;
}
else
{
    $page = $page * 16;
}

$br = 1;
$result->data_seek($page);
for ($i = $page; $i < $number_of_records; $i++)
{
    //$row = $result->fetch_array();
    $row = $result->fetch_assoc();
    if ($br <= 16)
    {
        echo '<b>'.stripslashes($row['fldIconMedium']).' </b>';
        echo stripslashes($row['fldTitle']).' ';
        echo '<b>'.stripslashes($row['fldLink']).'</b><br />';
        $br++;
    }
    else
    {
        break;
    }
}

for ($j = 0; $j < $num_pages; $j++)
{
    $page_link = $j + 1;
    echo '<a href="games2.php?page='.$j.'">'.$page_link.'</a>';
}
echo ' '.$number_of_records;

?>

Here is a database I am using:

|fldID| |fldTitle| | fldCategory | fldIconMedium | | fldLink |
2415 Krusty Fun House Skills krusty.jpg games.php?id=2415
2415 Krusty Fun House Skills krusty.jpg games.php?id=2415
2415 Krusty Fun House Skills krusty.jpg games.php?id=2415
2415 Krusty Fun House Adventure krusty.jpg games.php?id=2415
2415 Krusty Fun House Adventure krusty.jpg games.php?id=2415
2415 Krusty Fun House Adventure krusty.jpg games.php?id=2415
2415 Krusty Fun House Action krusty.jpg games.php?id=2415
2415 Krusty Fun House Action krusty.jpg games.php?id=2415
2415 Krusty Fun House Action krusty.jpg games.php?id=2415

I have a couple of issues as I am still a noob learning PHP.
=====================================

1. I have no idea how to add a 'Previous' and 'Next' button to the pagination number bar.

2. My results are displayed vertical and I can't make my results display in a horizontal view. 5 results going from left to right and results from top to bottom Basically 5 x 7 table

3. I have an issue with categorizing my games in my pagination table. I have multiple categories like Action, Skills, Arcade, Skills, Mind, Shooter in my database. For example, the pagination script above creates the link to be like this '.php?page=1', when in fact I want the script to search for categories games, example '.php?page=skills', '.php?page=action', '.php?page=adventure' etc..., linking them to the 'fldCategory' column which has the list of the category names of games, and then fetching all the rows of that particular game category and be displayed in the 5 x 7 table. For each result, it would have the Image Icon (fldIconMedium), the Title (fldTitle) under it, and both of them hyper linked to their links from the 'fldLinks' column.

I would really appreciate the help. It has been 2 weeks and I'm very frustrated that I can't figure the 3 points out.

Php Pagination

Similar Tutorials

View Content

Hi guys, please go to this url , http://mcfly1111.blogspot.com/2011/01/pagination.html . i typed out everything there. ifyou can correct my codes, that will be great but any help will be appreciated, thanks!

Need Help With Pagination

Similar Tutorials

View Content

My php/mysql book doesn't cover pagination so I've been searching the web for a simple pagination script that I can learn from.

I got the following one working at http://www.phpsimplicity.com/tips.php?id=1 but it's just showing the next and prev links... no results on the pages and you can click on the next link forever when there's only 11 records in the table I queried.

How can I display results on each page and have the info append to the next page? This is the second example I've tried and none seem to explain this part?