http://dev.mysql.com/doc/refman/5.0/en/federated-use.html
On Wed, Feb 3, 2010 at 11:08 PM, Bryan De Asis <[email protected]>wrote: > Sorry Zaky can you elaborate it more... what do you mean by create a view > in the database that select from the other database? > > Thanks > > > On Wed, Feb 3, 2010 at 3:45 PM, Zaky Katalan-Ezra <[email protected]>wrote: > >> Create a view in the database that select from the other database. >> This way you need only one connection. >> >> On Tue, Feb 2, 2010 at 7:58 PM, Bryan De Asis <[email protected]>wrote: >> >>> Co'z I'm creating a database table which contains the database connection >>> credentials so i can have thousands hundreds of config... so i can manage >>> other news articles table databases using same plugin... >>> >>> >>> >>> >>> On Tue, Feb 2, 2010 at 12:51 PM, Miles J <[email protected]>wrote: >>> >>>> Why aren't you just placing the config in database.php? >>>> >>>> On Feb 2, 8:48 am, bryan de asis <[email protected]> wrote: >>>> > Hello, >>>> > >>>> > Has anyone here tried to create a plugin which connects to a >>>> > difference database dynamically? >>>> > My Plugin name is "News" >>>> > I have tried adding this lines on beforeFilter on my >>>> > ArticlesController: >>>> > $db =& ConnectionManager::getDataSource('default'); >>>> > $db->disconnect(); >>>> > $db->config['host'] = 'localhost'; >>>> > $db->config['login'] = 'login'; >>>> > $db->config['password'] = 'password'; >>>> > $db->config['database'] = 'database_name'; >>>> > $db->connect(); >>>> > and it doesn't work... it still doesnt work. >>>> > >>>> > anyone have any idea... >>>> >>>> Check out the new CakePHP Questions site http://cakeqs.org and help >>>> others with their CakePHP related questions. >>>> >>>> You received this message because you are subscribed to the Google >>>> Groups "CakePHP" group. >>>> To post to this group, send email to [email protected] >>>> To unsubscribe from this group, send email to >>>> [email protected]<cake-php%[email protected]>For >>>> more options, visit this group at >>>> http://groups.google.com/group/cake-php?hl=en >>>> >>> >>> Check out the new CakePHP Questions site http://cakeqs.org and help >>> others with their CakePHP related questions. >>> >>> You received this message because you are subscribed to the Google Groups >>> "CakePHP" group. >>> To post to this group, send email to [email protected] >>> To unsubscribe from this group, send email to >>> [email protected]<cake-php%[email protected]>For >>> more options, visit this group at >>> http://groups.google.com/group/cake-php?hl=en >>> >> >> >> >> -- >> Regards, >> Zaky Katalan-Ezra >> QA Administrator >> www.IGeneriX.com >> Sites.IGeneriX.com >> 054-7762312 >> >> Check out the new CakePHP Questions site http://cakeqs.org and help >> others with their CakePHP related questions. >> >> You received this message because you are subscribed to the Google Groups >> "CakePHP" group. >> To post to this group, send email to [email protected] >> To unsubscribe from this group, send email to >> [email protected]<cake-php%[email protected]>For >> more options, visit this group at >> http://groups.google.com/group/cake-php?hl=en >> > > Check out the new CakePHP Questions site http://cakeqs.org and help > others with their CakePHP related questions. > > You received this message because you are subscribed to the Google Groups > "CakePHP" group. > To post to this group, send email to [email protected] > To unsubscribe from this group, send email to > [email protected]<cake-php%[email protected]>For > more options, visit this group at > http://groups.google.com/group/cake-php?hl=en > -- Regards, Zaky Katalan-Ezra QA Administrator www.IGeneriX.com Sites.IGeneriX.com 054-7762312 Check out the new CakePHP Questions site http://cakeqs.org and help others with their CakePHP related questions. You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en
