LLMS_Student::get_favorites( string $order_by = 'updated_date', string $order = 'DESC', int $limit = -1 )
Retrieve user’s favorites based on supplied criteria.
Parameters Parameters
- $order_by
-
(string) (Optional) Result set ordering field. Default "updated_date".
Default value: 'updated_date'
- $order
-
(string) (Optional) Result set order. Default "DESC". Accepts "DESC" or "ASC".
Default value: 'DESC'
- $limit
-
(int) (Optional) Number of favorites to return. Default is infinite.
Default value: -1
Return Return
(bool|array)
Source Source
File: includes/models/model.llms.student.php
public function get_favorites( $order_by = 'updated_date', $order = 'DESC', $limit = -1 ) {
global $wpdb;
$limit_clause = $limit < 1 ? '' : 'LIMIT 0, ' . intval( $limit );
$res = $wpdb->get_results(
$wpdb->prepare(
"SELECT * FROM {$wpdb->prefix}lifterlms_user_postmeta
WHERE meta_key = %s AND user_id = %d ORDER BY %s %s %s;",
'_favorite',
get_current_user_id(),
$order_by,
'DESC' === $order ? 'DESC' : 'ASC',
$limit_clause
)
);
return empty( $res ) ? false : $res;
}
Expand full source code Collapse full source code View on GitHub
Changelog Changelog
| Version | Description |
|---|---|
| 7.5.0 | Introduced. |