Importing CSV data using PHP/MySQL

by

I answered a virtually identical question just the other day: Save CSV files into mysql database

MySQL has a feature LOAD DATA INFILE, which allows it to import a CSV file directly in a single SQL query, without needing it to be processed in a loop via your PHP program at all.

Simple example:

<?php
$query = <<<eof
    LOAD DATA INFILE '$fileName'
     INTO TABLE tableName
     FIELDS TERMINATED BY '|' OPTIONALLY ENCLOSED BY '"'
     LINES TERMINATED BY '\n'
    (field1,field2,field3,etc)
eof;

$db->query($query);
?>

It’s as simple as that.

No loops, no fuss. And much much quicker than parsing it in PHP.

MySQL manual page here: http://dev.mysql.com/doc/refman/5.1/en/load-data.html

Hope that helps

More Related Contents:

  1. Import CSV file directly into MySQL
  2. Using PHP data in MySQL [closed]
  3. Gather column name of a table from database [closed]
  4. I am seeing this error on submitting form Error: query was empty [closed]
  5. How to convert the json image url string into Bitmap image to display images in android application
  6. How to use multiple databases in Laravel
  7. Automated or regular backup of mysql data
  8. strange character encoding of stored data , old script is showing them fine new one doesn’t
  9. Show values from a MySQL database table inside a HTML table on a webpage [duplicate]
  10. How can I store and retrieve images from a MySQL database using PHP?
  11. PDO mysql: How to know if insert was successful
  12. Loading .sql files from within PHP
  13. How to store file name in database, with other info while uploading image to server using PHP?
  14. How to successfully rewrite old mysql-php code with deprecated mysql_* functions?
  15. Mechanisms for tracking DB schema changes [closed]
  16. Fetching single row, single column with PDO
  17. Remove BOM () from imported .csv file
  18. PDO::PARAM for type decimal?
  19. IP address storing in MySQL database using PHP [duplicate]
  20. How to store an array into mysql?
  21. PHP – Import CSV file to mysql database Using LOAD DATA INFILE
  22. Get all child, grandchild etc nodes under parent using php with mysql query results
  23. How to execute raw queries with Laravel 5.1?
  24. Saving images in database mysql
  25. PHP – Secure member-only pages with a login system
  26. Using LIKE in bindParam for a MySQL PDO Query [duplicate]
  27. mysqli – fetch_Array error call to a member function fetch_array() on a non-object mysqli [duplicate]
  28. Process very big csv file without timeout and memory error
  29. Auto Increment skipping numbers?
  30. How to get last inserted id from table MySQL [duplicate]

Leave a Comment