Define constants from mysql database in PHP Codeigniter config file

Question

Hi I am trying to defining constants from mysql database, but could not load the database in codeigniter config file.

$db =$CI->load->database();
$query = $db->get('constants');
foreach( $query->result() as $row ){ define($row->title, $row->value); }

But it is throwing me an error "Undefined variable: CI"

I don't think so that we can do DB operation in config file ? — Naga
– Naga, Commented Sep 15, 2017 at 1:44

Pang · Accepted Answer · 2018-06-11 03:02:07Z

1

At the bottom of the config/config.php, paste the following code.

require_once( BASEPATH .'database/DB.php');
$db =& DB();

$query = $db->get('constants');

$result = $query->result();

foreach( $result as $row)
{
    $config[$row->title] = $row->value;
}

On Controller Test

echo $this->config->item('something');

edited Jun 11, 2018 at 3:02

Pang

10.2k146 gold badges87 silver badges126 bronze badges

answered Sep 15, 2017 at 1:56

user4419336

Sign up to request clarification or add additional context in comments.

1 Comment

Brian Gottier Over a year ago

I upvoted for a creative answer, but this is obviously a bandage for what I suspect is a broken app architecture. You have to be honest, this has Kludge written all over it. Even though CodeIgniter provides all kinds of ways to do things right, there's this ...

Brian Gottier · Accepted Answer · 2017-09-15 01:57:30Z

0

To use the CI super object in a config file, you must use:

$CI =& get_instance();

answered Sep 15, 2017 at 1:57

Brian Gottier

4,6003 gold badges24 silver badges39 bronze badges

2 Comments

Aakash Patel Over a year ago

Not working, throwing an error Fatal error: Uncaught Error: Class 'CI_Controller' not found in C:\xampp\htdocs\xampp\CodeIgniter\system\core\CodeIgniter.php

Brian Gottier Over a year ago

This is the only way to obtain the CI super object in a config file or library. Are you loading the config file with $this->config->load() ??

Collectives™ on Stack Overflow

Define constants from mysql database in PHP Codeigniter config file

2 Answers 2

1 Comment

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related