wpdb::strip_invalid_text_from_query() │ protected │ WP 4.2.0

Strips any invalid characters from the query.

Method of the class: wpdb{}

No Hooks.

Return

String|WP_Error. The converted query, or a WP_Error object if the conversion fails.

Usage

// protected - for code of main (parent) or child class
$result = $this->strip_invalid_text_from_query( $query );

$query(string) (required)

Query to convert.

Changelog

wpdb::strip_invalid_text_from_query() wpdb::strip invalid text from query code ^{WP 6.1.1}

protected function strip_invalid_text_from_query( $query ) {
	// We don't need to check the collation for queries that don't read data.
	$trimmed_query = ltrim( $query, "\r\n\t (" );
	if ( preg_match( '/^(?:SHOW|DESCRIBE|DESC|EXPLAIN|CREATE)\s/i', $trimmed_query ) ) {
		return $query;
	}

	$table = $this->get_table_from_query( $query );
	if ( $table ) {
		$charset = $this->get_table_charset( $table );
		if ( is_wp_error( $charset ) ) {
			return $charset;
		}

		// We can't reliably strip text from tables containing binary/blob columns.
		if ( 'binary' === $charset ) {
			return $query;
		}
	} else {
		$charset = $this->charset;
	}

	$data = array(
		'value'   => $query,
		'charset' => $charset,
		'ascii'   => false,
		'length'  => false,
	);

	$data = $this->strip_invalid_text( array( $data ) );
	if ( is_wp_error( $data ) ) {
		return $data;
	}

	return $data[0]['value'];
}