StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PONot displaying links
primarykey
Id
6574960
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
6
CommunityOwnedDate
CreationDate
2011-07-04T18:30:00.963
FavoriteCount
0
LastActivityDate
2011-07-04T18:39:42.107
LastEditDate
2011-07-04T18:39:42.107
LastEditorUserId
1244239
OwnerUserId
1244239
ParentId
0
PostTypeId
1
Score
0
ViewCount
271
LastEditorDisplayName
text
Body
<p>I'm not sure why but this pagination plugin is NOT displaying the pagelinks and I'm not sure why.</p> <pre><code>(function($) { $.extend({ tablesorterPager: new function() { function updatePageDisplay(c) { var s = $(c.cssPageDisplay,c.container).val((c.page+1) + c.seperator + c.totalPages); } function setPageSize(table,size) { var c = table.config; c.size = size; c.totalPages = Math.ceil(c.totalRows / c.size); c.pagerPositionSet = false; moveToPage(table); fixPosition(table); } function fixPosition(table) { var c = table.config; if(!c.pagerPositionSet && c.positionFixed) { var c = table.config, o = $(table); if(o.offset) { c.container.css({ top: o.offset().top + o.height() + 'px', position: 'absolute' }); } c.pagerPositionSet = true; } } function moveToFirstPage(table) { var c = table.config; c.page = 0; moveToPage(table); } function moveToLastPage(table) { var c = table.config; c.page = (c.totalPages-1); moveToPage(table); } function moveToNextPage(table) { var c = table.config; c.page++; if(c.page >= (c.totalPages-1)) { c.page = (c.totalPages-1); } moveToPage(table); } function moveToPrevPage(table) { var c = table.config; c.page--; if(c.page <= 0) { c.page = 0; } moveToPage(table); } function moveToPage(table) { var c = table.config; if(c.page < 0 || c.page > (c.totalPages-1)) { c.page = 0; } renderTable(table, c.rowsCopy); } function renderTable(table,rows) { var c = table.config; var l = rows.length; var s = (c.page * c.size); var e = (s + c.size); if(e > rows.length ) { e = rows.length; } if (c.afterPagingCallBack) c.afterPagingCallBack(); var tableBody = $(table.tBodies[0]); // clear the table body $.tablesorter.clearTableBody(table); for(var i = s; i < e; i++) { //tableBody.append(rows[i]); var o = rows[i]; var l = o.length; for(var j=0; j < l; j++) { tableBody[0].appendChild(o[j]); } } fixPosition(table,tableBody); $(table).trigger("applyWidgets"); if( c.page >= c.totalPages ) { moveToLastPage(table); } updatePageDisplay(c); } this.appender = function(table,rows) { var c = table.config; c.rowsCopy = rows; c.totalRows = rows.length; c.totalPages = Math.ceil(c.totalRows / c.size); renderTable(table,rows); }; this.defaults = { size: 1, offset: 0, page: 0, totalRows: 0, totalPages: 0, container: null, cssNext: '.next', cssPrev: '.prev', cssFirst: '.first', cssLast: '.last', cssPageDisplay: '.pagedisplay', cssPageSize: '.pagesize', cssPageLinks: 'a.pageLink', // extension setting seperator: "/", positionFixed: false, // defaulting this to false. original value is true. appender: this.appender, afterPagingCallBack: null }; this.construct = function(settings) { return this.each(function() { config = $.extend(this.config, $.tablesorterPager.defaults, settings); var table = this, pager = config.container; $(this).trigger("appendCache"); var $pageSizeEl = $( ".pagesize", pager ); if( $pageSizeEl.length > 0 ) config.size = parseInt( $pageSizeEl.val() ); $(config.cssFirst,pager).click(function() { moveToFirstPage(table); return false; }); $(config.cssNext,pager).click(function() { moveToNextPage(table); return false; }); $(config.cssPrev,pager).click(function() { moveToPrevPage(table); return false; }); $(config.cssLast,pager).click(function() { moveToLastPage(table); return false; }); $(config.cssPageSize,pager).change(function() { setPageSize(table,parseInt($(this).val())); return false; }); // Extension code $( config.cssPageLinks, pager ).first().parent().addClass( 'current' ); // add the "currently selected" class to the first link $( config.cssPageLinks, pager ).click( function() { var $el = $(this); // Remove the "current" (selected) class from all links, // and then add it to the one that was just clicked. $( config.cssPageLinks, pager ).parent().removeClass( 'current' ); $el.parent().addClass( 'current' ); table.config.page = parseInt( $el.html() ) - 1; moveToPage( table ); return false; } ); }); }; } }); // extend plugin scope $.fn.extend({ tablesorterPager: $.tablesorterPager.construct }); })(jQuery); </code></pre> <p>Here's my actual page.</p> <pre><code><script type="text/javascript"> $(document).ready(function() { $('#usersPageList').tablesorter().tablesorterPager({container:$('#usersPageList .pagination'),cssPageLinks:'a.pageLink'}); $('a.bt_green').click(function(e) { e.preventDefault(); $('div.right_content').load('forms/addnew/' + $(this).attr('id')); }); $('table tr').click(function() { checkBox = $(this).children('td').children('input[type=checkbox]'); if(checkBox.attr('checked')) checkBox.removeAttr('checked'); else checkBox.attr('checked', 'checked'); }); $('.ask').jConfirmAction(); $('.ask2').jConfirmAction({question : "Are you sure you want to delete all selected user accounts?", yesAnswer : "Yes", cancelAnswer : "No"}); }); </script> <h2>User Accounts</h2> <table id="usersPageList" class="rounded-corner"> <thead> <tr> <th scope="col" class="rounded-first"></th> <th scope="col" class="rounded">Name</th> <th scope="col" class="rounded">Email Address</th> <th scope="col" class="rounded">Username</th> <th scope="col" class="rounded">Edit</th> <th scope="col" class="rounded-last">Delete</th> </tr> </thead> <tfoot> <tr> <td colspan="5" class="rounded-foot-left"><em>Displays all of the registered and verified users!</em></td> <td class="rounded-foot-right">&nbsp;</td> </tr> </tfoot> <tbody> <?php while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) { echo "<tr>"; echo "<td><input type=\"checkbox\" name=\"users[]\" value=\"".$row['userID']."\"/></td>"; echo "<td>".$row['name']."</td>"; echo "<td>".$row['emailAddress']."</td>"; echo "<td>".$row['username']."</td>"; echo "<td><a href=\"#\"><img src=\"images/user_edit.png\" alt=\"\" title=\"\" border=\"0\" /></a></td>"; echo "<td>"; if (($row['userID'] !== '10000') && ($row['userID'] !== $userID)){ echo "<a href=\"#\" class=\"ask\"><img src=\"images/trash.png\" class=\"delete\" alt=\"\" title=\"\" border=\"0\" id=\"".$row['userID']."\" /></a>"; } echo "</td>"; echo "</tr>"; } ?> </tbody> </table> <?php addRemove($fileName,$pageName); echo "<div class=\"pagination\">"; echo "</div>"; ?> </code></pre>
Tags
<jquery><jquery-plugins>
Title
Not displaying links
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. USJeff Davidson
UserOwnerUserId
1. USJeff Davidson
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. This table or related slice is empty.
CommentsPostId

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.