Databases
StackOverflow2013
Postsdbo
POPHP MySql Pagination?
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POPHP MySql Pagination?
    primarykey
    data
    text
    <p>Pagination really confuses me. My code works but it only shows the first page. The next page doesn't work. I just want to show 3 records per page. Do you have to have another query to show the results of the second page?</p> <pre><code>&lt;?php // Connects to your Database mysql_connect("localhost", "root", "") or die(mysql_error()); mysql_select_db("db_pet") or die(mysql_error()); //This checks to see if there is a page number. If not, it will set it to page 1 if (!(isset($pagenum))) { $pagenum = 1; } //Here we count the number of results //Edit $data to be your query $data = mysql_query("SELECT * FROM tb_pet") or die(mysql_error()); $rows = mysql_num_rows($data); //This is the number of results displayed per page $page_rows = 3; //This tells us the page number of our last page $last = ceil($rows/$page_rows); //this makes sure the page number isn't below one, or more than our maximum pages if ($pagenum &lt; 1) { $pagenum = 1; } elseif ($pagenum &gt; $last) { $pagenum = $last; } //This sets the range to display in our query $max = 'limit ' .($pagenum - 1) * $page_rows .',' .$page_rows; //This is your query again, the same one... the only difference is we add $max into it $data_p = mysql_query("SELECT * FROM tb_pet $max") or die(mysql_error()); //This is where you display your query results while($info = mysql_fetch_array($data_p)) { Print $info['pet_name']; echo "&lt;br&gt;"; } echo "&lt;p&gt;"; // This shows the user what page they are on, and the total number of pages echo " --Page $pagenum of $last-- &lt;p&gt;"; // First we check if we are on page one. If we are then we don't need a link to the previous page or the first page so we do nothing. If we aren't then we generate links to the first page, and to the previous page. if ($pagenum == 1) { } else { echo " &lt;a href='{$_SERVER['PHP_SELF']}?pagenum=1'&gt; &lt;&lt;-First&lt;/a&gt; "; echo " "; $previous = $pagenum-1; echo " &lt;a href='{$_SERVER['PHP_SELF']}?pagenum=$previous'&gt; &lt;-Previous&lt;/a&gt; "; } //just a spacer echo " ---- "; //This does the same as above, only checking if we are on the last page, and then generating the Next and Last links if ($pagenum == $last) { } else { $next = $pagenum+1; echo " &lt;a href='{$_SERVER['PHP_SELF']}?pagenum=$next'&gt;Next -&gt;&lt;/a&gt; "; echo " "; echo " &lt;a href='{$_SERVER['PHP_SELF']}?pagenum=$last'&gt;Last -&gt;&gt;&lt;/a&gt; "; } ?&gt; </code></pre>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. This table or related slice is empty.
    1. USuser1551672
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. COI don't see how you pass page number to your code. Should be like `$pagenum = isset($_GET['pagenum']) ? (int)$_GET['pagenum'] : 1`
      singulars
      1. POPHP MySql Pagination?
      1. USAlexander Larikov
    2. COSee comment above, second your result never returns any different results without a LIMIT from the offset from and to the page rows (10 results per page, 0,9 - 10,19, etc).
      singulars
      1. POPHP MySql Pagination?
      1. USdbf
    3. COSeriously...there are 20 other people who asked the same question. Searching for php mysql pagination on google will give you like 400000 results
      singulars
      1. POPHP MySql Pagination?
      1. USChris
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload