Codeigniter - multiple database connections

Question

I have to retrieve a MySQL database information from master database and then connect to that database  and fetch some records   I mean that holding one database I want to load another database   Is it possible with Codeigniter  Right now I m using following lines of code in my model   function connectDb  credential          config  hostname      credential  server         config  username      credential  username         config  password      credential  password         config  database      credential  database         config  dbdriver      mysql        config  dbprefix              config  pconnect     FALSE       config  db debug     TRUE       config  cache on     FALSE       config  cachedir              config  char set      utf8        config  dbcollat      utf8 general ci         DB2  this- gt load- gt database  config         DB2- gt db- gt select  first name last name         query    DB2- gt db- gt get  person        print r  query        its not working is there any other way

User · Answer

If you need to connect to more than one database simultaneously you can do so as follows    DB1    this- gt load- gt database  group one   TRUE    DB2    this- gt load- gt database  group two   TRUE     Note  Change the words    group one    and    group two    to the specific group names you are connecting to  or you can pass the connection values as indicated above    By setting the second parameter to TRUE  boolean  the function will return the database object   Visit https   www codeigniter com userguide3 database connecting html for further information

User · Answer

Use this    dsn1    mysql   user password localhost db1    this- gt db1    this- gt load- gt database  dsn1  true          dsn2    mysql   user password localhost db2    this- gt db2   this- gt load- gt database  dsn2  true          dsn3    mysql   user password localhost db3    this- gt db3   this- gt load- gt database  dsn3  true        Usage   this- gt db1 - gt insert  tablename    insert array    this- gt db2- gt insert  tablename    insert array    this- gt db3- gt insert  tablename    insert array

User · Answer

While looking at your code  the only thing I see wrong  is when you try to load the second database    DB2  this- gt load- gt database  config     When you want to retrieve the database object  you have to pass TRUE in the second argument   From the Codeigniter User Guide      By setting the second parameter to TRUE  boolean  the function will   return the database object    So  your code should instead be    DB2  this- gt load- gt database  config  TRUE     That will make it work

User · Answer

It works fine for me        This is default database      db  default     array       dsn      gt           hostname    gt   localhost        username    gt   root        password    gt           database    gt   mydatabase        dbdriver    gt   mysqli        dbprefix    gt           pconnect    gt  TRUE       db debug    gt   ENVIRONMENT      production         cache on    gt  FALSE       cachedir    gt           char set    gt   utf8        dbcollat    gt   utf8 general ci        swap pre    gt           encrypt    gt  FALSE       compress    gt  FALSE       stricton    gt  FALSE       failover    gt  array         save queries    gt  TRUE         Add another database at the bottom of database php file    db  second     array       dsn      gt           hostname    gt   localhost        username    gt   root        password    gt           database    gt   mysecond        dbdriver    gt   mysqli        dbprefix    gt           pconnect    gt  TRUE       db debug    gt   ENVIRONMENT      production         cache on    gt  FALSE       cachedir    gt           char set    gt   utf8        dbcollat    gt   utf8 general ci        swap pre    gt           encrypt    gt  FALSE       compress    gt  FALSE       stricton    gt  FALSE       failover    gt  array         save queries    gt  TRUE         In autoload php config file    autoload  libraries     array  database    email    session         The default database is worked fine by autoload the database library   but second database load and connect by using constructor in model and   controller       lt  php     class Seconddb model extends CI Model           function   construct                parent    construct                  load our second db and put in  db2              this- gt db2    this- gt load- gt database  second   TRUE                      public function getsecondUsers                 query    this- gt db2- gt get  members                return  query- gt result                        gt

User · Answer

You should provide the second database information in  application config database php    Normally  you would set the default database group  like so    db  default    hostname      localhost    db  default    username      root    db  default    password          db  default    database      database name    db  default    dbdriver      mysql    db  default    dbprefix          db  default    pconnect     TRUE   db  default    db debug     FALSE   db  default    cache on     FALSE   db  default    cachedir          db  default    char set      utf8    db  default    dbcollat      utf8 general ci    db  default    swap pre          db  default    autoinit     TRUE   db  default    stricton     FALSE    Notice that the login information and settings are provided in the array named  db  default     You can then add another database in a new array - let s call it  otherdb     db  otherdb    hostname      localhost    db  otherdb    username      root    db  otherdb    password          db  otherdb    database      other database name    db  otherdb    dbdriver      mysql    db  otherdb    dbprefix          db  otherdb    pconnect     TRUE   db  otherdb    db debug     FALSE   db  otherdb    cache on     FALSE   db  otherdb    cachedir          db  otherdb    char set      utf8    db  otherdb    dbcollat      utf8 general ci    db  otherdb    swap pre          db  otherdb    autoinit     TRUE   db  otherdb    stricton     FALSE    Now  to actually use the second database  you have to send the connection to another variabel that you can use in your model   function my model method        otherdb    this- gt load- gt database  otherdb   TRUE      the TRUE paramater tells CI that you d like to return the database object      query    otherdb- gt select  first name  last name  - gt get  person      var dump  query       That should do it  The documentation for connecting to multiple databases can be found here  http   codeigniter com user guide database connecting html

User · Answer

The best way is to use different database groups  If you want to keep using the master database as usual   this- db  just turn off persistent connexion configuration option to your secondary database s   Only master database should work with persistent connexion    Master database   db  default    hostname      localhost    db  default    username      root    db  default    password          db  default    database      database name    db  default    dbdriver      mysql    db  default    dbprefix          db  default    pconnect     TRUE   db  default    db debug     FALSE   db  default    cache on     FALSE   db  default    cachedir          db  default    char set      utf8    db  default    dbcollat      utf8 general ci    db  default    swap pre          db  default    autoinit     TRUE   db  default    stricton     FALSE    Secondary database  notice pconnect is set to false    db  otherdb    hostname      localhost    db  otherdb    username      root    db  otherdb    password          db  otherdb    database      other database name    db  otherdb    dbdriver      mysql    db  otherdb    dbprefix          db  otherdb    pconnect     FALSE   db  otherdb    db debug     FALSE   db  otherdb    cache on     FALSE   db  otherdb    cachedir          db  otherdb    char set      utf8    db  otherdb    dbcollat      utf8 general ci    db  otherdb    swap pre          db  otherdb    autoinit     TRUE   db  otherdb    stricton     FALSE    Then you can use secondary databases as database objects while using master database as usual       use master dataabse  users    this- gt db- gt get  users        connect to secondary database  otherdb    this- gt load- gt database  otherdb   TRUE    stuff    otherdb- gt get  struff     otherdb- gt insert batch  users    users- gt result array         keep using master database as usual  for example insert stuff from other database  this- gt db- gt insert batch  stuff    stuff- gt result array

[mysql] Codeigniter - multiple database connections

Examples related to mysql

Examples related to database

Examples related to codeigniter