Codeigniter: Constants in /application/config/constant.php from DB table

Question

is it possible to declare constants in /application/config/constant.php from a DB table?

I'm trying to do something like this.

$result = $this->db->select( 'attr, value' )->from( 'app_conf')->where( 'city', 53 )->or_where( 'city', -1 )->order_by( 'city' )->get();
$app_conf = $result->result_array();
// var_dump( $app_conf );
foreach( $app_conf as $row )
{
    define( "_{$row['attr']}", $row['value'] );
}

but right now I have to do it in every controller I create, so duplicating code and requiring to do changes all over if needed, which seems unnecessary!

Nish · Accepted Answer · 2012-07-12 07:18:23Z

5

Extend the CI Controller and place it in the application/core directory as MY_Controller. In the extended controller's constructor place the above code. Now you can extend it from your controllers to execute the same code. So you are not required to write this code again and again.

answered Jul 12, 2012 at 7:18

Nish

2,3442 gold badges14 silver badges19 bronze badges

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

Comments

The Alpha · Accepted Answer · 2012-07-12 07:35:36Z

Make a new controller by extending the CI_Controller and use this controller as your main controller (use it to create new controllers instead of CI_Controller)

<?php 
class MY_Controller extends CI_Controller{
    function __construct()
    {
        parent::__construct();
        // Assuming that you have loaded all required library in autoload
        $result = $this->db->select( 'attr, value' )->from( 'app_conf')->where( 'city', 53 )->or_where( 'city', -1 )->order_by( 'city' )->get();
        $app_conf = $result->result_array();
        foreach( $app_conf as $row )
        {
            define( "_{$row['attr']}", $row['value'] );
        }
    }
}

create a new controller (a normal controller from MY_Controller instead of CI_Controller)

class Somecontroller extends MY_Controller {
    function __construct()
    {
        parent::__construct();
        // ...
    } 

    // other functions/mechods
 }

Robin Castlin · Accepted Answer · 2012-07-12 07:18:07Z

2

Either use hooks or MY_Controller to solves this matter. Or if you're lazy, you can autoload a helper which does this for you.

Then it will be defined in every call.

answered Jul 12, 2012 at 7:18

Robin Castlin

11k1 gold badge30 silver badges44 bronze badges

Collectives™ on Stack Overflow

Codeigniter: Constants in /application/config/constant.php from DB table

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related