/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

0 vote148 views1 answer
Wpdb->prepare
PHP
0 vote129 views1 answer
Thems
PHP
0 vote146 views1 answer
Editing items in collection in laravel 8
PHP Laravel
1 vote163 views1 answer
Run jobs laravel
PHP Laravel
1 vote129 views1 answer
Terug tellende for loop php
PHP
0 vote134 views1 answer
Using get in laravel blade
PHP
0 vote160 views1 answer
Laravel This package is not auto-updated. Please set up the GitHub Hook for Packagist so that it gets updated whenever you push!
PHP Laravel
16 votes127 views3 answers
Laravel request validate
PHP
24 votes180 views4 answers
Clear cache command in laravel controller
PHP
0 vote162 views1 answer
Js redirect in php
PHP