php - Error Using Multiple Database In CodeIgniter -

-

I am trying to implement multiple databases in CI. My code is here: 

 < Code> // database.php $ active_group = "default"; $ Active_record = TRUE; $ Db ['default'] ['hostname'] = "localhost"; $ Db ['default'] ['username'] = "original"; $ Db ['default'] ['password'] = "root"; $ Db ['default'] ['database'] = "revx"; $ Db ['default'] ['dbdriver'] = "MySQL"; $ Db ['default'] ['dbipfix'] = "rvx_"; $ Db ['default'] ['pconnect'] = true; $ Db ['default'] ['db_debug'] = true; $ Db ['default'] ['cache_on'] = falls; $ Db ['default'] ['cachered'] = ""; $ Db ['default'] ['char_set'] = "UTF8"; $ Db ['default'] ['dccillet'] = "utf 8_ggri_c"; $ Db ['smf'] ['hostname'] = "localhost"; $ Db ['smf'] ['username'] = "root"; $ Db ['smf'] ['password'] = "root"; $ Db ['smf'] ['database'] = "smf"; $ Db ['smf'] ['dbdr'] = "myself"; $ Db ['smf'] ['dbprefix'] = "smf_"; $ Db ['smf'] ['pconnect'] = true; $ Db ['smf'] ['db_debug'] = true; $ Db ['smf'] ['cache_on'] = false; $ Db ['smf'] ['cachered'] = ""; $ Db ['smf'] ['char_set'] = "UTF8"; $ DB ['SMF'] ['DBCOL'] = "UTF 8GGRL_C";

is the model 

  // user_model.php class user_model model {private $ ravelex_db; Function user_model () {origin: model (); $ This- & gt; Ravelex_db = $ this- & gt; Load-> Database ('default', TRUE); } Find_all function (print_r ($ this-> ravelex_db); $ Q = $ this- & gt; Ravelex_db-> Receive ('user'); Return $ q- & gt; result (); }} //smf_user_model.php class smf_user_model model {private $ smf_db; Function smf_user_model () {origin: model (); $ This- & gt; Smf_db = $ this- & gt; Load-> Database ('smf', TRUE); } Find_all () {$ q = $ this-> Smf_db-> Receive ('member'); Return $ q- & gt; result (); }}

Controller tester 

  expand the class mutipledb controller {function mutipledb () {parent :: controller); $ This- & gt; Load-> Database (); $ This- & gt; Load-> Model ('user_model'); $ This- & gt; Load-> Model ('smf_user_model'); } Function index () {print_r ($ this-> user_model- & gt; find_all ()); Print_r ($ this-> smf_user_model- & gt; find_all ()); }}

There is some error, the first database uses another database name but it still uses its prefix.

Error 

  A database error occurred. Error number: 1146 The table 'smf.rvx_users' does not exist SELECT * FROM (`Rvx_users`)

If I just load a model ..., it works square extension of the mutipledb controller [mutipledb () {parent: :: controller); $ This- & gt; Load-> Database (); // $ this- & gt; Load-> Model ('user_model'); $ This- & gt; Load-> Model ('smf_user_model'); } Function index () {// print_r ($ this-> user_model- & gt; Find_all ()); Print_r ($ this-> smf_user_model- & gt; find_all ()); }}

Why can this happen? Please help me

I have got the solution.

Set the connection to FALSE for either database configuration or database configuration. 

  $ db ['default'] ['pconnect'] = FALSE; $ Db ['smf'] ['pconnect'] = Wrong;

or

$ db ['default'] ['pconnect'] = TRUE; $ Db ['smf'] ['pconnect'] = Wrong; // and vice versa

Comments

Post a Comment

Popular posts from this blog

oracle - The fastest way to check if some records in a database table? -

-
I have a big table to work with. I have to see that there are some records whose parent_id is equal to my passing value. Currently I do this by implementing "my_table using select count (*) where parent_id =: id"; If the result> 0, it means that they exist. Because this is a very large table, and I do not care what the actual number of records present, I just want to know if it exists, so I think count (*) Bit is disabled. How do I apply this requirement most quickly? I'm using Oracle 10. # Tips for Hibernation & amp; Tricks It suggests writing in such a way: Integer number = (integer) session .createQuery ("Select Count (*) to ...."). UniqueResult (); I do not know what is the magic of the unique rule? Why does it fast? To compare, select "1 from mytable where parent_id = passId and rowrum", which is more efficient? If you are not interested in the number of records, then there is an EXISTS query one: Select 'y'
Read more

php - multilevel menu with multilevel array -

-
Just ask someone to solve this problem? I want to create a multilevel menu I can not find the right solution generated with multilevel array, it always gets an array_push error My study came from the original idea But still my Can not match the need. This is my MySQL [code] ----- --------------------- --------------- | ID | PARENT_ID | Name | Link | Seq | 1 | 0 | Dashboad | Dashboard / | 1 | 2 | 0 | Menu 1 | Menu 1 / | 2 | 3 | 0 | Menu 2 | Menu 2 / | 3 | 4 | 0 | Menu 3 | Menu 3 / | 4 | 5 | 2 | Joint Add / | 1 | 6 | 3 | Joint Add / | 1 | 7 | 2 | Edit | Edit / | 2 | 8 | 4 | Joint Add / | 1 ------------------------------------------ [/ Code] I want to do something like this in my array array ('dashboard' = & gt; array ('id' = & gt; '' 'Dame' = & gt; 'Dashboard', 'Title' = & gt; 'Dashboard', 'MatchMin' = & gt; Base_URL (). 'Dashboard /', 'Active' => = & Gt; NULL), &
Read more

jQuery UI: Datepicker month format -

-
I am trying to change the format of the month that shows in the popup (not in the date that the picker actually I do not have any choice anywhere to do this, do I like to use a sub-string () or something else? What I normally display is Trying to change: Class = "ui-datepicker-title"> January & lt; / span & gt; ... & lt; / div & gt; Div>
Read more