strip_invalid_text_for_column example

function sanitize_option( $option, $value ) {
    global $wpdb;

    $original_value = $value;
    $error          = null;

    switch ( $option ) {
        case 'admin_email':
        case 'new_admin_email':
            $value = $wpdb->strip_invalid_text_for_column( $wpdb->options, 'option_value', $value );
            if ( is_wp_error( $value ) ) {
                $error = $value->get_error_message();
            } else {
                $value = sanitize_email( $value );
                if ( ! is_email( $value ) ) {
                    $error = __( 'The email address entered did not appear to be a valid email address. Please enter a valid email address.' );
                }
            }
            break;

        case 'thumbnail_size_w':
        

if ( is_wp_error( $commentdata['comment_approved'] ) ) {
        return $commentdata['comment_approved'];
    }

    $comment_id = wp_insert_comment( $commentdata );

    if ( ! $comment_id ) {
        $fields = array( 'comment_author', 'comment_author_email', 'comment_author_url', 'comment_content' );

        foreach ( $fields as $field ) {
            if ( isset( $commentdata[ $field ] ) ) {
                $commentdata[ $field ] = $wpdb->strip_invalid_text_for_column( $wpdb->comments, $field, $commentdata[ $field ] );
            }
        }

        $commentdata = wp_filter_comment( $commentdata );

        $commentdata['comment_approved'] = wp_allow_comment( $commentdata, $wp_error );
        if ( is_wp_error( $commentdata['comment_approved'] ) ) {
            return $commentdata['comment_approved'];
        }

        $comment_id = wp_insert_comment( $commentdata );
        

update_post_meta( $post_id, '_edit_last', get_current_user_id() );

    $success = wp_update_post( $translated );

    // If the save failed, see if we can sanity check the main fields and try again.     if ( ! $success && is_callable( array( $wpdb, 'strip_invalid_text_for_column' ) ) ) {
        $fields = array( 'post_title', 'post_content', 'post_excerpt' );

        foreach ( $fields as $field ) {
            if ( isset( $translated[ $field ] ) ) {
                $translated[ $field ] = $wpdb->strip_invalid_text_for_column( $wpdb->posts, $field, $translated[ $field ] );
            }
        }

        wp_update_post( $translated );
    }

    // Now that we have an ID we can fix any attachment anchor hrefs.     _fix_attachment_links( $post_id );

    wp_set_post_lock( $post_id );