How can the PHP code for importing CSV data into MySQL be optimized or improved for better performance and efficiency?

To optimize the PHP code for importing CSV data into MySQL for better performance and efficiency, you can use MySQL's `LOAD DATA INFILE` command instead of looping through each row in the CSV file and executing individual `INSERT` statements. This command allows for bulk data insertion, significantly reducing the processing time. 

// Connect to MySQL database
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "database";
$conn = new mysqli($servername, $username, $password, $dbname);

// Import CSV data into MySQL using LOAD DATA INFILE
$csvFile = 'data.csv';
$sql = "LOAD DATA INFILE '$csvFile' INTO TABLE your_table FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n' IGNORE 1 LINES";
$conn->query($sql);

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

Keywords

PHP CSV MySQL optimization performance

Related Questions