Skip to content

Instantly share code, notes, and snippets.

@rveitch

rveitch/wordPress_table_pagination_example.php

Created July 30, 2015 01:44
Show Gist options
  • Save rveitch/3edcbdf3797b1ff5a27f to your computer and use it in GitHub Desktop.
Save rveitch/3edcbdf3797b1ff5a27f to your computer and use it in GitHub Desktop.
Download ZIP
WordPress Table Pagination Example
Raw
wordPress_table_pagination_example.php
<?php
global $wpdb;
$pagenum = isset( $_GET['pagenum'] ) ? absint( $_GET['pagenum'] ) : 1;
$limit = 5;
$offset = ( $pagenum - 1 ) * $limit;
$entries = $wpdb->get_results( "SELECT * FROM {$wpdb->prefix}posts LIMIT $offset, $limit" );
echo '<div class="wrap">';
?>
<table class="widefat">
<thead>
<tr>
<th scope="col" class="manage-column column-name" style="">Post Title</th>
<th scope="col" class="manage-column column-name" style="">Date</th>
</tr>
</thead>
<tfoot>
<tr>
<th scope="col" class="manage-column column-name" style="">Post Title</th>
<th scope="col" class="manage-column column-name" style="">Date</th>
</tr>
</tfoot>
<tbody>
<?php if( $entries ) { ?>
<?php
$count = 1;
$class = '';
foreach( $entries as $entry ) {
$class = ( $count % 2 == 0 ) ? ' class="alternate"' : '';
?>
<tr<?php echo $class; ?>>
<td><?php echo $entry->post_title; ?></td>
<td><?php echo $entry->post_date; ?></td>
</tr>
<?php
$count++;
}
?>
<?php } else { ?>
<tr>
<td colspan="2">No posts yet</td>
</tr>
<?php } ?>
</tbody>
</table>
<?
$total = $wpdb->get_var( "SELECT COUNT(`id`) FROM {$wpdb->prefix}posts" );
$num_of_pages = ceil( $total / $limit );
$page_links = paginate_links( array(
'base' => add_query_arg( 'pagenum', '%#%' ),
'format' => '',
'prev_text' => __( '&laquo;', 'aag' ),
'next_text' => __( '&raquo;', 'aag' ),
'total' => $num_of_pages,
'current' => $pagenum
) );
if ( $page_links ) {
echo '<div class="tablenav"><div class="tablenav-pages" style="margin: 1em 0">' . $page_links . '</div></div>';
}
echo '</div>';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment