$array){ if(is_array($array)){ $input[$key] = $this->array_change_key_case_recursive($array, $case); } } return $input; } public function __construct(\Zend\Db\Adapter\Adapter $adapter, $config = array()) { parent::__construct($adapter, $config); /* get conn instance */ $this->_conn = $adapter->getDriver()->getConnection()->getResource(); //print_r($config); if (isset($config['tables'])) { $tables = $config['tables']; foreach ($tables as $key => $value) { if (array_key_exists($key, $this->_tables) && $value) { $this->_tables[$key] = $this->_($value); } } } } public function fetchAll(\Zend\Db\Sql\Select $select, $raw = true){ $statement = $this->_sql->prepareStatementForSqlObject($select); if ($result = $statement->execute()) { $resultset = new \Zend\Db\ResultSet\ResultSet(); $data = $resultset->initialize($result)->toArray(); return $data; } return false; } public function loadDataTest(){ $result = new Result(); try { $sql = " select * from user_data_header limit 10 "; $stmt = $this->_db->query($sql); $resdata = $stmt->execute(); $listdata = array(); while($resdata->next()){ $res = $resdata->current(); array_push($listdata,$res); } //print_r($paramGroup);die; if ($listdata) { $result->code = 0; $result->info = 'OK'; $result->data = $listdata; } else { $result->code = 1; $result->info = 'nok'; } }catch (\Zend\Db\Adapter\Exception\RuntimeException $ex) { $result->code = 3; $result->info = 'ERROR : ' . $ex->getMessage(); } catch (\Exception $ex) { $result->code = 4; $result->info = 'ERROR : ' . $ex->getMessage(); } return $result; } }