Monday, April 19, 2010

Load CSV using php

$mosConfig_offline = '0';
$mosConfig_host = 'localhost';
$mosConfig_user = 'root';
$mosConfig_password = '';
echo $selectedFile=$_SERVER['DOCUMENT_ROOT'];
$selectedFile=$selectedFile."/articls1.scv";
$connect=mysql_connect($mosConfig_host,$mosConfig_user,$mosConfig_password);
$database="csvdatas";
$select_db=mysql_select_db($database);
$ld=mysql_query('load DATA infile $selectedFile inTO TABLE article FIELDS TERMinATED BY \',\' OPTIONALLY ENCLOSED BY \'"\' IGNORE 1 LinES') or die(mysql_error());

//$loading_csv = "LOAD DATA LOCAL INFILE '$selectedFile' INTO TABLE user_full_info FIELDS TERMINATED BY ',' ENCLOSED BY '\"' LINES TERMINATED BY '\r\n'";
?>

0 Comments:

Post a Comment

Subscribe to Post Comments [Atom]

<< Home