In this post i would like to list basic to advanced database queries using ZF2. I am gonna use TableGateway methods here. Simple Select Query
1 2 3 4 5 6 7 |
// use Zend\Db\TableGateway\TableGateway; // use Zend\Db\Sql\Select; $adapter = $this->getServiceLocator()->get('Zend\Db\Adapter\Adapter'); $projectTable = new TableGateway('users', $adapter); $rowset = $projectTable->select(); print_r($rowset->toArray()); exit; |
1 |
SELECT `users`.* FROM `users` |