/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

15 votes117 views1 answer
The requested PHP extension pcntl is missing from your system
PHP
11 votes118 views4 answers
How to remove NULL values in array PHP
PHP
0 vote153 views1 answer
Use backpack and laravel-permission to edit user roles
PHP Laravel
0 vote133 views2 answers
Only Show Specific Countries In Caldera Forms Phone Field
PHP
0 vote153 views2 answers
Laravel filemanger choose multiple images
PHP Laravel
0 vote92 views1 answer
Laravel secure route
PHP
1 vote158 views1 answer
Date casting from datetime to d-m-Y laravel
PHP Laravel
0 vote122 views1 answer
Php print array source code
PHP
11 votes138 views3 answers
Laravel get last month records
PHP Laravel
22 votes125 views2 answers
The PHP Else If statement must be preceded by an If statement before it can be used.
PHP