/** * [findSegmentByTypeSegment description] * @param ServiceLocator $sm * @param int $typeSegment (ID du type de segment) * @return array (Array de Segment) */ public function findSegmentByTypeSegment($sm, $typeSegment) { $idType = (int) $typeSegment; $query = "SELECT id, intitule_segment \n FROM segment\n WHERE ref_type_segment = {$idType}"; $statement = $sm->get('Zend\\Db\\Adapter\\Adapter')->query($query); $results = $statement->execute(); if ($results->isQueryResult()) { $resultSet = new ResultSet(); $resultSet->initialize($results); return $resultSet->toArray(); } return array(); }
public function testOffsetSet() { $resultSet = new ResultSet(array('a' => array('_id' => 'a', 'field' => 'value1'), 'b' => array('_id' => 'b', 'field' => 'value2'), 'c' => array('_id' => 'c', 'field' => 'value3'))); $resultSet['d'] = array('_id' => 'd', 'field' => 'value4'); $this->assertEquals(array('a' => array('_id' => 'a', 'field' => 'value1'), 'b' => array('_id' => 'b', 'field' => 'value2'), 'c' => array('_id' => 'c', 'field' => 'value3'), 'd' => array('_id' => 'd', 'field' => 'value4')), $resultSet->toArray()); }