Welcome Guest, Not a member yet? Register   Sign In
codeigniter 4 - common file <- database use
#3

PHP Code:
<?php namespace Config;

use 
CodeIgniter\Config\BaseConfig;
use 
Config\Database;

class 
Common extends BaseConfig
{
    
    
public function __construct ()
    {
        parent::__construct();
        $db Database::connect();
        #SET GENERAL SETTINGS BEGIN
        $genSetsArr = array();
        $genSets $db->query('SELECT * FROM setting WHERE `setting_type`=1 ')->getResult();
        if (!empty($genSets)) {
            foreach ($genSets as $genSet) {
                $genSetsArr[strtoupper($genSet->name)] = $genSet->value;
            }
        }
        $this->general $genSetsArr;
        #SET GENERAL SETTINGS ENDS
        $db->close();
    }


//and you can get these data in a view using 
config('Common')->general['LOGO'
Reply


Messages In This Thread
RE: codeigniter 4 - common file <- database use - by SubrataJ - 05-31-2022, 07:09 AM



Theme © iAndrew 2016 - Forum software by © MyBB