What are common methods for copying data from one table to another in PHP?

When copying data from one table to another in PHP, a common method is to use SQL queries to select the data from the source table and insert it into the destination table. Another approach is to use PHP functions like mysqli_fetch_assoc() to fetch the data from the source table and mysqli_query() to insert it into the destination table. It is important to ensure that the tables have the same structure and that any necessary data transformations are applied before copying. 

// Connect to the database
$connection = mysqli_connect("localhost", "username", "password", "database");

// Select data from source table
$sourceData = mysqli_query($connection, "SELECT * FROM source_table");

// Insert data into destination table
while($row = mysqli_fetch_assoc($sourceData)) {
    $value1 = $row['column1'];
    $value2 = $row['column2'];
    
    mysqli_query($connection, "INSERT INTO destination_table (column1, column2) VALUES ('$value1', '$value2')");
}

// Close the connection
mysqli_close($connection);

Keywords

PHP MySQL SQL INSERT INTO SELECT

Related Questions