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 API? API or known as Application Programming Interface is a intermediate software which allow 2 applications communicate each other. API makes it easier to develop a program by providing building blocks.  When developers create code, they don’t often start from scratch. Fundamental to developer productivity is how  API   make often repeated yet complex processes highly reusable with a little bit of code. The speed that  API   enable developers to build out apps is crucial to the current pace of application development. Developers are now much more productive than they were before since they had to write a lot of code from scratch. With an API they don’t have to reinvent the wheel every time they write a new program. Instead, they can focus on the unique proposition of their applications while outsourcing all of the commodity functionality to APIs. How API Works? API works like a waiter which he/she is the intermediate person between customer ...
Read more