get_var( $wpdb->prepare( "SELECT COUNT(*) FROM %i", $doc_table ) ); $total_pages = ceil( $total_items / $items_per_page ); // phpcs:ignore WordPress.Security.NonceVerification.Recommended $current_page = isset( $_GET['paged'] ) ? max( 1, intval( $_GET['paged'] ) ) : 1; $offset = ( $current_page - 1 ) * $items_per_page; $documents = $wpdb->get_results( $wpdb->prepare( "SELECT * FROM %i ORDER BY created_at DESC LIMIT %d OFFSET %d", $doc_table, $items_per_page, $offset ) ); ?>