What are the best practices for copying records from one table to another in PHP?

When copying records from one table to another in PHP, it is best practice to use SQL queries to retrieve the records from the source table and then insert them into the destination table. This can be achieved by selecting the records from the source table and then executing an INSERT query to add them to the destination table. 

// Connect to the database
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "database";

$conn = new mysqli($servername, $username, $password, $dbname);

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

// Select records from the source table
$sql = "SELECT * FROM source_table";
$result = $conn->query($sql);

// Insert records into the destination table
if ($result->num_rows > 0) {
    while($row = $result->fetch_assoc()) {
        $insert_sql = "INSERT INTO destination_table (column1, column2, column3) VALUES ('" . $row['column1'] . "', '" . $row['column2'] . "', '" . $row['column3'] . "')";
        $conn->query($insert_sql);
    }
}

// Close connection
$conn->close();

Keywords

SQL database INSERT UPDATE transaction

Related Questions