How to SELECT LIKE with wildcard % with prepared statements

Question

I have the following PHP code to run a MySQL query:

$stmt = $pdo->prepare('SELECT * FROM my_table WHERE first_row = :first_row AND second_row LIKE "%:second_row%"');
$stmt->execute(array(':first_row' => "foo", ':second_row' => "bar"));

PHP Fatal error: Uncaught PDOException: SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens in /home/kd37875/public_html/my_file.php:5

Why that?

score 1 · Accepted Answer · answered Nov 27 '20 at 12:13

1

Try this:

$stmt = $pdo->prepare('SELECT * 
                       FROM my_table 
                       WHERE first_row = :first_row AND 
                             second_row LIKE :second_row');
$stmt->execute([':first_row'  => 'foo', 
                ':second_row' => '%bar%']);

So the % are simply part of the string, as they have always been.

answered Nov 27 '20 at 12:13

KIKO Software

15,283
3
18
33

sir i have one question from where i learn mysqli, PDO, parameterized,prepared syntax style coding in php?? – KUMAR Nov 27 '20 at 13:01
@KUMAR Have a look at https://phpdelusions.net/mysqli and https://phpdelusions.net/pdo – KIKO Software Nov 27 '20 at 13:04
@KUMAR also look at W3schools it is a wonderful place to start .... – Yunfei Chen Nov 29 '20 at 02:03
@Yunfei Chen okay .. – KUMAR Nov 29 '20 at 02:04

How to SELECT LIKE with wildcard % with prepared statements

1 Answers1