How can PHP scripts be used to automate the process of transferring data between databases on a regular basis?

One way to automate the process of transferring data between databases on a regular basis using PHP is to create a script that connects to both databases, retrieves the data from the source database, and inserts it into the destination database. This can be achieved by using PHP's database connection functions and SQL queries to retrieve and insert the data. 

<?php

// Connect to source database
$source_db = new mysqli('source_host', 'source_username', 'source_password', 'source_database');

// Connect to destination database
$dest_db = new mysqli('dest_host', 'dest_username', 'dest_password', 'dest_database');

// Retrieve data from source database
$result = $source_db->query('SELECT * FROM source_table');

// Insert data into destination database
while ($row = $result->fetch_assoc()) {
    $dest_db->query("INSERT INTO dest_table (column1, column2) VALUES ('" . $row['column1'] . "', '" . $row['column2'] . "')");
}

// Close database connections
$source_db->close();
$dest_db->close();

?>

Keywords

PHP scripts automate data transfer databases regular basis

Related Questions