WPSEO_Bulk_List_Table::parse_item_query() │ protected │ Yoast 1.0

Parse the query to get items from database.

Based on given parameters there will be parse a query which will get all the pages/posts and other post_types from the database.

Метод класса: WPSEO_Bulk_List_Table{}

Хуков нет.

Возвращает

Строку.

Использование

// protected - в коде основоного (родительского) или дочернего класса
$result = $this->parse_item_query( $subquery, $all_states, $post_type_clause );

$subquery(строка) (обязательный)

SQL FROM part.

$all_states(строка) (обязательный)

SQL IN part.

$post_type_clause(строка) (обязательный)

SQL post type part.

Код WPSEO_Bulk_List_Table::parse_item_query() WPSEO Bulk List Table::parse item query ^{Yoast 22.4}

protected function parse_item_query( $subquery, $all_states, $post_type_clause ) {
	// Order By block.
	$orderby = isset( $_GET['orderby'] ) && is_string( $_GET['orderby'] ) ? sanitize_text_field( wp_unslash( $_GET['orderby'] ) ) : '';

	$orderby = ! empty( $orderby ) ? esc_sql( $orderby ) : 'post_title';
	$orderby = $this->sanitize_orderby( $orderby );

	// Order clause.
	$order = isset( $_GET['order'] ) && is_string( $_GET['order'] ) ? sanitize_text_field( wp_unslash( $_GET['order'] ) ) : '';
	$order = ! empty( $order ) ? esc_sql( strtoupper( $order ) ) : 'ASC';
	$order = $this->sanitize_order( $order );

	// Get all needed results.
	$query = "
		SELECT ID, post_title, post_type, post_status, post_modified, post_date
			FROM {$subquery}
			WHERE post_status IN ({$all_states}) $post_type_clause
			ORDER BY {$orderby} {$order}
			LIMIT %d,%d
		";

	return $query;
}