Zend Framework - fetchAll returns fatal error when it has no rows returned?

Question

I know that when I try top use fetchAll and it returns a fatal error, the reason is because it has returned no records on the query. But my question is, how to treat it? How can I know if the query will not return any records, so i do not use toArray()?

For instance,

$table = new Application_Model_Proucts();
$products = $table->fetchAll()->toArray();

How can I do a verification of the query before I put the toArray method?

score 2 · Accepted Answer · answered May 03 '12 at 14:19

2

If there are no records returned from fetchAll() then you are passing nothing to toArray(), which is where the error is occurring.

Try wrapping the last but of your code in an if statement:

$products = $table->fetchAll();

if(count($products))
{
  $products = $products->toArray();
}

answered May 03 '12 at 14:19

Richard Parnaby-King

14,703
11
69
129

Thank you bro, totally worked, with fetchRow and fetchAll as well. – Fernando Ferrari May 04 '12 at 14:23

score 1 · Answer 2 · answered May 04 '12 at 03:24

1

wrap your query in a condition and/or throw a new exception when condition isn't met

answered May 04 '12 at 03:24

jsteinmann

4,502
3
17
21

Zend Framework - fetchAll returns fatal error when it has no rows returned?

2 Answers2