Save Codeigniter config data in MySql database

I am looking for a more elegant way to save Codeigniter config data in a MySql database.

This is my Way:

./application/hooks/load_config.php

PHP Code:

function load_config() {
    $CI =& get_instance();
    foreach($CI->siteconfig->get_config()->result() as $site_config) {
        $CI->config->set_item($site_config->key, $site_config->value);
    }
} 


./application/config/hooks.php

PHP Code:

$hook['post_controller_constructor'] = array(
            'class'    => '',
            'function' => 'load_config',
            'filename' => 'my_config.php',
            'filepath' => 'hooks'
        ); 


./application/config/config.php

PHP Code:

$config['enable_hooks'] = TRUE; 


./application/models/Siteconfig.php

PHP Code:

public function get_config() {
    return $this->db->get('config')->resulr_array();
}

public function set_config($key, $value) {
    $config_data = array('key' => $key, 'value' => serialize($value));
    return $this->db->update('config', $config_data); 
} 


The config-items are normaly stored in an config-array like this:

PHP Code:

$config["default"] = array('key' => 'value'); 


If I call get_config(), I get an array with another strukture:

PHP Code:

Array
(
   [0] => Array(
                 [key]   => ...,
                 [value] => ...
               )
) 


I am correcting this by using a foreach-loop:

PHP Code:

$result = $this->siteconfig->get_config();
   foreach($result as $item => $value){
    $this->config_vars[$value['key']] = $value['value'];
} 


Is there a more elegant, performant way?

Thanks
Tom

Why not just encode and decode it using json then save it to the database in a text field.

What did you Try? What did you Get? What did you Expect?

Joined CodeIgniter Community 2009.  ( Skype: insitfx )

I would drop the whole "hook" business and move it all to the model which would be autoloaded.

PHP Code:

class Siteconfig_m extends CI_Model
{
    public function __construct()
    {
        parent::__construct();
        $this->get_config();
    }

    /**
     * Get the database items and add them to the super object $config item
     */
    public function get_config()
    {
        //using select() because it's lighter weight than get()
        //using result() because $config_items->item is less typing than $config_items['item'] 
        //and is usually easier to read. (Yes, it's a matter of opinion.)
        $config_items = $this->db->query('select * from config')->result();  
        foreach($config_items as $item)
        {
            //write directly to the "super object" $config array
            $this->config->config[$item->key] = unserialize($item->value); 
         }
    }

    public function set_config($key, $value)
    {
        $config_data = array('key' => $key, 'value' => serialize($value));
        return $this->db->update('config', $config_data);
    }
} 


I droped the whole "hook" business and move it to the sideconfig model which is autoloaded. Now I set the whole config in the constructor of the MY_Controller. Unfortunately, the hook "post_controller_constructor" was too late and the hook "post_controller" was too early. But now I found a solution.

I serialize/unserialize the data-array and save it as text in the Database.

Thanks for your help
Tom