How can accounts from multiple PHP applications be merged into one?

To merge accounts from multiple PHP applications into one, you can create a script that connects to each application's database, retrieves the necessary account information, and inserts it into the central database. You can use SQL queries to select the relevant data and then insert it into the central database table. 

// Connect to the database of each application
$connectionApp1 = new mysqli('localhost', 'username', 'password', 'app1_database');
$connectionApp2 = new mysqli('localhost', 'username', 'password', 'app2_database');
$connectionCentral = new mysqli('localhost', 'username', 'password', 'central_database');

// Select account information from each application
$queryApp1 = "SELECT id, username, email FROM users";
$resultApp1 = $connectionApp1->query($queryApp1);

$queryApp2 = "SELECT id, username, email FROM customers";
$resultApp2 = $connectionApp2->query($queryApp2);

// Insert account information into central database
while($row = $resultApp1->fetch_assoc()) {
    $id = $row['id'];
    $username = $row['username'];
    $email = $row['email'];
    
    $queryInsert = "INSERT INTO central_users (id, username, email) VALUES ('$id', '$username', '$email')";
    $connectionCentral->query($queryInsert);
}

while($row = $resultApp2->fetch_assoc()) {
    $id = $row['id'];
    $username = $row['username'];
    $email = $row['email'];
    
    $queryInsert = "INSERT INTO central_users (id, username, email) VALUES ('$id', '$username', '$email')";
    $connectionCentral->query($queryInsert);
}

// Close connections
$connectionApp1->close();
$connectionApp2->close();
$connectionCentral->close();

Keywords

PHP account merging multiple applications authentication user data

Related Questions