PHP code to import from CSV file to MySQL

By: Nate Emailed: 1680 times Printed: 2157 times    

Latest comments
By: rohit kumar - how this program is work
By: Kirti - Hi..thx for the hadoop in
By: Spijker - I have altered the code a
By: ali mohammed - why we use the java in ne
By: ali mohammed - why we use the java in ne
By: mizhelle - when I exported the data
By: raul - no output as well, i'm ge
By: Rajesh - thanx very much...
By: Suindu De - Suppose we are executing

After playing a while, I'm confident the following replacement function works in all cases, including the ones for which the native fputcsv function fails. If fputcsv fails to work for you (particularly with mysql csv imports), try this function as a drop-in replacement instead.

Arguments to pass in are exactly the same as for fputcsv, though I have added an additional $mysql_null boolean which allows one to turn php null's into mysql-insertable nulls (by default, this add-on is disabled, thus working identically to fputcsv [except this one works!]).

<?php 

function fputcsv2 ($fh, array $fields, $delimiter = ',', $enclosure = '"', $mysql_null = false) { 
    $delimiter_esc = preg_quote($delimiter, '/'); 
    $enclosure_esc = preg_quote($enclosure, '/'); 

    $output = array(); 
    foreach ($fields as $field) { 
        if ($field === null && $mysql_null) { 
            $output[] = 'NULL'; 
            continue; 
        } 

        $output[] = preg_match("/(?:${delimiter_esc}|${enclosure_esc}|\s)/", $field) ? ( 
            $enclosure . str_replace($enclosure, $enclosure . $enclosure, $field) . $enclosure 
        ) : $field; 
    } 

    fwrite($fh, join($delimiter, $output) . "\n"); 
} 

// the _EXACT_ LOAD DATA INFILE command to use 
// (if you pass in something different for $delimiter 
// and/or $enclosure above, change them here too; 
// but _LEAVE ESCAPED BY EMPTY!_). 
/* 
LOAD DATA INFILE 
    '/path/to/file.csv' 

INTO TABLE 
    my_table 

FIELDS TERMINATED BY 
    ',' 

OPTIONALLY ENCLOSED BY 
    '"' 

ESCAPED BY 
    '' 

LINES TERMINATED BY 
    '\n' 
*/ 

?>

PHP Home | All PHP Tutorials | Latest PHP Tutorials

Sponsored Links

If this tutorial doesn't answer your question, or you have a specific question, just ask an expert here. Post your question to get a direct answer.



Bookmark and Share

Comments(0)


Be the first one to add a comment

Your name (required):


Your email(required, will not be shown to the public):


Your sites URL (optional):


Your comments:



More Tutorials by Nate
PHP code to import from CSV file to MySQL

More Tutorials in PHP
PHP code to import from CSV file to MySQL
PHP code to write to a CSV file from MySQL query
PHP code to write to a CSV file for Microsoft Applications
Convert XML to CSV in PHP
Password must include both numeric and alphabetic characters - Magento
PHP file upload (Large Files)
PHP file upload prompts authentication for anonymous users
PHP file upload with IIS on windows XP/2000 etc
Error: Length parameter must be greater than 0
Multiple File Upload in PHP using IFRAME
Resume or Pause File Uploads in PHP
Exception in module wampmanager.exe at 000F15A0 in Windows 8
Handling file locks in PHP
HTML table output using Nested for loops in PHP
Count occurrences of a character in a String in PHP

More Latest News
Most Viewed Articles (in PHP )
Parent: child process exited with status 3221225477 -- Restarting
A Basic Example using PHP in AWS (Amazon Web Services)
isset() function in PHP
Different versions of PHP - History and evolution of PHP
preg_split() and explode() in PHP
Reading word by word from a file in PHP
PHP file upload with IIS on windows XP/2000 etc
Password protecting a page in PHP
PHP file upload (Large Files)
Find Difference between two dates in PHP
call_user_func() or call_user_func_array() functions in PHP
Password must include both numeric and alphabetic characters - Magento
The new keyword and constructors in PHP
Static Methods in PHP
Using Sessions in PHP
Most Emailed Articles (in PHP)
PHP code to write to a CSV file from MySQL query
Counting Lines, Paragraphs, or Records in a File using pc_split_paragraphs() in PHP
Password must include both numeric and alphabetic characters - Magento
PHP code to import from CSV file to MySQL
Reading word by word from a file in PHP
Reading and Writing .gz files in PHP
A Basic Example using PHP in AWS (Amazon Web Services)
Perl's Encoding::FixLatin equivalent in PHP
PHP file upload with IIS on windows XP/2000 etc
PHP code to write to a CSV file for Microsoft Applications
Using list() in PHP
Handling BLOB in PHP and MySQL
Execution Lifetime of a PHP script
Installing PHP 5.x with Apache 2.x on HP UX 11i and configuring PHP 5.x with Oracle 9i
Convert XML to CSV in PHP