Zf2 Using Zend\Db\Sql\Select

Question

Need help using Zend\Db\Sql\Select. Can't figure out what I'm doing wrong, it outputs nothing and no errors displayed.

namespace Album\Model;
use Zend\Db\Adapter\Adapter,
    Zend\Db\Sql\Select;

class AlbumTable
{
    public function getAll()
    {
        $select = new Select('album'); 
        return $select->from();
    }
}

namespace Album\Controller;

class AlbumController extends AbstractActionController
{
    public function indexAction()
    {
        return new Viewmodel(array(
            'rows' => $this->albumTable->useSelect()
        ));
    }
}

// index.phtml
foreach ($this->rows as $row) { echo $row->artist . '<br />'; }

Thanks

You might want to turn on error reporting and display errors in your php configuration to help with resolving errors. For one you are calling an AlbumTable method from your controller which does not exist. It seems you have no Db adapter setup either. I highly recomend running through the getting started guide where all this is explained in great detail. — Aydin Hassan
– Aydin Hassan, Commented Mar 16, 2013 at 16:15
Where is this method $this->albumTable->useSelect() coming from? — Stoyan Dimov
– Stoyan Dimov, Commented Mar 17, 2013 at 11:02

Ori · Accepted Answer · 2013-03-21 03:10:57Z

1

Figured I didn't query the string I built.

Zend\Db\Sql\Sql; 

class AlbumTable
{
    public function getAll()
    {
        $sql = new Sql($this->adapter);
        $select = new Select('album');

        $selectString = $sql->getSqlStringForSqlObject($select);
        return $this->adapter->query($selectString, Adapter::QUERY_MODE_EXECUTE);
    }
}

answered Mar 21, 2013 at 3:10

Ori

1541 silver badge8 bronze badges

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

Collectives™ on Stack Overflow

Zf2 Using Zend\Db\Sql\Select

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