Untitled

<?php
// Database connection details for the first database
$servername1 = "localhost";
$username1 = "username1";
$password1 = "password1";
$dbname1 = "database1";

// Database connection details for the second database
$servername2 = "localhost";
$username2 = "username2";
$password2 = "password2";
$dbname2 = "database2";

// Create connection to the first database
$conn1 = new mysqli($servername1, $username1, $password1, $dbname1);

// Check connection
if ($conn1->connect_error) {
    die("Connection failed: " . $conn1->connect_error);
}

// Create connection to the second database
$conn2 = new mysqli($servername2, $username2, $password2, $dbname2);

// Check connection
if ($conn2->connect_error) {
    die("Connection failed: " . $conn2->connect_error);
}

// SQL statements to insert data
$sql1 = "INSERT INTO employees (id, first_name, last_name, email) VALUES (1, 'John', 'Doe', 'john.doe@example.com')";
$sql2 = "INSERT INTO employees (id, first_name, last_name, email) VALUES (1, 'John', 'Doe', 'john.doe@example.com')";

// Execute the queries
if ($conn1->query($sql1) === TRUE && $conn2->query($sql2) === TRUE) {
    echo "New records created successfully in both databases";
} else {
    echo "Error: " . $sql1 . "<br>" . $conn1->error;
    echo "Error: " . $sql2 . "<br>" . $conn2->error;
}

// Close the connections
$conn1->close();
$conn2->close();
?>