Simple Settings Model,, for mysql db conector
<?php
/*
$settings = get::model('settings'); /// settings are controler spific Unless set as argument
$settings->hello(10); /// Sets VALUE, Returns Value
$settings->hello() /// Returns Value
*/
class settingsModel extends model {
protected $_table = 'settings';
protected $_area;
public function __construct($area = null) {
if($area != null)
$this->_area = $area;
else
$this->_area = mvc::$controller;
}
public function __call($name, array $value = null) {
if($value == null){
return $this->_get($name);
}else{
return $this->_set($name,$value[0]);
}
}
protected function _set($key,$value){
$data = array('setting_area'=>$this->_area,'setting_key'=>$key,'setting_value'=>$value);
$args = array('table' => $this->_table,
'vals' => $this->db->cleanString($data));
$sql = $this->db->insertOrUpdateSql($args);
$ret = $this->db->query($sql);
if(!$ret){
$this->_init();
return $this->_set($key,$value);
}else
return true;
}
protected function _get($key){
$return = 'false';
$sql = 'select * from '.$this->_table.' where setting_area='
. $this->db->cleanString($this->_area)
. ' and setting_key=' . $this->db->cleanString($key);
$res = $this->db->query($sql);
if($res){
$row = $res->fetch_assoc();
if($row) $return = $row['setting_value'];
}else{
$this->_init();
$return = $this->_get($key);
}
return $return;
}
protected function _init(){
$cols = 'setting_area varchar(255) not null,
setting_key varchar(255) not null,
setting_value varchar(255) not null,';
$sql = 'create table '.$this->_table.' (' . $cols . ' primary key(setting_area, setting_key))';
$this->db->query($sql);
}
}