Fetching only one row from MySQL using Zend DB framework

Question

I want to fetch only one row from a database because I only expect one. However, with fetchAll I always have to unwrap the array first before I can access the meat:

$result = self::$db->fetchAll($select);
$result = $result[0];

Is there a better solution?

Fawad Ghafoor · Accepted Answer · 2012-10-16 15:46:58Z

14

You can also use the fetchRow method, i.e.:

$result = self::$db->fetchRow($select);
// note that $result is a single object, not an array of objects

now you can access column name like this

  $myResult = $result->columnName;

See http://framework.zend.com/manual/1.11/en/zend.db.adapter.html#zend.db.adapter.select.fetchrow

edited Oct 16, 2012 at 15:46

Fawad Ghafoor

6,2377 gold badges43 silver badges54 bronze badges

answered Aug 23, 2011 at 12:55

dinopmi

2,67319 silver badges24 bronze badges

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

1 Comment

Lenar Hoyt Over a year ago

Well, thats even better. Thanks.

Chris Laplante · Accepted Answer · 2011-08-23 12:49:14Z

6

You can use the fetch method. Try this:

$result = self::$db->query($select)->fetch();

Reference: http://framework.zend.com/manual/en/zend.db.statement.html#zend.db.statement.fetching.fetch

answered Aug 23, 2011 at 12:49

Chris Laplante

29.7k18 gold badges110 silver badges137 bronze badges

2 Comments

Lenar Hoyt Over a year ago

Call to undefined method Zend_Db_Adapter_Pdo_Mysql::fetch()

Chris Laplante Over a year ago

Try it now. You have to call fetch on a query object, not a database adapter.

Collectives™ on Stack Overflow

Fetching only one row from MySQL using Zend DB framework

2 Answers 2

1 Comment

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related