Select on two diffents databases
- Thread starter asdriel
- Start date
-
Welcome to Original Babiato! All Resource are Free and No downloading Limit.. Join Our Official Telegram Channel For updates Bypass All the resource restrictions/Password/Key? Read here! Read Before submitting Resource Read here! Support Our Work By Donating Click here!
Make one database for both sites and do the same column for product attributes. that's the best solution. also if you have same design you can white label your website
If you are using woocommerce, you can use HyperDB for this situation.
https://wordpress.org/plugins/hyperdb/
https://wordpress.org/plugins/hyperdb/
djjogy
Member
- Aug 22, 2019
- 89
- 68
- 18
join 2 database to one
exemplar
exemplar
PHP:
<?php
$pdo = new PDO('mysql:host=localhost;dbname=databaseA', 'root', 'mysql'); //Database 1
$pdo2 = new PDO('mysql:host=localhost;dbname=databaseB', 'root', 'mysql'); //Database 2
$sql = "SELECT a.userID, b.usersFirstName, b.usersLastName FROM databaseA.dbo.TableA a inner join database B.dbo.TableB b ON a.userID=b.userID";
foreach ($pdo->query($sql) as $row) {
$jo1 = $row['userID'];
$jo2 = $row['usersFirstName'];
}
?>
Last edited:
Similar threads
