Re: Multiple Database Connection Using Prepard Statements
| From: | Bastien | Date: | Sun, 20 May 2012 12:50:13 +0000 |
| Subject: | Re: Multiple Database Connection Using Prepard Statements | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-48290@lists.php.net to get a copy of this message | ||
Bastien Koert
On 2012-05-19, at 2:36 PM, "Ron Piggott" <ron.piggott@actsministries.org> wrote:
>
> How do I connect to multiple mySQL databases using Prepared Statements ?
>
> I have the syntax
>
> ===
> $dsh = 'mysql:host=localhost;dbname='.$database3;
> $dbh = new PDO($dsh, $username, $password);
> ===
>
> I want to connect to $database1 without loosing my $database3 connection
>
> Thoughts? Comments?
>
>
> Ron Piggott
>
>
> www.TheVerseOfTheDay.info
Ron,
MySQL also supports the convention of using the database name in the query so that you don't
necessarily need another connection manage
Select field1, field2 ... Fieldn from db2.table_name [where clause]