What is the purpose of using a foreach loop in PHP when transferring data to a database?

When transferring data to a database in PHP, using a foreach loop can be beneficial when dealing with arrays of data that need to be inserted into the database. It allows you to iterate over each element in the array and insert them into the database one by one, ensuring that all data is properly processed and inserted. 

// Assuming $data is an array of data to be inserted into the database
foreach ($data as $row) {
    // Insert each row of data into the database
    // $row['column_name'] should correspond to the column names in your database table
    // $row['value'] should be the value to be inserted
    $sql = "INSERT INTO table_name (column_name) VALUES ('" . $row['value'] . "')";
    
    // Execute the SQL query
    $result = mysqli_query($connection, $sql);
    
    // Check for errors
    if (!$result) {
        echo "Error: " . mysqli_error($connection);
    }
}

Keywords

foreach loop PHP data transfer database iteration

Related Questions