Example #1
0
 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);
 }
Example #2
0
 /**
  * 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;
 }
Example #3
0
 /**
  * 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;
 }