uploading a csv to database - Mac

[Peggy]

I have code that works  to upload a csv file to a database. It does not work on a csv that was created on a Mac. (My customer uses a Mac). I also found code that is supposed to help with the line breaks, but I can't seem to get that to work. I sure hope someone can help me! Here is my code

if($_POST['submit_csv']){

 

ini_set('auto_detect_line_endings',TRUE);

 

if (($handle = fopen($csvfile, "r")) !== FALSE) {

while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) {

$num = count($data);

$sql = "INSERT into jbs_product VALUES('',";

 

for ($c=0; $c < $num; $c++) {

$sql .= "'". $data[$c] . "',";

}

$sql = substr($sql, 0, -1) . ')';

$result = mysql_query($sql,$db) or die(mysql_error(). "<br />SQL: $sql");

}

fclose($handle);

}

ini_set('auto_detect_line_endings',FALSE);

 

}

include("inc/form_upload_csv.inc.php");

 

 

[premiso]

You may want to try this:

 

http://www.php.net/manual/en/function.fgetcsv.php#26886

 

From the user comments. Perhaps that function will work properly for you.

[Peggy]

Thanks. It will take my brain a while to digest the code that you directed me to. I'll let you know if it works for me.

Thanks