1234567891011121314151617181920212223242526272829303132333435363738 |
- <?php
- class Web_Setting_model extends MY_Model
- {
-
- private $table_name = 'web_setting';
-
- public function insert($parm)
- {
- $this->db->insert($this->table_name, $parm);
- return $this->db->insert_id();
- }
-
- public function update($name, $parm)
- {
- $this->db->select('count(*) as count');
- $this->db->where('name', $name);
- $query = $this->db->get($this->table_name);
- $ret = $query->row_array();
- if ($ret['count']==0) {
- $this->insert($parm);
- } elseif ($ret['count']==1) {
- $this->db->where('name', $name);
- $this->db->update($this->table_name, $parm);
- return $this->db->affected_rows();
- }
- return false;
- }
- public function getValueByName($name)
- {
- $this->db->select('value');
- $this->db->where('name', $name);
- $query = $this->db->get($this->table_name);
- return $query->num_rows() > 0 ? $query->result_array() : false;
- }
- }
|