Paginate

Ìgbéwọlẹ̀

Install and Activate

1. Download and unzip paginate.zip.
2. Upload the paginate directory to the /wp-content/plugins/ directory.
3. Activate the plugin through the Plugins menu in WordPress.
4. In your theme, modify the CSS file to change the look and feel of your pagination.

Implement

3 line implementation

<?php
$totalitems = $wpdb->get_var("SELECT COUNT(ID) FROM $wpdb->users");
$p = new paginate($totalitems);
echo $p->get_pagination();
?>

Post onpage argument

<?php
$onPage = $_GET['page']
$totalitems = $wpdb->get_var("SELECT COUNT(ID) FROM $wpdb->users");
$p = new paginate($totalitems);
echo $p->get_pagination($onPage);
?>

Example implementation

<?php
//get total items from database
$totalitems = $wpdb->get_var("SELECT COUNT(ID) FROM $wpdb->users");

$p = new paginate($totalitems);
$limit = $p->itemsPerPage;
$offset = $p->get_offset();

//your query. add the offset and limit to the query
$query = "SELECT $wpdb->users.ID FROM $wpdb->users LIMIT $offset, $limit";
$user_ids = $wpdb->get_results($query);
//your loop
foreach($user_ids as $id) {
  //do something...
}

//pagination html
echo $p->get_pagination();
?>