Strange string in console from wpdb query

Question

I use this code:

   $search = $this->wpdb->prepare("WHERE (name LIKE %s OR tag LIKE %s)", '%'. $this->wpdb->esc_like($word) .'%', '%'. $this->wpdb->esc_like($word) .'%');

and in console i get:

name LIKE '{4b9ad9b602bd32ff99324feebaa1883bb3a3e818f587b35198d4e48093375c78}night{4b9ad9b602bd32ff99324feebaa1883bb3a3e818f587b35198d4e48093375c78}' OR tag LIKE '{4b9ad9b602bd32ff99324feebaa1883bb3a3e818f587b35198d4e48093375c78}night{4b9ad9b602bd32ff99324feebaa1883bb3a3e818f587b35198d4e48093375c78}'

how i can remove this strange string?

Sally CJ · Accepted Answer · 2020-05-28 22:43:52Z

2

That is a placeholder escape string generated by wpdb::placeholder_escape() which is used by wpdb::add_placeholder_escape() and which is called by wpdb::prepare().

So it is safe to keep those escape strings, but there is a wpdb method for removing them: wpdb::remove_placeholder_escape():

// In your case, you'd use $this->wpdb in place of $wpdb.
$query = $wpdb->add_placeholder_escape( 'LIKE %night%' );
$query2 = $wpdb->remove_placeholder_escape( $query );
var_dump( $query, $query2 );

answered May 28, 2020 at 22:43

Sally CJ

40.5k2 gold badges29 silver badges50 bronze badges

Add a comment |

Stack Exchange Network

Strange string in console from wpdb query

1 Answer 1

Your Answer

Linked

Hot Network Questions

Strange string in console from wpdb query

1 Answer 1

Your Answer

Sign up or log in

Post as a guest

Linked

Related

Hot Network Questions