symfony2 multiple database

Question

i use symfony2 with FOSuserBundle.

i need 2 database connections one for Usermanagement and another remote database connection.

how can i use them simultaneously?

can parameters.ini file have double database params? sth like this

[parameters] database_driver="pdo_mysql"
database_host="localhost"
database_port=""
database_name="symfony"
database_user="root"
database_password=""
database2_driver="pdo_mysql"
database2_host="remote_ip"
database2_port=""
database2_name="symfonydb2"
database2_user="root"
database2_password=""

Did you check this link? symfony.com/doc/current/cookbook/doctrine/… — Víctor B.
– Víctor B., Commented Aug 6, 2012 at 21:29

Rénald Casagraude · Accepted Answer · 2012-08-07 14:52:39Z

2

To answer your questions:

how can i use them simultaneously?

Like @vbergae said, just take a look at How to work with Multiple Entity Managers

can parameters.ini file have double database params?

For sure, you'll just have to reference in your config file it like this:

%database2_driver%
%database2_host%
%database2_port%
%database2_name%
%database2_user%
%database2_password%

answered Aug 7, 2012 at 14:52

Rénald Casagraude

477 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

morteza kavakebi Over a year ago

i just want to use pure sql query how is it possible?

Rénald Casagraude Over a year ago

symfony2 being model agnostic you can use whatever you judge relevant to access you datas. But for separation concern leave your pure SQL queries in your model, don't do this in controller nor in views (Doh!)

Collectives™ on Stack Overflow

symfony2 multiple database

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related