PHP PDO doesn't return any result

Question

I'm currently having a bit of a problem I can't figure out and I guess I'm missing something.
This is the code that doesn't work (for some reason):

$search = "my search keyword";
$findTopics = $db->prepare('SELECT * FROM topics LEFT JOIN forum ON forum.f_id = topics.f_id WHERE topics.keywords LIKE "%:keyword%"');
$findTopics->bindValue(':keyword', $search);
$findTopics->execute();
var_dump($findTopics->fetchAll(PDO::FETCH_ASSOC));

The result when executing the above code is an empty array array(0) { }.
If you change :keyword to my search keyword and remove $findTopics->bindValue(..) it returns results. Also the query works fine if you execute it directly in mysql via a console.

What am I missing here?

Ross Smith II · Accepted Answer · 2012-08-26 17:31:08Z

4

Change the first two lines to:

$search = "%my search keyword%";
$findTopics = $db->prepare('SELECT * FROM topics LEFT JOIN forum ON forum.f_id = topics.f_id WHERE topics.keywords LIKE :keyword');

and it should work fine.

PDO will add the quotes around the parameters for you.

answered Aug 26, 2012 at 17:31

Ross Smith II

12.2k1 gold badge41 silver badges46 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

tftd Over a year ago

Damn it.. I feel really stupid. Thanks. (I'll mark your answer in a couple of minutes)

Collectives™ on Stack Overflow

PHP PDO doesn't return any result

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related