ZF2 Executing DB query from Controller

Question

Hi i am new to ZF2 and not familiar with some of the changes in ZF2. I would like to know how can i execute SQL query directly from Controller.

I have the following code:

 public function indexAction()
 {
    $db = $this->getServiceLocator()->get('Zend\Db\Adapter\Adapter');
    $sql = "SELECT * FROM books";
    $statement = $db->query($sql);
    $res =  $statement->execute();

    if($res instanceof ResultInterface && $res->isQueryResult()){
        $resultSet = new ResultSet;
        $resultSet->initialize($res);

        foreach($resultSet as $row){
            echo $row->title . PHP_EOL;
        }
    }
    exit;

    /*
    return new ViewModel(array(
        'books' => $this->getBooksTable()->fetchAll(),
    ));
    */
 }

When the controller above is opened in web browser, it does not show anything. If i echo "Blahh.." before the if statement, it displays the "Blahh.." text correctly.

Does anyone know why it does not display the query result properly? Thx.

AbderrahimDz24 · Accepted Answer · 2013-12-03 19:34:05Z

1

try to add this in the top of your controller :

use Zend\Db\Adapter\Driver\ResultInterface;
use Zend\Db\ResultSet\ResultSet;

answered Dec 3, 2013 at 19:34

AbderrahimDz24

3664 silver badges14 bronze badges

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

Collectives™ on Stack Overflow

ZF2 Executing DB query from Controller

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