How to fetch data from MySQL

Question

I am executing query like this in zend:

$front = Zend_Controller_Front::getInstance();
$bootstrap = $front->getParam('bootstrap');
$resource = $bootstrap->getPluginResource('db');
$dbAdapter = $resource->getDbAdapter();
$statement = $dbAdapter->query("SELECT * from test");

Now $statement have Zend_Db_Statement_Mysqli Object with fetched records in it but I don't know how to get column values from Zend_Db_Statement_Mysqli. toArray() is not working on $statement.

Thanks

@Z0q: Yes, Both fetchAll() and fetchAssoc() are working. Thanks — Awan
– Awan, Commented Feb 18, 2011 at 10:00

Marcin · Accepted Answer · 2011-02-18 09:55:52Z

3

To actually obtain any results from your $statement you should do this:

$results = $statement->fetchAll();

answered Feb 18, 2011 at 9:55

Marcin

241k16 gold badges315 silver badges368 bronze badges

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

Collectives™ on Stack Overflow

How to fetch data from MySQL

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related