PHP code to import from CSV file to MySQL

By: Nate Emailed: 1758 times Printed: 2452 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 )
PHP code to import from CSV file to MySQL
The Object (compound) Type in PHP
History and origin of PHP
Getting Started with PHP
.htaccess pcfg_openfile: unable to check htaccess file, ensure it is readable
Different versions of PHP - History and evolution of PHP
Variables in PHP
isset() function in PHP
unset() and empty() functions in PHP
superglobals in PHP
Integers and Floating-Point Numbers in PHP
Strings in PHP
Here-docs (<<<) in PHP
Booleans in PHP
Traversing Arrays Using foreach in PHP
Most Emailed Articles (in PHP)
isset() function in PHP
Constants in PHP
while loops in PHP
Locking files in PHP
Deleting Cookies in PHP
Parent: child process exited with status 3221225477 -- Restarting
Function to force strict boolean values in PHP
use() in PHP
PHP code to write to a CSV file for Microsoft Applications
The Object (compound) Type in PHP
History and origin of PHP
Getting Started with PHP
Variables in PHP
unset() and empty() functions in PHP
superglobals in PHP