| Server IP : 5.161.254.237 / Your IP : 216.73.216.30 Web Server : Apache System : Linux diamond.sialwebvps.com 4.18.0-553.8.1.el8_10.x86_64 #1 SMP Tue Jul 2 07:26:33 EDT 2024 x86_64 User : stellasp ( 1131) PHP Version : 7.4.33 Disable Function : exec,passthru,shell_exec,system MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /home/stellasp/www/application/models/ |
Upload File : |
<?php
Class Settings_model extends CI_Model
{
function __construct()
{
parent::__construct();
}
function get_settings($code)
{
$this->db->where('code', $code);
$result = $this->db->get('settings');
$return = array();
foreach($result->result() as $results)
{
$return[$results->setting_key] = $results->setting;
}
return $return;
}
/*
settings should be an array
array('setting_key'=>'setting')
$code is the item that is calling it
ex. any shipping settings have the code "shipping"
*/
function save_settings($code, $values)
{
//get the settings first, this way, we can know if we need to update or insert settings
//we're going to create an array of keys for the requested code
$settings = $this->get_settings($code);
//loop through the settings and add each one as a new row
foreach($values as $key=>$value)
{
//if the key currently exists, update the setting
if(array_key_exists($key, $settings))
{
$update = array('setting'=>$value);
$this->db->where('code', $code);
$this->db->where('setting_key',$key);
$this->db->update('settings', $update);
}
//if the key does not exist, add it
else
{
$insert = array('code'=>$code, 'setting_key'=>$key, 'setting'=>$value);
$this->db->insert('settings', $insert);
}
}
}
//delete any settings having to do with this particular code
function delete_settings($code)
{
$this->db->where('code', $code);
$this->db->delete('settings');
}
//this deletes a specific setting
function delete_setting($code, $setting_key)
{
$this->db->where('code', $code);
$this->db->where('setting_key', $setting_key);
$this->db->delete('settings');
}
}