public function all() { $results = $this->db->select()->from('settings')->getAll(); $setting = array(); foreach ($results as $result) { $setting[$result->key] = $result->value; } return Resources\Tools::arrayToObject($setting); }
/** * Find a document * * @return mix */ public function getOne($collection = false, $criteria = array(), $fields = array()) { if ($collection) { $this->collectionName = $collection; } if (!empty($criteria)) { $this->criteria = $criteria; } if (!empty($fields)) { $this->documents = $fields; } $value = $this->collection($this->collectionName)->findOne($this->criteria, $this->documents); $this->criteria = $this->documents = array(); if (!empty($value)) { return Tools::arrayToObject($value); } return false; }
/** * Get single record. * * @param string $query The sql query * @param string $type return data type option. the default is "object" */ public function row($query = null, $returnType = false) { if ($returnType) { $this->returnType = $returnType; } if (is_null($query)) { $query = $this->command(); } if (is_null($this->link)) { $this->init(); } $result = $this->query($query); if (!($return = $result->fetchArray(SQLITE3_ASSOC))) { return false; } if ($this->returnType == 'object') { return Tools::arrayToObject($return, $this->instantiateClass, false); } return $return; }