Codeigniter – Save config data in database

To achieve this you are going to use CodeIgniter hooks. To initialize the hooks class one must have to enable it as shown below –

Goto – application/config/config.php

1	$config['enable_hooks'] = TRUE;

Steps to Save Codeigniter config data in database

There are several hook points available in CodeIgniter. As for current requirement you need use “post_controller_constructor” hook point. let’s open application/config/hooks.php file and add following code. as you enabled hooks with above config option, hooks.php file will be auto-loaded by CI.

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17

$hook['post_controller_constructor'] = function() {     $CI =& get_instance();     $appConfigOptions = $CI->AppConfigModel->get_configurations();     if($appConfigOptions) {                  foreach($appConfigOptions as $appConfigOption)         {             $CI->config->set_item($appConfigOption->key,$appConfigOption->value);         }     } };

Code Explained

post_controller_constructor – Called immediately after your controller is instantiated, but prior to any method calls happening.

$CI = &get_instance(); – This will return “reference of the CI superobject”.

$CI->AppConfigModel->get_configurations() – From the CI superobject, accessing auto-loaded modal “AppConfigModel” and reading get_configurations() method. This method will read database and return all the available config data.

After that, iterating over the data and by using CI superobject accessing set_item() method via config object and setting key and value of the config data.

DOWNLOAD

Here is the auto loaded Config options – For application/config/autoload.php file

1 2	$autoload['libraries'] = array('database'); $autoload['model'] = array('AppConfigModel');

Here is the table schema –

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18

-- -- Table structure for table `app_config_options` -- CREATE TABLE IF NOT EXISTS `app_config_options` (   `key` varchar(255) NOT NULL,   `value` varchar(255) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `app_config_options` -- INSERT INTO `app_config_options` (`key`, `value`) VALUES ('site_description', 'Web developments by arjunphp.com'), ('site_name', 'arjunphp.com'); ALTER TABLE `app_config_options`   ADD PRIMARY KEY (`key`);

Here is AppConfigModel Model – application/models/AppConfigModel.php

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16

<?php class AppConfigModel extends CI_Model {         protected $table;         public function __construct()         {                 $this->table = 'app_config_options';         }         public function get_configurations()         {             $query = $this->db->get($this->table);             return $query->result();         } }

That is it, now you can access config data from anywhere in the system by using this script config->item('sitename'); ?>.

I hope you like this Post, Please feel free to comment below, your suggestion and problems if you face - we are here to solve your problems.