How I can write only one query with PDO and 2 MySQL databases

Asked Mar 29 '16 at 11:01

Active Mar 29 '16 at 11:05

Viewed 38 times

I have a request that I should do the joint of 2 tables, 2 tables belong to different databases, how to prepare, execute and display the results, knowing that the first connection is $db1 and 2nd is $db, and preparation is made for example,here is my code:

 $db=new PDO('mysql:host=localhost;dbname=service','root','');
$db1=new PDO('mysql:host=localhost;dbname=service1','root','');
$query = 'SELECT * FROM db1.table1 JOIN db2.table2 ... WHERE ... id = ?';

edited Mar 29 '16 at 11:05

Muhammad Arif

1,014
3
22
56

asked Mar 29 '16 at 11:01

Olfa

Thanks, but how i can write a prepare request, here my code : $sql = $db1->prepare('update myusers a inner join "'.$db.'".myusers b on (a.ID=b.ID) set a.fid=b.fid where a.ID = 1 and b.ID = 1'); $sql->execute(); – Olfa Mar 29 '16 at 11:09
Just write it usual way. – Your Common Sense Mar 29 '16 at 11:12
@YourCommonSense, sorry can you exlain to me more. – Olfa Mar 29 '16 at 11:15
There is absolutely no difference from a regular prepared statement. – Your Common Sense Mar 29 '16 at 11:18
thanks, it's resolved. – Olfa Mar 29 '16 at 11:20

How I can write only one query with PDO and 2 MySQL databases

0 Answers0