RE: Multiple Database Connection Using Prepard Statements

Just remember to close the correct connection whn it is time to :)

-----Original Message-----
From: Matijn Woudt [mailto:[email protected]] 
Sent: 19 May 2012 23:42
To: Ron Piggott
Cc: [email protected]
Subject: Re: [PHP-DB] Multiple Database Connection Using Prepard Statements

On Sat, May 19, 2012 at 8:36 PM, Ron Piggott <[email protected]> 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
>

$dsh = 'mysql:host=localhost;dbname='.$database3;
$dbh = new PDO($dsh, $username, $password);
$dsh2 = 'mysql:host=localhost;dbname='.$database1;
$dbh2 = new PDO($dsh2, $username2, $password2);

Now you can use $dbh for $database3, and $dbh2 for $database1...

- Matijn

--
PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php