Databases
StackOverflow2013
Postsdbo
POUsing a count ++ function with pagination
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POUsing a count ++ function with pagination
    primarykey
    data
    text
    <p>The HTML table below is paginated. On page one, <code>$count++</code> starts at one and then goes up, which is what I want. </p> <p>The problem is that when I click on page two, <code>$count++</code> starts at one again.</p> <p>How can I make it start at 101 on page two?</p> <pre><code>$presult = mysql_query("SELECT COUNT(*) FROM login") or die(mysql_error()); $rr = mysql_fetch_row($presult); $numrows = $rr[0]; $rowsperpage = 100; $totalpages = ceil($numrows / $rowsperpage); // get the current page or set a default if (isset($_GET['currentpage']) &amp;&amp; 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 &gt; $totalpages) { // set current page to last page $currentpage = $totalpages; } // end if // if current page is less than first page... if ($currentpage &lt; 1) { // set current page to first page $currentpage = 1; } // end if // the offset of the list, based on current page $offset = ($currentpage - 1) * $rowsperpage; $tzFrom3 = new DateTimeZone('America/New_York'); $tzTo3 = new DateTimeZone('America/Phoenix'); $sqlStr3 = "SELECT loginid, username, created, activated FROM login WHERE activated = 1 ORDER BY created ASC LIMIT $offset, $rowsperpage"; $result = mysql_query($sqlStr3); $arr = array(); echo "&lt;table&gt;"; while ($row = mysql_fetch_array($result)) { $dt3 = new DateTime($row["created"], $tzFrom3); $dt3-&gt;setTimezone($tzTo3); echo '&lt;tr class="backgroundnonttsu"&gt;'; echo '&lt;td&gt;'.$count++.'&lt;/td&gt;'; echo '&lt;td &gt;'.stripslashes($row["username"]).'&lt;/a&gt;&lt;/td&gt;'; echo '&lt;td &gt;'.$dt3-&gt;format('F j, Y').'&lt;/td&gt;'; echo '&lt;/tr&gt;'; } echo "&lt;/table&gt;"; $range = 3; /****** build the pagination links ******/ // range of num links to show // if not on page 1, don't show back links if ($currentpage &gt; 1) { // show &lt;&lt; link to go back to page 1 echo " &lt;div class='pages'&gt;&lt;a href='http://www.domain.com/directory/file.php?currentpage=1' class='links'&gt;&lt;&lt;&lt;/a&gt;&lt;/div&gt; "; // get previous page num $prevpage = $currentpage - 1; // show &lt; link to go back to 1 page echo " &lt;div class='pages'&gt;&lt;a href='http://www.domain.com/directory/file.php?currentpage=$prevpage' class='links'&gt;&lt;&lt;/a&gt;&lt;/div&gt; "; } // end if // loop to show links to range of pages around current page for ($x = ($currentpage - $range); $x &lt; (($currentpage + $range) + 1); $x++) { // if it's a valid page number... if (($x &gt; 0) &amp;&amp; ($x &lt;= $totalpages)) { // if we're on current page... if ($x == $currentpage) { // 'highlight' it but don't make a link echo " &lt;div class='pages'&gt;[&lt;b&gt;$x&lt;/b&gt;] &lt;/div&gt;"; // if not current page... } else { // make it a link echo " &lt;div class='pages'&gt;&lt;a href='http://www.domain.com/directory/file.php?currentpage=$x' class='links'&gt;$x&lt;/a&gt;&lt;/div&gt; "; } // 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 " &lt;div class='pages'&gt;&lt;a href='http://www.domain.com/directory/file.php?currentpage=$nextpage' class='links'&gt;&gt;&lt;/a&gt;&lt;/div&gt; "; // echo forward link for lastpage //echo " &lt;div class='pages'&gt;&lt;a href='http://www.domain.com/directory/file.php?currentpage=$totalpages' class='links'&gt;&gt;&gt;&lt;/a&gt;&lt;/div&gt; "; } // end if /****** end build pagination links ******/ </code></pre>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. This table or related slice is empty.
    1. USJohn
    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
    2. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POUsing a count ++ function with pagination
      1. This table or related slice is empty.
      1. VTUpMod
    1. This table or related slice is empty.
 

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