How do you handle 2 databases?

izbryte

I have a database that handles my products and another that handles my newsletter. When someone purchases a product, I'd like their email address to be added to my newsletter database. Since it's another database, rather than a table, I'm not sure how to connect to the second one.

I'm not really sure if I'm asking this question correctly but any help or feedback would be GREATLY appreciated!

Weedpacket

You'd make two connections, and store their handles in different connection variables - $product_db and $newsletter_db, say. When making the query, remember to specify which connection the query is to be sent on.

izbryte

I think this is above and beyond my realm of knowledge. Can you help me with it?

Weedpacket

Job postings are a violation of this forums' acceptable use policy.
Besides, it's not necessary to quote for a reference to [man]mysql_connect[/man] and [man]mysql_query[/man] (or the equivalent functions for whichever DBMS you work with, or the corresponding [man]PDO[/man] functions). For example, mysql_query is described as

resource mysql_query ( string $query [, resource $link_identifier] )

mysql_query() sends an unique query ... to the currently active database on the server that's associated with the specified link_identifier.

MarkR

If your user has permissions to both MySQL databases on the same server, it should be possible to refer to tables in a different database than the currently active one using dbname.tableame e.g.

SELECT * from newsletterdb.entries

You can even construct joins this way.

Out of interest, why don't you simply move all the tables into the same database? It sounds much easier.

Mark

izbryte

MarkR wrote:
If your user has permissions to both MySQL databases on the same server, it should be possible to refer to tables in a different database than the currently active one using dbname.tableame e.g.
SELECT * from newsletterdb.entries
You can even construct joins this way.

Out of interest, why don't you simply move all the tables into the same database? It sounds much easier.

Mark

Thanks! Simply because I'm lazy. There are several databases (I didn't set it up) and I don't feel like messing with it. 😃