Database Config

Category:Library::Database | Category:Library::Community

Introduction

Since CodeIgniter config class doesn't handles sql based configuration variables, i came up with this simple library.

<?php if(!defined('BASEPATH')) exit('No direct script access allowed');
class Site_Config
{
    private $CI;
    
    public function __construct()
    {
        $this->CI =& get_instance();
    $this->_table = 'settings';
    if(!$this->read()) $this->install();
    }

    public function __destruct()
    {
        unset($this->CI);
    }

    public function save($cfg)
    {
        foreach($cfg as $item => $value) {
            $this->CI->config->set_item($item, $value);
        }
        $config =& get_config();
    $this->CI->db->where('id', '1');
    $this->CI->db->update($this->_table, array('cfg' => addslashes(serialize($config))));
    return ($this->CI->db->affected_rows() != 0) ? TRUE : FALSE;
    }

    private function read()
    {
    $this->CI->db->select('cfg')->limit(1);
    $query = $this->CI->db->get($this->_table);
    if($query->num_rows() > 0) {
        $load = $query->row();
        $cfg = unserialize(stripslashes($load->cfg));
            foreach($cfg as $item => $value) $this->CI->config->set_item($item, $value);
        return TRUE;
    }
    return FALSE;
    }

    private function install()
    {
        $config =& get_config();
    $this->CI->db->insert($this->_table, array('id' =>1, 'cfg' => addslashes(serialize($config))));
    }
}
?>

This is the needed table schema.

CREATE TABLE IF NOT EXISTS `settings` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `cfg` text NOT NULL,
  KEY `id` (`id`)
);