<?php // WordPress $items_per_page = 10; $page = isset( $_GET['cpage'] ) ? abs( (int) $_GET['cpage'] ) : 1; $offset = ( $page * $items_per_page ) - $items_per_page; $query = 'SELECT * FROM '. $table_name; $total_query = "SELECT COUNT(1) FROM (${query}) AS combined_table"; $total = $wpdb->get_var( $total_query ); $results = $wpdb->get_results( $query.' ORDER BY id DESC LIMIT '. $offset.', '. $items_per_page, OBJECT ); echo paginate_links( array( 'base' => add_query_arg( 'cpage', '%#%' ), 'format' => '', 'prev_text' => __('« Prev'), 'next_text' => __('Next »'), 'total' => ceil($total / $items_per_page), 'current' => $page ));Related Keywords: Developer, How-to, Solved, PHP Pagination, Reference
喜歡這篇文章嗎?
![1 粒星 1 粒星](data:image/svg+xml,%3Csvg%20xmlns=%22http://www.w3.org/2000/svg%22%20viewBox=%220%200%20210%20140%22%3E%3C/svg%3E)
![2 粒星 2 粒星](data:image/svg+xml,%3Csvg%20xmlns=%22http://www.w3.org/2000/svg%22%20viewBox=%220%200%20210%20140%22%3E%3C/svg%3E)
![3 粒星 3 粒星](data:image/svg+xml,%3Csvg%20xmlns=%22http://www.w3.org/2000/svg%22%20viewBox=%220%200%20210%20140%22%3E%3C/svg%3E)
![4 粒星 4 粒星](data:image/svg+xml,%3Csvg%20xmlns=%22http://www.w3.org/2000/svg%22%20viewBox=%220%200%20210%20140%22%3E%3C/svg%3E)
![5 粒星 5 粒星](data:image/svg+xml,%3Csvg%20xmlns=%22http://www.w3.org/2000/svg%22%20viewBox=%220%200%20210%20140%22%3E%3C/svg%3E)
(暫時未有評分)
Loading...
![1 粒星 1 粒星](https://www.imnobby.com/wp-content/plugins/wp-postratings/images/stars_crystal/rating_off.gif)
![2 粒星 2 粒星](https://www.imnobby.com/wp-content/plugins/wp-postratings/images/stars_crystal/rating_off.gif)
![3 粒星 3 粒星](https://www.imnobby.com/wp-content/plugins/wp-postratings/images/stars_crystal/rating_off.gif)
![4 粒星 4 粒星](https://www.imnobby.com/wp-content/plugins/wp-postratings/images/stars_crystal/rating_off.gif)
![5 粒星 5 粒星](https://www.imnobby.com/wp-content/plugins/wp-postratings/images/stars_crystal/rating_off.gif)
(暫時未有評分)
![](https://www.imnobby.com/wp-content/plugins/wp-postratings/images/loading.gif)