/PHP/Make pagination wordpress admin panel

Make pagination wordpress admin panel

// page parameter
$pagenum = isset( $_GET['pagenum'] ) ? absint( $_GET['pagenum'] ) : 1;
// Find total number of records

$limit = 10; // number of rows in page
$offset = ( $pagenum - 1 ) * $limit;
$total = $wpdb->get_var( "SELECT COUNT(`id`) FROM {$wpdb->prefix}table_name" );
$num_of_pages = ceil( $total / $limit );

// Give Limit
$entries = $wpdb->get_results( "SELECT * FROM {$wpdb->prefix}table_name LIMIT $offset, $limit" );


// add this code where you want to add pagintaion
$page_links = paginate_links( array(
    'base' => add_query_arg( 'pagenum', '%#%' ),
    'format' => '',
    'prev_text' => __( '«', 'text-domain' ),
    'next_text' => __( '»', 'text-domain' ),
    '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>';
}

Source: stackoverflow.com

Similar codes

3 votes284 views2 answers
Laravel validation check value should be one of in array
PHP Laravel
12 votes256 views5 answers
Drop column migration laravel
PHP Laravel
47 votes307 views6 answers
How to run specific seeder in laravel
PHP Laravel
0 vote286 views1 answer
Laravel seed timestamps columns
PHP Laravel
0 vote240 views1 answer
Php check if checkbox isset
PHP
0 vote240 views1 answer
How get query logs in laravel
PHP
1 vote242 views1 answer
Regex php password
PHP
0 vote295 views1 answer
How to call function in blade laravel
PHP
0 vote237 views1 answer
Wp_query order by taxonomy
PHP
0 vote253 views1 answer
How to Add Custom Navigation Menus in WordPress Themes
PHP