Databases
StackOverflow2013
Postsdbo
POAdd Ellipsis in PHP Pagination
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POAdd Ellipsis in PHP Pagination
    primarykey
    data
    text
    <pre><code>. //Prev . for($number = 1; $number &lt;= $num_pages; $number++) { if($page == $number) { $navigator .= "&lt;b&gt;[$number]&lt;/b&gt; "; } else { $navigator .= "&lt;a href='?c=".$_SESSION['cID']".&amp;rows=".$per_page."&amp;page=$number'&gt;$number&lt;/a&gt; "; } } . //Next . </code></pre> <p>This is the snippet that prints number of pages.</p> <p><em>Sample output:</em></p> <p>Previous 1 2 3 4 <strong>[5]</strong> 6 7 8 9 10 Next</p> <p>5 is the current page.</p> <p><strong>Problem:</strong> page numbers are shown in sequence with no restrictions. If i have 100 pages, all numbers show up.</p> <p><strong>Question:</strong> I need my paging numbers appear as the following...</p> <p><strong>Assume we only have 7 ($num_pages) pages:</strong></p> <p>Previous 1 2 <strong>[3]</strong> 4 5 6 7 Next</p> <p><em><strong>Assume we have 90 pages:</em></strong></p> <p><strong>[1]</strong> 2 3 4 5 6 7 ... 90 Next</p> <p><em><strong>Assume user clicked the 7th page:</em></strong></p> <p>Previous 1 ... 5 6 <strong>[7]</strong> 8 9 10 11 ... 90 Next</p> <p><em><strong>Assume user clicked 11th page:</em></strong></p> <p>Previous 1 ... 9 10 <strong>[11]</strong> 12 13 14 15 ... 90 Next</p> <p><em><strong>Assume user clicked 15th page:</em></strong></p> <p>Previous 1 ... 13 14 <strong>[15]</strong> 16 17 18 19 ... 90 Next</p> <p><em><strong>Assume user clicked 90th page:</em></strong></p> <p>Previous 1 ... 84 85 86 87 88 89 <strong>[90]</strong></p> <p><em>Any help will be appreciated.</em></p>
    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. USuser311509
    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
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POAdd Ellipsis in PHP Pagination
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POAdd Ellipsis in PHP Pagination
      1. This table or related slice is empty.
      1. VTDownMod
    3. VO
      singulars
      1. POAdd Ellipsis in PHP Pagination
      1. This table or related slice is empty.
      1. VTUpMod
    1. COWhat have you tried so far? You're no novice in this site, you know we HELP you code, not CODE FOR YOU
      singulars
      1. POAdd Ellipsis in PHP Pagination
      1. USMadara Uchiha
    2. COI didn't request for exact solution ... Related resources, short pseudo-code or tips are sufficient.
      singulars
      1. POAdd Ellipsis in PHP Pagination
      1. USuser311509
    3. COI put together a simple PHP ellipsisizer for exactly this purpose. It is available on github, and I have explained it in more detail on my blog <http://bendalziel.com/blog.php?post_id=10195867736>
      singulars
      1. POAdd Ellipsis in PHP Pagination
      1. USbdalziel
 

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