Is it possible to streamline the registration process in PHP so that a user is registered across multiple databases at once?

To streamline the registration process in PHP so that a user is registered across multiple databases at once, you can create a function that connects to each database and inserts the user's information. This can be done by looping through an array of database connections and executing the INSERT query for each database. 

<?php

function registerUserAcrossMultipleDatabases($userData, $databaseConnections) {
    foreach($databaseConnections as $connection) {
        $conn = new mysqli($connection['host'], $connection['username'], $connection['password'], $connection['database']);
        
        $sql = "INSERT INTO users (username, email, password) VALUES ('".$userData['username']."', '".$userData['email']."', '".$userData['password']."')";
        
        $conn->query($sql);
        
        $conn->close();
    }
}

$userData = [
    'username' => 'example_user',
    'email' => 'example@example.com',
    'password' => 'password123'
];

$databaseConnections = [
    ['host' => 'localhost', 'username' => 'root', 'password' => 'root', 'database' => 'database1'],
    ['host' => 'localhost', 'username' => 'root', 'password' => 'root', 'database' => 'database2']
];

registerUserAcrossMultipleDatabases($userData, $databaseConnections);

?>

Keywords

PHP registration process multiple databases streamline user registration

Related Questions