How can the str_getcsv() function in PHP be effectively used to import data into a database, and what are potential issues to watch out for?

To effectively use the str_getcsv() function in PHP to import data into a database, you can read a CSV file line by line, parse each line using str_getcsv(), and then insert the data into the database. One potential issue to watch out for is ensuring that the CSV file is properly formatted and that the data is sanitized before inserting it into the database to prevent SQL injection attacks. 

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

while (($data = fgetcsv($handle)) !== false) {
    // Assuming data is in format: column1, column2, column3
    $column1 = $data[0];
    $column2 = $data[1];
    $column3 = $data[2];

    // Sanitize data before inserting into database
    $column1 = mysqli_real_escape_string($connection, $column1);
    $column2 = mysqli_real_escape_string($connection, $column2);
    $column3 = mysqli_real_escape_string($connection, $column3);

    // Insert data into database
    $query = "INSERT INTO table_name (column1, column2, column3) VALUES ('$column1', '$column2', '$column3')";
    mysqli_query($connection, $query);
}

fclose($handle);

Keywords

str_getcsv PHP import data database potential issues

Related Questions