Hi, I have four databases by the name
1. rtdb
2. crb
3. pist
The rtdb and pist has emp_table but the same is given employee_table in crb.
This link shows that if two tables names are same in two different databases
then the connection can be switched.
pist1 database - databases.yml
=======================
all:
propel:
class: sfPropelDatabase
param:
classname: PropelPDO
dsn: 'mysql:host=localhost;dbname=pist1'
username: root
password: null
encoding: utf8
persistent: true
pooling: true
crb database - databases.yml
======================
all:
propel:
class: sfPropelDatabase
param:
dsn: 'mysql://root:@localhost/crb'
rtdb database - databases.yml
======================
all:
propel:
class: sfPropelDatabase
param:
dsn: 'mysql://root:@localhost/rtdb'
======================
Combined databases.yml
===================
all:
propel:
class: sfPropelDatabase
param:
classname: PropelPDO
dsn: 'mysql:host=localhost;dbname=pist1'
username: root
password: null
encoding: utf8
persistent: true
pooling: true
propel:
class: sfPropelDatabase
param:
dsn: 'mysql://root:@localhost/crb'
propel:
class: sfPropelDatabase
param:
dsn: 'mysql://root:@localhost/rtdb'
Regards
Deepak Bhatia
On Wed, Sep 8, 2010 at 4:53 PM, Gareth McCumskey <[email protected]>wrote:
> Why do things outside of symfony and the databases.yml?
>
>
> http://www.lampjunkie.com/2008/04/using-multiple-databases-in-symfony-with-propel/
>
> On Tue, Sep 7, 2010 at 7:52 AM, DEEPAK BHATIA
> <[email protected]>wrote:
>
>> Hi,
>>
>> I tried accessing some other database than specified in databases.yml. But
>> below is not working. Please help.
>>
>> $con=mysql_connect("localhost","root","");
>> if(!$con)
>> {
>> echo "Database Connection Not Estabilished\n";
>> exit(0);
>> }
>> $temp = mysql_select_db("rtdb");
>> if($temp == false)
>> {
>> exit(0);
>> }
>> $query = "SELECT id FROM severity_table";
>> $result = mysql_query($query);
>> while ($row = mysql_fetch_array($result))
>> {
>> echo $row["id"]; echo "<BR>"; echo "HELLO";
>> }
>>
>>
>> --
>> If you want to report a vulnerability issue on symfony, please send it to
>> security at symfony-project.com
>>
>> You received this message because you are subscribed to the Google
>> Groups "symfony users" group.
>> To post to this group, send email to [email protected]
>> To unsubscribe from this group, send email to
>> [email protected]<symfony-users%[email protected]>
>> For more options, visit this group at
>> http://groups.google.com/group/symfony-users?hl=en
>>
>
>
>
> --
> Gareth McCumskey
> http://garethmccumskey.blogspot.com
> twitter: @garethmcc
>
> --
> If you want to report a vulnerability issue on symfony, please send it to
> security at symfony-project.com
>
> You received this message because you are subscribed to the Google
> Groups "symfony users" group.
> To post to this group, send email to [email protected]
> To unsubscribe from this group, send email to
> [email protected]<symfony-users%[email protected]>
> For more options, visit this group at
> http://groups.google.com/group/symfony-users?hl=en
>
--
If you want to report a vulnerability issue on symfony, please send it to
security at symfony-project.com
You received this message because you are subscribed to the Google
Groups "symfony users" 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/symfony-users?hl=en
schema.yml
Description: Binary data
schema.yml
Description: Binary data
schema.yml
Description: Binary data
