wpdb::strip_invalid_text_from_query() protected WP 4.2.0
Strips any invalid characters from the query.
{} It's a 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
Since 4.2.0 | Introduced. |
Code of wpdb::strip_invalid_text_from_query() wpdb::strip invalid text from query WP 5.6
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'];
}