What are common errors encountered when trying to insert a CSV file into a MySQL table using PHP?

Common errors encountered when trying to insert a CSV file into a MySQL table using PHP include incorrect file path, mismatched column names in the CSV file and MySQL table, and improper data formatting. To solve these issues, ensure that the file path is correct, the column names in the CSV file match the MySQL table columns, and the data is formatted correctly before insertion. 

<?php
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "database";

$conn = new mysqli($servername, $username, $password, $dbname);

if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

$csvFile = 'path/to/your/file.csv';
$csv = array_map('str_getcsv', file($csvFile));

foreach($csv as $row) {
    $sql = "INSERT INTO your_table (column1, column2, column3) VALUES ('" . $row[0] . "', '" . $row[1] . "', '" . $row[2] . "')";
    if ($conn->query($sql) === TRUE) {
        echo "Record inserted successfully";
    } else {
        echo "Error: " . $sql . "<br>" . $conn->error;
    }
}

$conn->close();
?>

Keywords

CSV MySQL PHP insert errors

Related Questions