What are the best practices for importing CSV data into a MySQL database using PHP?

When importing CSV data into a MySQL database using PHP, it is important to follow best practices to ensure data integrity and security. One common approach is to use the PHP `fgetcsv` function to read the CSV file line by line and insert the data into the database using prepared statements to prevent SQL injection attacks. Additionally, it is recommended to validate and sanitize the data before inserting it into the database. 

<?php
// Connect to MySQL database
$mysqli = new mysqli("localhost", "username", "password", "database");

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

// Open the CSV file for reading
$csvFile = fopen("data.csv", "r");

// Read and insert data into the database
while (($data = fgetcsv($csvFile)) !== false) {
    $stmt = $mysqli->prepare("INSERT INTO table_name (column1, column2, column3) VALUES (?, ?, ?)");
    $stmt->bind_param("sss", $data[0], $data[1], $data[2]);
    $stmt->execute();
}

// Close the CSV file and database connection
fclose($csvFile);
$mysqli->close();
?>

Keywords

CSV MySQL database import PHP

Related Questions