public function selectVar($tableName, $where, $order = null, $fieldName = null) { //select name from table where id = 1; //ambil isi field di row 1 col 1 $sql = new Sql($this->_storage->getAdapter()); $metadata = new \Zend\Db\Metadata\Metadata($this->_storage->getAdapter()); $field = $metadata->getColumns($tableName); $result = array(); $query = $sql->select()->from($tableName)->columns(array($field[0]->getName()))->where($where)->limit(1); if ($order) { $query->order($order); } if ($fieldName) { $query->columns(array($fieldName)); } $statement = $sql->prepareStatementForSqlObject($query); $response = $statement->execute(); foreach ($response as $key => $value) { $result[$key] = $value; } return $result[$key]; }