Contents

Code Reference Classes BP_Notification_Export BP_Notification_Export::get_data()

BP_Notification_Export::get_data( $user,  $page )

Returns the data & count of notifications by page and user.

Description

Parameters

$user

(Required)

$page

(Required)

Return

(array)

Source

File: bp-core/gdpr/class-bp-notification-export.php 

	function get_data( $user, $page ) {
		global $wpdb;

		$wpdb->show_errors( false );

		$table              = "{$wpdb->prefix}bp_notifications item";
		$query_select       = "item.*";
		$query_select_count = "COUNT(item.id)";
		$query_where        = "item.user_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 );
		$query_count = "SELECT {$query_select_count} FROM {$table} WHERE {$query_where}";
		$query_count = $wpdb->prepare( $query_count, $user->ID );

		$count = (int) $wpdb->get_var( $query_count );
		$items = $wpdb->get_results( $query );

		return array(
			'total'  => $count,
			'offset' => $offset,
			'items'  => $items,
		);

	}

Expand full source code Collapse full source code

Changelog

Changelog
Version Description
BuddyBoss 1.0.0 Introduced.

Uses

Uses
Uses Description
bp-core/bp-core-functions.php: bp_core_get_table_prefix()

Get the $wpdb base prefix, run through the ‘bp_core_get_table_prefix’ filter.

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.