[eluser]Unknown[/eluser]
Hello all!!
First time in this forum!
I'm having troubles to connect to the DB. Here it 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
Code:
$active_record = TRUE;
$db['default']['hostname'] = 'oracle 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
Code:
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'] = 'same oracle host';
$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
Code:
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 and in the user's guide with no luck.
Any help would be much appreciatted!
V