How can PHP be used to efficiently combine data from CSV files into a single database table?

To efficiently combine data from CSV files into a single database table using PHP, you can read each CSV file line by line, parse the data, and insert it into the database table. You can use PHP's built-in functions like fgetcsv() to read CSV files and PDO to interact with the database. By properly handling errors and optimizing the database insertion process, you can efficiently combine data from multiple CSV files into a single database table. 

<?php
// Connect to the database
$dsn = 'mysql:host=localhost;dbname=your_database';
$username = 'your_username';
$password = 'your_password';
$pdo = new PDO($dsn, $username, $password);

// Array of CSV files to process
$csvFiles = ['file1.csv', 'file2.csv', 'file3.csv'];

// Loop through each CSV file
foreach ($csvFiles as $file) {
    $handle = fopen($file, 'r');
    if ($handle !== false) {
        while (($data = fgetcsv($handle)) !== false) {
            // Insert data into the database table
            $stmt = $pdo->prepare("INSERT INTO your_table (column1, column2, column3) VALUES (?, ?, ?)");
            $stmt->execute([$data[0], $data[1], $data[2]]);
        }
        fclose($handle);
    } else {
        echo "Error opening file: $file";
    }
}
?>

Keywords

PHP CSV files database table data integration efficiency

Related Questions