CodeIgniter Forums
codeigniter 4 - common file <- database use - Printable Version

+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: CodeIgniter 4 (https://forum.codeigniter.com/forumdisplay.php?fid=28)
+--- Forum: CodeIgniter 4 Support (https://forum.codeigniter.com/forumdisplay.php?fid=30)
+--- Thread: codeigniter 4 - common file <- database use (/showthread.php?tid=81954)



codeigniter 4 - common file <- database use - mefisteoo - 05-26-2022

Hi Smile
How can I use a database in a common file?
Common file (path: app/Config/Common.php)

I would like to get from the database saved page settings, i.e. page logo, language, menu...


Sebastian Smile


RE: codeigniter 4 - common file <- database use - datamweb - 05-28-2022

Hello, can I please read this before any action.


RE: codeigniter 4 - common file <- database use - SubrataJ - 05-31-2022

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'