How to load 2 databases in one single coding using Codeigniter?

-

  1. Go to application/config/database.php .
  2. Create another database config like default database.


//Default database configuration$db['default'] = array(
    'dsn'       => '',
    'hostname' => 'localhost',
    'username' => 'db_username',
    'password' => 'db_password',
    'database' => 'db_name',
    'dbdriver' => 'mysqli',
    'dbprefix' => '',
    'pconnect' => FALSE,
    'db_debug' => (ENVIRONMENT !== 'production'),
    'cache_on' => FALSE,
    'cachedir' => '',
    'char_set' => 'utf8',
    'dbcollat' => 'utf8_general_ci',
    'swap_pre' => '',
    'encrypt'  => FALSE,
    'compress' => FALSE,
    'stricton' => FALSE,
    'failover' => array(),
    'save_queries' => TRUE);
//Another database configuration$db['another_db'] = array(
    'dsn'       => '',
    'hostname' => 'localhost',
    'username' => 'db_username',
    'password' => 'db_password',
    'database' => 'db_name2',
    'dbdriver' => 'mysqli',
    'dbprefix' => '',
    'pconnect' => FALSE,
    'db_debug' => (ENVIRONMENT !== 'production'),
    'cache_on' => FALSE,
    'cachedir' => '',
    'char_set' => 'utf8',
    'dbcollat' => 'utf8_general_ci',
    'swap_pre' => '',
    'encrypt'  => FALSE,
    'compress' => FALSE,
    'stricton' => FALSE,
    'failover' => array(),
    'save_queries' => TRUE);


   3. Now, u can load your second database.

//Load another database$DB2 = $this->load->database('another_db', TRUE);
   4. After that, you can use your database like usual.

//Default database query$this->db->select('first_name, last_name');$this->db->from('users');$this->db->where('id', 99);$query = $this->db->get();

//Another database query$DB2->select('image');$DB2->from('cdn_images');$DB2->where('id', 25);$query = $DB2->get();
















































Comments

Post a Comment

Popular posts from this blog

What is getnada?

-
Getnada is a services that can give u temporary email address. Usually, people will use this service to register into untrusted website or for testing purpose when we do some testing process. There are simple ways to create this temporary email : 1) Firstly, just go to www.getnada.com 2) Go to "add inbox" button 3) Create your temporary email such as "johndoe@getnada.com". You can put any name for your temporary email. You can test this temporary email by send a real email. This temporary email will only save your message only 7 days.
Read more

What is Dummy Text?

-
Image
Definition Dummy text is a text that used in publishing industry or web designer industry which is as a sample text and it will be replace by the real text. Example of dummy text  - Lorem Ipsum is the most common used dummy text. It  has been the industry's standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum. 
Read more