mysqlimport

Dillenger

How in the heck to I use mysqlimport with PHP...

what i'm trying to do is get Mysql to read a CSV file and then import it into the table fields... it worked before, only problem is I was using LOAD DATA LOCAL FILE function which now is not supported in my server. so I need a work around?

Is there a way for PHP to import data other than LOAD DATA LOCAL FILE????

keith73

if mysqlimport was enabled, but is no longer, it is possible that FILES permissions were disabled so you can't import or export anything to/from mysql anymore. PHP can't just bypass that.

what you could do is have php read in the data from the file and parse it out.

keith

Dillenger

hmmm interesting...

how would i go about doing that?

yelvington

If you can't use this:
http://dev.mysql.com/doc/mysql/en/LOAD_DATA.html

then use this
http://us3.php.net/fgetcsv
and insert one line at a time.

Dillenger

Ok, so that works for printing it out, how would I now take that info, and import it into the MySQL database?

<? 
$row = 1;
$handle = fopen("/home/yellow1/public_html/database/admin/input/temp/SEIZURE.txt", "r");
while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) {
   $num = count($data);
   echo "<p> $num fields in line $row: <br /></p>\n";
   $row++;
   for ($c=0; $c < $num; $c++) {
       echo $data[$c] . "<br />\n";
   }
}
fclose($handle);
?>

yelvington

http://dev.mysql.com/doc/mysql/en/INSERT.html

http://us3.php.net/mysql_query