WP_Network_Query::parse_orderby( string $orderby )

Parses and sanitizes ‘orderby’ keys passed to the network query.


Parameters

$orderby

(string) (Required) Alias for the field to order by.


Return

(string|false) Value to used in the ORDER clause. False otherwise.


Source

File: wp-includes/class-wp-network-query.php

	protected function parse_orderby( $orderby ) {
		global $wpdb;

		$allowed_keys = array(
			'id',
			'domain',
			'path',
		);

		$parsed = false;
		if ( $orderby == 'network__in' ) {
			$network__in = implode( ',', array_map( 'absint', $this->query_vars['network__in'] ) );
			$parsed = "FIELD( {$wpdb->site}.id, $network__in )";
		} elseif ( $orderby == 'domain_length' || $orderby == 'path_length' ) {
			$field = substr( $orderby, 0, -7 );
			$parsed = "CHAR_LENGTH($wpdb->site.$field)";
		} elseif ( in_array( $orderby, $allowed_keys ) ) {
			$parsed = "$wpdb->site.$orderby";
		}

		return $parsed;
	}


Changelog

Changelog
Version Description
WP-4.6.0 Introduced.