On Thu, July 6, 2006 11:54 am, Don wrote:
> I have a CSV file, comma delimited with the data enclosed by double
> quotes.
>
> I am using the fgetcsv() function to read and into an array and update
> a
> database. It works great except for the odd record. After
> investigating, I
> have ascertained that it is due to a backslash character in the data
> which
> fgetcsv() cannot parse properly. I don;t see anyway around this using
> fgetcsv(). Has anyone written a custom routine for this?
>
> Code Snippet
> -------------------
> $vvFile = 'myfile.csv';
> $fph = fopen($vvFile,"r")
> if ($fph) {
> while (($data = fgetcsv($fph,4096,',','"')) !== FALSE) {M
You *MUST* use:
http://php.net/mysql_real_escape_string
on each element of the array before cramming it into MySQL.
> // Insert fields from array '$data' to my MySQL database -
> will fail
> on bad data
> }
> fclose($fph);
> }
>
> Sample Data
> ------------------
> "123456","135679048754","7154904875","HD INDOOR INSECT KILR 33 OZ
> 6","EA"
> "654321","246809052607","7154905260","59-2 CACTUS & SUCCULENTS
> \","EA"
The \ is special to MySQL (and PHP) but not CSV.
So your problem is not with CSV -- It's with MySQL input routines.
See above.
--
Like Music?
http://l-i-e.com/artists.htm
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
