What are some best practices for importing data from an external CSV file into a website using PHP?

When importing data from an external CSV file into a website using PHP, it is important to follow best practices to ensure data integrity and security. One approach is to use PHP's built-in functions like fopen() and fgetcsv() to read the CSV file line by line and insert the data into a database. Additionally, it is recommended to validate the data before inserting it to prevent SQL injection attacks. 

<?php

$csvFile = 'data.csv';
$handle = fopen($csvFile, 'r');

if ($handle !== false) {
    while (($data = fgetcsv($handle, 1000, ',')) !== false) {
        // Validate and sanitize the data before inserting into the database
        $data = array_map('trim', $data);
        
        // Insert data into the database
        // Example: mysqli_query($connection, "INSERT INTO table_name (column1, column2) VALUES ('$data[0]', '$data[1]')");
    }
    
    fclose($handle);
} else {
    echo 'Error opening the CSV file';
}

?>

Keywords

CSV data import PHP file handling error handling

Related Questions