Sure, no problem.
Just use 2 db configs and set the $default db config on runtime:
file app/config/database.php
class DATABASE_CONFIG {
var $default = null;
var $dev = array(
'driver' => 'mysql',
'persistent' => false,
'host' => 'localhost',
'login' => 'root',
'password' => secret1'',
'database' => 'db1',
'prefix' => '',
'encoding' => 'utf8',
);
var $prod = array(
'driver' => 'mysql',
'persistent' => false,
'host' => 'localhost',
'login' => 'root',
'password' => 'secret2',
'database' => 'db2',
'prefix' => '',
'encoding' => 'utf8',
);
/**
* @link
http://edwardawebb.com/web-development/cakephp/automatically-choose-database-connections-cakephp
*/
function __construct() {
//check to see if server name is set
if(isset($_SERVER['SERVER_NAME'])) {
switch($_SERVER['SERVER_NAME']) {
case 'example1.pl':
case 'www.example1.pl':
$this->default = $this->prod;
break;
default:
$this->default = $this->dev;
break;
}
}
else {
// we are likely baking, use our local db
$this->default = $this->dev;
}
}
}
The code above was taken from @link in comment. The dev is my laptop
with XAMPP, the prod is my production sever, both have MySQL server on
localhost.
I use it to automatically change db configs without editing config
file.
On Oct 28, 3:16 pm, Dmitry Shevchenko <[email protected]> wrote:
> I wanted to create 2 separated web site which will use same models and
> controllers.
>
> main aim - run 2 sites which will use almost the same logic but it
> will be build with different design.
> I wanted to use same models and controllers, because I want to support
> only one version.
>
> so database structure, models, controllers will be the same
> differents - views (design) and domains.
>
> On Oct 28, 2:54 pm, Zaky Katalan-Ezra <[email protected]> wrote:
>
>
>
> > What is your goal?
>
> > On Thu, Oct 28, 2010 at 12:31 PM, Dmitry Shevchenko
> > <[email protected]>wrote:
>
> > > Hi.
> > > Is it possibly for cake to have 2 different database, which is use
> > > same models and controllers and different views.
>
> > > I need this to create a almost copy of website, so system logic will
> > > be the same, I will only have separated DB and views.
>
> > > Seems this could be done by switching config on config.php and maybe
> > > dispatcher.php... but I'm not sure.
>
> > > Is someone do something similar ?
>
> > > Check out the new CakePHP Questions sitehttp://cakeqs.organdhelp 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]
> > > om>For more options, visit this group at
> > >http://groups.google.com/group/cake-php?hl=en
>
> > --
> > Regards,
> > Zaky Katalan-Ezra
> > QA Administratorwww.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
