Zend DB select from a different database
Using Zend DB to select data from or use a table that doesn't belong to the adapter selected database, can be done by using TableIdentifier
instead of a string as it shows below:
<?php use Zend\Db\Sql\Sql; use Zend\Db\Sql\TableIdentifier; $sql = new Sql($adapter); $select = $sql->select(); $select->from(new TableIdentifier('table', 'database')); $select->where(array('id' => 1)); $statement = $sql->prepareStatementForSqlObject($select); $results = $statement->execute();