/** * @desc Metoda zwraca liste rekordów z kolumna id i nazwa dla tabeli podanej w parametrze. Jeżeli jest pole status to zwraca tylko te z status=1 * @param $sTabelaSlownikowa * @param $aIds array * @param $intBaza nazwa bazy do ktorej ma się odnosic lista * @return array */ public static function ListaIn($nazwaSlownika, $aIds = array(), $aCols = array()) { $projectTable = new TableGateway($nazwaSlownika, \Zend\Db\TableGateway\Feature\GlobalAdapterFeature::getStaticAdapter()); $projectTable->getColumns(); $select = new \Zend\Db\Sql\Select(); if (!empty($aCols)) { $select->columns($aCols); } $select->from($nazwaSlownika); $select->in(implode(',', $aIds)); $rowset = $projectTable->selectWith($select); if ($rowset) { return $rowset; } return array(); }
<?php /** @var $adapter Zend\Db\Adapter\Adapter */ $adapter = (include file_exists('bootstrap.php') ? 'bootstrap.php' : 'bootstrap.dist.php'); refresh_data($adapter); use Zend\Db\TableGateway\TableGateway, Zend\Db\TableGateway\Feature\FeatureSet, Zend\Db\TableGateway\Feature\MetadataFeature; $artistTable = new TableGateway('artist', $adapter, new MetadataFeature()); var_dump($artistTable->getColumns());
private function getColumns() { return $this->tableGateway->getColumns(); }