In php my mysql select query doesn't work

Question

I created code for select query for MySQL in PHP.

The code:

$vericek4 = $baglanti2 -> prepare ("select no from urunlist where urunad like '%?%'");
$vericek4 -> bindParam(1, $aramayss);
$vericek4 -> execute();

$satirsay2 = $vericek4 -> rowCount();

I have data in $aramayss. But $satirsay2 is null.

Never quote your parameters! It will never do what you think it should. — aynber, Dec 26 '17 at 15:37

score 2 · Accepted Answer · answered Dec 26 '17 at 15:24

2

It "works". It just doesn't do what you expect. The ? is in a string, so it is not substituted with the parameter value.

You can construct the like pattern using concat():

select no from urunlist where urunad like concat('%', ?, '%')

Alternatively, add the wildcards in PHP, and just use:

select no from urunlist where urunad like ?

answered Dec 26 '17 at 15:24

Gordon Linoff

1,198,228
53
572
709

İ did it like you said but the code doesn't work – Thiers Dec 26 '17 at 15:34
1

What does „the code doesn't work“ mean? – Nico Haase Dec 26 '17 at 18:16

In php my mysql select query doesn't work

1 Answers1