BP_Group_Membership_Export::get_data( $user, $page )
Get data & count of groups by page and user.
Description
Parameters
- $user
-
(Required)
- $page
-
(Required)
Return
(array)
Source
File: bp-core/gdpr/class-bp-group-membership-export.php
function get_data( $user, $page ) {
global $wpdb, $bp;
$wpdb->show_errors( false );
$group_table = $bp->groups->table_name_members;
$table = "{$group_table} item";
$query_select = "item.*";
$query_select_count = "COUNT(item.id)";
$query_where = "item.user_id=%d OR item.inviter_id=%d";
$offset = ( $page - 1 ) * $this->items_per_batch;
$limit = "LIMIT {$this->items_per_batch} OFFSET {$offset}";
$query = "SELECT {$query_select} FROM {$table} WHERE {$query_where} {$limit}";
$query = $wpdb->prepare( $query, $user->ID, $user->ID );
$query_count = "SELECT {$query_select_count} FROM {$table} WHERE {$query_where}";
$query_count = $wpdb->prepare( $query_count, $user->ID, $user->ID );
$count = (int) $wpdb->get_var( $query_count );
$items = $wpdb->get_results( $query );
return array(
'total' => $count,
'offset' => $offset,
'items' => $items,
);
}
Changelog
| Version | Description |
|---|---|
| BuddyBoss 1.0.0 | Introduced. |
Questions?
We're always happy to help with code or other questions you might have! Search our developer docs, contact support, or connect with our sales team.