wpdb::strip_invalid_text_from_query( string $query ): string|WP_Error

In this article

Strips any invalid characters from the query.

Parameters

$querystringrequired
Query to convert.

Return

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

Source

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']; } 

Changelog

VersionDescription
4.2.0Introduced.

User Contributed Notes

You must log in before being able to contribute a note or feedback.