예제 #1
0
 /**
  * @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());
예제 #3
0
 private function getColumns()
 {
     return $this->tableGateway->getColumns();
 }