Copy client information from one database to another

[wongle]

Hi there,

I am new to PHP / MySQL and I would like to transfer a client's data (ID 223 for example) from the clients table on DB1 to the clients table on DB2. The databases have the same structure and used by two different companies.

Can this be done using PHP / MySQL please? I access the client data on a single page using display.php?id=223

Cheers.

[ginerjm]

Perhaps you should describe the real-life situation here that makes you ask this question.  If you have two users who are looking at the same data I have to wonder why you want to duplicate this data rather than adjust your app to properly manage it.

[Barand]

Assuming DB1 and DB2 live on the same server...

$pdo->exec("INSERT INTO DB2.client SELECT * from DB1.client WHERE client_id = 223");

 

[wongle]

4 minutes ago, ginerjm said:

Perhaps you should describe the real-life situation here that makes you ask this question.  If you have two users who are looking at the same data I have to wonder why you want to duplicate this data rather than adjust your app to properly manage it.

Hi there - thanks for your reply, this is because they are 2 separate companies and clients are referred between the 2.

[wongle]

3 minutes ago, Barand said:

Assuming DB1 and DB2 live on the same server...

$pdo->exec("INSERT INTO DB2.client SELECT * from DB1.client WHERE client_id = 223");

Thanks for this, yes, they are on the same server.