PHP select::where 예제들

 public function getUtilisateurByID($clientid)
 {
     $select = new select();
     $select->from('user');
     $select->where(array('user_id' => $clientid));
     $rowset = $this->tableGateway->selectwith($select);
     $rowset->buffer();
     return $rowset;
 }

예제 #2

파일 보기

파일: MeasureTable.php 프로젝트: kalelc/inventory

 public function getBySpecification($specification)
 {
     $select = new select();
     $select->from('measures');
     $select->join('measures_types', 'measures_types.id = measures.measure_type', array('mt_name' => 'name'), $select::JOIN_LEFT);
     $select->join('specifications', 'specifications.id = measures.specification', array('s_name' => 'name'));
     $select->where(array($this->tableGateway->getTable() . '.specification' => $specification));
     $resultSet = $this->tableGateway->selectWith($select);
     return $resultSet ? $resultSet : false;
 }