Re: Dynamic database switching in cakephp 1.1.x
Hey Mark,
So I'm pretty sure some of the functions I used are specific to 1.2.
But you can try. I'll give you a basic overview of what I did.
I made a componant, and inside the componant in the initialize
method.. I do this:
(all the connection data is stored in a Client Model, that I load with
loadModel)
$newDb =&
ConnectionManager::create('myconn_name',
array('driver' => 'mysql'
,'host'
=> $client->data['Client']['db_host']
,'login'
=> $client->data['Client']['db_login']
,'password' =>
$client->data['Client']['db_password']
,'database' =>
$client->data['Client']['db_name']
,'persistent' => false
And then in my app_model I set
var $useDbConfig = 'myconn_name';
Again, I'm not sure at all how well this will work in 1.1
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups "Cake
PHP" group.
To post to this group, send email to cake-php@googlegroups.com
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
-~--~~~~--~~--~--~---
Re: Dynamic database switching in cakephp 1.1.x
On 6/19/07, Mark aka drecaise <[EMAIL PROTECTED]> wrote: > > I'm trying to add a database config and use it after init. It's for an > application that numerous clients will use. Each with it's own > database. During login a master database is queried for a users > corresponding company database and the application should switch to > that database. Is this possible? (and if not, can I write a behaviour > to create that possibility?) > > Mark Behaviours don't exist in 1.1, so you're out of luck there. Search the google group for some info on how to create dynamic database switching, it's in there. I believe you can use a beforeFilter but my mind is fuzzy today. -- Chris Hartjes Senior Developer Cake Development Corporation My motto for 2007: "Just build it, damnit!" @TheBallpark - http://www.littlehart.net/attheballpark @TheKeyboard - http://www.littlehart.net/atthekeyboard --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "Cake PHP" group. To post to this group, send email to cake-php@googlegroups.com 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 -~--~~~~--~~--~--~---
Dynamic database switching in cakephp 1.1.x
I'm trying to add a database config and use it after init. It's for an application that numerous clients will use. Each with it's own database. During login a master database is queried for a users corresponding company database and the application should switch to that database. Is this possible? (and if not, can I write a behaviour to create that possibility?) Mark --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "Cake PHP" group. To post to this group, send email to cake-php@googlegroups.com 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 -~--~~~~--~~--~--~---
