Welcome Guest, Not a member yet? Register   Sign In
Different Database
#3

[eluser]eiso[/eluser]
I added this in database.php:
Code:
$db['tdb']['hostname'] = "localhost";//localhost

$db['tdb']['username'] = "username";//root

$db['tdb']['password'] = "password";//empty

$db['tdb']['database'] = "databasename";

$db['tdb']['dbdriver'] = "mysql";

$db['tdb']['dbprefix'] = "";

$db['tdb']['pconnect'] = FALSE;

$db['tdb']['db_debug'] = FALSE;

$db['tdb']['cache_on'] = FALSE;

$db['tdb']['cachedir'] = "";

$db['tdb']['char_set'] = "utf8";

$db['tdb']['dbcollat'] = "utf8_general_ci";

This as my model:

Code:
<?php

class Tadmin_model extends Model{
    
    function Tadmin_model(){

        parent::Model();
            
        $tdb = $this->load->database('tdb', TRUE);            
    }
    
    function FInsert($usernames){
        
        $query = $tdb->query("SELECT * FROM following");
        
        return $query->row();
    }    
}

?>

And this is the start of my controller:
Code:
<?php

class Tadmin extends Controller{
    
    function Tradmin(){
        
        parent::Controller();
        
        $this->load->model('tadmin_model');

And I get this error:

A PHP Error was encountered

Severity: Notice

Message: Undefined variable: tdb

Filename: models/tadmin_model.php

Line Number: ...

Fatal error: Call to a member function query() on a non-object in /blablabla/tadmin_model.php on line ...


What am I doing wrong here?

Thank you,

Eiso

p.s. changed some some lines for security purposes


Messages In This Thread
Different Database - by El Forum - 11-22-2008, 04:42 PM
Different Database - by El Forum - 11-23-2008, 12:14 AM
Different Database - by El Forum - 11-23-2008, 05:33 AM
Different Database - by El Forum - 11-23-2008, 08:45 AM
Different Database - by El Forum - 11-23-2008, 08:58 AM
Different Database - by El Forum - 11-23-2008, 09:30 AM
Different Database - by El Forum - 11-23-2008, 10:04 AM
Different Database - by El Forum - 11-23-2008, 11:02 AM



Theme © iAndrew 2016 - Forum software by © MyBB