web_setting_model.php 1019 B

1234567891011121314151617181920212223242526272829303132333435363738
  1. <?php
  2. class Web_Setting_model extends MY_Model
  3. {
  4. private $table_name = 'web_setting';
  5. public function insert($parm)
  6. {
  7. $this->db->insert($this->table_name, $parm);
  8. return $this->db->insert_id();
  9. }
  10. public function update($name, $parm)
  11. {
  12. $this->db->select('count(*) as count');
  13. $this->db->where('name', $name);
  14. $query = $this->db->get($this->table_name);
  15. $ret = $query->row_array();
  16. if ($ret['count']==0) {
  17. $this->insert($parm);
  18. } elseif ($ret['count']==1) {
  19. $this->db->where('name', $name);
  20. $this->db->update($this->table_name, $parm);
  21. return $this->db->affected_rows();
  22. }
  23. return false;
  24. }
  25. public function getValueByName($name)
  26. {
  27. $this->db->select('value');
  28. $this->db->where('name', $name);
  29. $query = $this->db->get($this->table_name);
  30. return $query->num_rows() > 0 ? $query->result_array() : false;
  31. }
  32. }