wpdb::strip_invalid_text_for_column() │ public │ WP 4.2.0

Strips any invalid characters from the string for a given table and column.

Method of the class: wpdb{}

No Hooks.

Return

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

Usage

global $wpdb;
$wpdb->strip_invalid_text_for_column( $table, $column, $value );

$table(string) (required)

Table name.

$column(string) (required)

Column name.

$value(string) (required)

The text to check.

Changelog

wpdb::strip_invalid_text_for_column() wpdb::strip invalid text for column code ^{WP 6.5.2}

public function strip_invalid_text_for_column( $table, $column, $value ) {
	if ( ! is_string( $value ) ) {
		return $value;
	}

	$charset = $this->get_col_charset( $table, $column );
	if ( ! $charset ) {
		// Not a string column.
		return $value;
	} elseif ( is_wp_error( $charset ) ) {
		// Bail on real errors.
		return $charset;
	}

	$data = array(
		$column => array(
			'value'   => $value,
			'charset' => $charset,
			'length'  => $this->get_col_length( $table, $column ),
		),
	);

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

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