Contents

Code Reference Functions bp_esc_sql_order()

bp_esc_sql_order( string $order = '' )

Sanitize an ‘order’ parameter for use in building SQL queries.

Description

Strings like ‘DESC’, ‘desc’, ‘ desc’ will be interpreted into ‘DESC’. Everything else becomes ‘ASC’.

Parameters

$order

(Optional) The 'order' string, as passed to the SQL constructor.

Default value: ''

Return

(string) The sanitized value 'DESC' or 'ASC'.

Source

File: bp-core/bp-core-functions.php

360
361
362
363
function bp_esc_sql_order( $order = '' ) {
    $order = strtoupper( trim( $order ) );
    return 'DESC' === $order ? 'DESC' : 'ASC';
}

Expand full source code Collapse full source code

Changelog

Changelog
Version Description
BuddyPress 1.8.0 Introduced.
Used By
Used By Description
bp-messages/classes/class-bp-messages-thread.php: BP_Messages_Thread::get()

Query for recipients.
bp-messages/classes/class-bp-messages-message.php: BP_Messages_Message::get()

Query for messages
bp-messages/classes/class-bp-messages-notice.php: BP_Messages_Notice::get()

Query for Notices.
bp-core/classes/class-bp-invitation.php: BP_Invitation::get_order_by_sql()

Assemble the ORDER BY clause of a get() SQL statement.
bp-groups/classes/class-bp-groups-group.php: BP_Groups_Group::get()

Query for groups.
bp-members/classes/class-bp-signup.php: BP_Signup::get()

Fetch signups based on parameters.
Show 1 more used by Hide more used by

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.