Re: Plugin using different Dynamic Database Connection

everything is encrypted...

On Wed, Feb 3, 2010 at 4:45 PM, Miles J <mileswjohnson@gmail.com> wrote:

From an architecture standpoint, storing credentials in a database is
a pretty bad idea.

On Feb 3, 1:08 pm, Bryan De Asis <bryandea...@gmail.com> 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 <procsh...@gmail.com>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 <bryandea...@gmail.com>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 <mileswjohn...@gmail.com> wrote:
>
> >>> Why aren't you just placing the config in database.php?
>
> >>> On Feb 2, 8:48 am, bryan de asis <bryandea...@gmail.com> 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 sitehttp://cakeqs.organd 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 cake-php@googlegroups.com
> >>> To unsubscribe from this group, send email to

> >>> cake-php+unsubscribe@googlegroups.com<cake-php%2Bunsubscribe@googlegroups.com>For more options, visit this group at

> >>>http://groups.google.com/group/cake-php?hl=en
>

> >>  Check out the new CakePHP Questions sitehttp://cakeqs.organd 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 cake-php@googlegroups.com
> >> To unsubscribe from this group, send email to

> >> cake-php+unsubscribe@googlegroups.com<cake-php%2Bunsubscribe@googlegroups.com>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 sitehttp://cakeqs.organd 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 cake-php@googlegroups.com
> > To unsubscribe from this group, send email to

> > cake-php+unsubscribe@googlegroups.com<cake-php%2Bunsubscribe@googlegroups.com>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 cake-php@googlegroups.com
To unsubscribe from this group, send email to
cake-php+unsubscribe@googlegroups.com 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 cake-php@googlegroups.com
To unsubscribe from this group, send email to
cake-php+unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en