运行时的CodeIgniter数据库连接

I'm still having troubles with manually connection to a database on runtime. I open a new question becuase didn't find the answer yet.

Here is the case,

I connect to the database with a connection user to validate a username and password that is entered with a form. Then with this new information, if the user is valid I have to connect to the database with this new username and password. Looks contain the following:

config/database.php

    $active_record = TRUE;
    $db['default']['hostname'] = 'host';
    $db['default']['username'] = 'username';
    $db['default']['password'] = 'pwd';
    $db['default']['database'] = 'dbname';
    $db['default']['dbdriver'] = 'oci8';
    $db['default']['dbprefix'] = '';
    $db['default']['pconnect'] = FALSE;
    $db['default']['db_debug'] = TRUE;
    $db['default']['cache_on'] = FALSE;
    $db['default']['cachedir'] = '';
    $db['default']['char_set'] = 'WE8ISO8859P1';
    $db['default']['dbcollat'] = '';
    $db['default']['swap_pre'] = '';
    $db['default']['autoinit'] = FALSE;
    $db['default']['stricton'] = FALSE;

Then in the login controller: controllers/login.php

public function __construct(){
    parent::__construct();
    $this->output->enable_profiler(TRUE);

    $this->CI =& get_instance();
    $this->db_con = $this->CI->load->database('default', FALSE, TRUE);

    $this->load->model('Login_model');
    session_start();

}

public function index(){                
    if (isset($_POST['ingresar'])){

        $d['data'] = $this->Login_model->Obtener_usuario($_POST['usuario']);

        $_SESSION['logueo'] = $d['data']->row();

        if (empty($_SESSION['logueo'])){
            $d['error'] = 2;
        }
        else{
            if (is_null($_SESSION['logueo']->USER_ORACLE)){
                $d['error'] = 1;
            }
            if (!is_null($_SESSION['logueo']->N_SECUENCIA)){
                cargar_var_sesion($_POST['usuario'], $_SESSION['logueo']->USER_ORACLE, $_SESSION['logueo']->N_SECUENCIA, $_SESSION['logueo']->C_USR_NOM_APE);

                $db['limited']['hostname'] = 'samehost';
                $db['limited']['username'] = $_POST['usuario'];
                $db['limited']['password'] = $_POST['clave'];
                $db['limited']['database'] = 'samedbname';
                $db['limited']['dbdriver'] = 'oci8';
                $db['limited']['dbprefix'] = '';
                $db['limited']['pconnect'] = FALSE;
                $db['limited']['db_debug'] = TRUE;
                $db['limited']['cache_on'] = FALSE;
                $db['limited']['cachedir'] = '';
                $db['limited']['char_set'] = 'WE8ISO8859P1';
                $db['limited']['dbcollat'] = '';
                $db['limited']['swap_pre'] = '';
                $db['limited']['autoinit'] = FALSE;
                $db['limited']['stricton'] = FALSE;

                $active_group = 'limited';

                $this->db = $this->CI->load->database('limited', FALSE, TRUE);                  
                redirect('inicio', 'location');
            }
            else{
                $d['error'] = 2;    
            }
        }           
    }
    else{
        $d['error'] = 0;    
    }

    $this->load->view('/componentes/header');
    $this->load->view('/componentes/menu_sin_login');
    $this->load->view('/login/login', $d);
    $this->load->view('/componentes/footer');       
}

Everything goes ok within this controller but when redirect is perform (that loads different models), e.g., tareas_model.php I keep on receiving the same error on the first lines:

models/tareas_model.php

function __construct()
{
    parent::__construct();
    $query = $this->db->query('ALTER SESSION SET nls_sort = \'SPANISH\'');
}

The error is:

A PHP Error was encountered
Severity: Notice
Message: Undefined property: Inicio::$db
Filename: core/Model.php
Line Number: 50
Fatal error: Call to a member function query() on a non-object in /var/www/crm/application/models/tareas_model.php on line 8

I also tried setting $this->db as a session variable but I keep receiving the same error and I'm driving pretty crazy. I've tried everything that I found online with no luck.

Any help?

写回答
好问题 0 提建议
追加酬金
关注问题
分享
邀请回答
编辑收藏删除结题
收藏举报

2条回答默认最新

doudou1309 2011-09-06 15:56

关注

Well, for those who have run under this problem I think I found the solution. I modified the files as follows:

config/database.php

$active_record = TRUE;
$db['default']['hostname'] = 'localhost';
$db['default']['username'] = '';
$db['default']['password'] = '';
$db['default']['database'] = '';
$db['default']['dbdriver'] = 'oci8';
$db['default']['dbprefix'] = '';
$db['default']['pconnect'] = FALSE;
$db['default']['db_debug'] = TRUE;
$db['default']['cache_on'] = FALSE;
$db['default']['cachedir'] = '';
$db['default']['char_set'] = 'WE8ISO8859P1';
$db['default']['dbcollat'] = '';
$db['default']['swap_pre'] = '';
$db['default']['autoinit'] = FALSE;
$db['default']['stricton'] = FALSE;

Then, the controller that first receives POST username and password as: controllers/login.php

public function __construct()
{
    parent::__construct();
    $this->output->enable_profiler(TRUE);
    session_start();

}

public function index()
{               
    if (isset($_POST['ingresar'])){

        if (!empty($_POST['usuario']) && !empty($_POST['clave'])){

            $c['hostname'] = "myhost";
            $c['username'] = strtoupper($_POST['usuario']);
            $c['password'] = $_POST['clave'];
            $c['database'] = "dbname";
            $c['dbdriver'] = "oci8";
            $c['dbprefix'] = "";
            $c['pconnect'] = TRUE;
            $c['db_debug'] = TRUE;
            $c['cache_on'] = FALSE;
            $c['cachedir'] = "";
            $c['char_set'] = "WE8ISO8859P1";
            $c['dbcollat'] = ""; 
            $active_record = TRUE;

            $_SESSION['c'] = $c;

            $this->db = $this->load->database($_SESSION['c'], TRUE, TRUE);
            $this->load->model('Login_model');

            $d['data'] = $this->Login_model->Obtener_usuario($_POST['usuario']);

            $_SESSION['logueo'] = $d['data']->row(); //print_r($_SESSION['logueo']);
            cargar_var_sesion($_SESSION['logueo']->C_USUARIO_WEB, $_SESSION['logueo']->USER_ORACLE, $_SESSION['logueo']->C_USR_NOM_APE, $this->db->conn_id, $_SESSION['c']);
            redirect('inicio', 'location');

        }
        else{
            $d['error'] = 1;

            $this->load->view('/componentes/header');
            $this->load->view('/componentes/menu_sin_login');
            $this->load->view('/login/login', $d);
            $this->load->view('/componentes/footer');
        }           
    }
    else{
        $d['error'] = 0;

        $this->load->view('/componentes/header');
        $this->load->view('/componentes/menu_sin_login');
        $this->load->view('/login/login', $d);
        $this->load->view('/componentes/footer');   
    }

}

Then, in the models: models/login_model.php

function __construct()
{
    parent::__construct();
    $CI =& get_instance();
}
function Obtener_usuario($usuario) 
{
    $CI =& get_instance();
    $query_logueo = $CI->db->query('SELECT....');
    return $query_logueo;
}

Then in every controller I reload the db like:

public function __construct()
{
    parent::__construct();
    $this->output->enable_profiler(TRUE);

    session_start();

    $this->db = $this->load->database($_SESSION['c'], TRUE, TRUE);
    $this->load->model('Any_model');
}

Minor where just a few in each controller and none in the models so, it was great!

Cheers, V

报告相同问题？

关注问题

CodeIgniter本地数据库连接问题 html php
2017-08-02 17:51

回答 3 已采纳 This error relates to the connection group, not the database name. The connection group you have s
CodeIgniter通过URL进行动态数据库连接 php
2016-09-16 15:02

回答 1 已采纳 Was missing this part : $CI =& get_instance(); and updated the define('COMP', $this -> uri
无法连接到本地CodeIgniter数据库 php
2014-03-04 12:30

回答 1 已采纳 Don't use this method. Go to your applications -> config -> database.php and enter in your d
轻松处理来自Excel文件的大数据
2018-01-19 12:30

dfsgwe1231的博客当您只需要数据时，为什么还要上传文件？更加清洁，更快，只需添加excel_uploader js即可避免连接超时，数据损坏 1.概述有时可靠地从excel文件批量上传数据可能是一件小事。这是通过简单的JavaScript库驯服野兽的...
如何使用Codeigniter连接sql server数据库？ php
2018-07-18 20:19

回答 1 已采纳 After lot of research, I found an alternate solution. I would like to share it, in future may be i
用mySQL处理datatables codeigniter中的大数据[关闭] css javascript mysql php
2017-03-03 15:51

回答 1 已采纳 Try using server side datatables. That way you wont have to fetch all 7.8k rows at once
使用codeigniter从数据库返回两行 php
2017-10-13 20:13

回答 2 已采纳 Your query is actually correct. However, you can use return $result->result_array(); to get an
5个好用的开源网络监控工具
2021-07-30 20:43

独行侠梦的博客来源：开源最前线（ID：OpenSourceTop）猿妹编译链接：https://opensource.com/article/19/2/network-monitoring-tools 维护网站正常运行是系统管理员最基本的任务之一，所以对系统进行监视，并保持网络的最佳运行...
如何在codeigniter中使用已连接数据库的数据库连接？ database php
2016-08-25 13:50

回答 4 已采纳 Ok. Seems you know about database.php. Will get know some more $db['default'] = array( 'dsn'
Codeigniter中的动态数据库 mysql php
2018-03-07 10:30

回答 1 已采纳 this is in the controller: $db_hostname = $databaseInfo['Hostname']; $db_username = $data
使用codeigniter在数据库中插入多行 css html php
2019-02-28 02:09

回答 2 已采纳 Since you've said you want to insert multiple rows, I assume that you want to do a batch-insert us
php和java对比
2023-11-14 07:00

三雷科技的博客 数据库连接： Java支持多种数据库，有很多流行的ORM（对象关系映射）工具，如Hibernate。总的来说，PHP和Java在设计目标、用途和性能方面存在差异，选择哪种语言取决于项目需求、团队技能和其他因素。PHP通常用于...
通过引用返回更改CodeIgniter数据库配置 database php
2015-09-11 15:59

回答 2 已采纳 I found a solution and now I had enough time to elaborate an answer. As I said,I needed change the
Github上排名前五的开源网络监控工具
2021-07-29 13:52

程序IT圈的博客来源：开源最前线（ID：OpenSourceTop）猿妹编译链接：https://opensource.com/article/19/2/network-monitoring-tools 维护网站正常运行是系统管理员最基本的任务之一，所以对系统进行监视，并保持网络的最佳运行...
网络监控工具开源_排名前5位的开源网络监控工具
2020-07-07 20:32

cumo3681的博客网络监控工具开源维持活动的网络是系统管理员最重要的任务之一，并且对连接的系统保持警惕对于保持网络的最佳状态至关重要。有许多不同的方法可以使标签保持在现代网络上。网络监视工具专门用于监视网络流量和...
Laravel入门
2020-06-11 09:24

cunjie3951的博客从菜鸟的错误开始，例如找不到分号试图建立自己的网站构建框架（不要这样做），当我学习面向对象的PHP时，我终于遇到了很棒的事情。几乎所有的CMS系统都使用它，包括Joomla ， Drupal和WordPress ，当然，像...
前端后端的区别（超详细版）
2019-07-23 16:58

水无垠ZZU的博客 Laravel，CakePHP，Express，CodeIgniter，Ruby on Rails，Pylon， ASP.NET 数据库 Local Storage, Core Data, SQLite, Cookies, Sessions MySQL，Casandra，Postgre SQL，MongoDB，Oracle，Sybase，SQL ...
GitChat·前端 | 从软件工程角度看大前端技术栈
2017-08-15 20:59

软件供应链安全的博客在上述动图中，当我们在搭建好的持续集成(CI)环境下使用 git push 提交代码后，CI 服务器将根据相关配置自动化执行代码规范和代码质量检查过程(这里是自动运行的是测试代码)，并输出相应的检查结果。其次，统一...
GitChat · 前端 | 从软件工程角度看大前端技术栈
2017-09-06 11:06

软件供应链安全的博客在上述动图中，当我们在搭建好的持续集成(CI)环境下使用 git push 提交代码后，CI 服务器将根据相关配置自动化执行代码规范和代码质量检查过程(这里是自动运行的是测试代码)，并输出相应的检查结果。其次，统一...
主流编程语言介绍
2023-09-03 15:09

Filotimo_的博客它是一种解释型语言，意味着代码在运行时逐行解释执行。它具有以下几个主要作用：动态网页开发：PHP是最常用的服务器端脚本语言之一，用于生成动态网页内容。通过嵌入在HTML代码中的PHP脚本，可以实现动态内容的...
没有解决我的问题, 去提问

悬赏问题

¥20 我要一个分身加定位两个功能的安卓app
¥15 基于FOC驱动器，如何实现卡丁车下坡无阻力的遛坡的效果
¥15 IAR程序莫名变量多重定义
¥15 (标签-UDP|关键词-client)
¥15 关于库卡officelite无法与虚拟机通讯的问题
¥15 目标检测项目无法读取视频
¥15 GEO datasets中基因芯片数据仅仅提供了normalized signal如何进行差异分析
¥100 求采集电商背景音乐的方法
¥15 数学建模竞赛求指导帮助
¥15 STM32控制MAX7219问题求解答

码龄粉丝数原力等级 --

运行时的CodeIgniter数据库连接

2条回答默认最新

码龄粉丝数原力等级 --

悬赏问题

运行时的CodeIgniter数据库连接

2条回答 默认 最新

悬赏问题

2条回答默认最新