PDO fetchAll() returns empty array

Question

I'm executing a simple query, without bound parameters, using PDO. I have tested it directly against my database and it executes cleanly, returning the expected results. However, when I plug it in to my PDO object and call fetchAll(), it returns an empty array.

$query = 'SELECT count(*) as mycount FROM mytable';
$mysql = $connection->prepare($query);
$result = $mysql->fetchAll();

print_r($result);

Expected result:

array
(
    [mycount] => 8
)

Actual result:

array
(
)

Any ideas what might be causing this, or how to go about troubleshooting this?

Marc B · Accepted Answer · 2014-01-14 16:36:57Z

13

You've prepared, but haven't executed the statement. You need

$mysql->execute();

first

answered Jan 14, 2014 at 16:36

Marc B

362k44 gold badges433 silver badges508 bronze badges

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

1 Comment

deceze Over a year ago

Adding: If you don't need to bind parameters, use PDO::query instead of preparing a statement...

Digital Chris · Accepted Answer · 2014-01-14 16:40:48Z

4

First you need to:

$mysql->execute();

Then you can

$result = $mysql->fetchAll();

answered Jan 14, 2014 at 16:40

Digital Chris

6,1771 gold badge22 silver badges29 bronze badges

Collectives™ on Stack Overflow

PDO fetchAll() returns empty array

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related