如何在wordpress管理页面(预订)中添加分页，以及如何将我的预订打印为pdf

Question

我想在我创建的插件页面中显示分页。.

如果有人能帮忙，我很感激我希望在后端(在管理中(而不是前端进行分页，并将预订打印为pdf。这是我的功能如何添加分页并打印为pdf？

谢谢

function friday_reservations(){ 
<div class="wrap">
<h1>Reservations</h1>
<table class="wp-list-table widefat striped">
<thead>
<tr>
<th class="manage-column">ID</th>
<th class="manage-column">Gebet</th>
<th class="manage-column">Genre</th>
<th class="manage-column">Name</th>
<th class="manage-column">Last Name</th>
<th class="manage-column">E-mail</th>
<th class="manage-column">Phone</th>
<th class="manage-column">Number</th>
<th class="manage-column">Delete</th>

</tr>
</thead>
<tbody>
<?php
global $wpdb;
$table = $wpdb->prefix . 'fridyreservation';
$reservations = $wpdb->get_results("SELECT * FROM $table", ARRAY_A);

foreach($reservations as $reservation): ?>
<tr>
<td><?php echo $reservation['id']; ?></td>
<td><?php echo $reservation['predigt']; ?></td>
<td><?php echo $reservation['genre']; ?></td>
<td><?php echo $reservation['fname']; ?></td>
<td><?php echo $reservation['lname']; ?></td>
<td><?php echo $reservation['email']; ?></td>
<td><?php echo $reservation['phone']; ?></td>
<td><?php echo $reservation['pnumber']; ?></td>
<td>
<a href="#" class="remove_reservation" data-reservation="<?php echo $reservation['id']; ?>">Remove</a>
</td>

</tr>

<?php endforeach;
?>
</tbody>
</table>
</div>

这部分是数据库功能：

function friday_reservation_database(){
global $wpdb;
global $friday_reservation_db_version;
$friday_reservation_db_version = "1.1";
$table = $wpdb->prefix . 'fridyreservation';
$charset_collate = $wpdb->get_charset_collate();
//SQL Statement
$sql = "CREATE TABLE $table(
id mediumint(9) NOT NULL AUTO_INCREMENT,
predigt varchar(50) NOT NULL,
genre varchar(50) NOT NULL,
fname varchar(50) NOT NULL,
lname varchar(50) NOT NULL,
email varchar(50) DEFAULT '' NOT NULL,
phone varchar(10) NOT NULL,
pnumber varchar(1) NOT NULL,
PRIMARY KEY (id)
)$charset_collate; ";
require_once(ABSPATH . 'wp-admin/includes/upgrade.php');
dbDelta( $sql);

}add_action('after_setup_theme'，'friday_reservation_database'(；

Answer 1

解决方案是分层

在我自己定制的插件中添加wordpress管理中的分页

$pagenum = isset( $_GET['pagenum'] ) ? absint( $_GET['pagenum'] ) : 1;
$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 );``
$entries = $wpdb->get_results( "SELECT * FROM {$wpdb->prefix}table_name LIMIT $offset, $limit" );
$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>';
}

这都是