Hi, I'm reading a csv file and using it to create, insert and modify a MySQL database. I'm trying to write it in such a way as to be as bullet proof as possible and loaded with comments so I can release it to anyone else who wants to do similar.
At least one bullet is getting through
The first line of the csv file is;
- PHP: Select all
"FileLocation","FileDirectory","Filename","JFIF_APP1","Main Information","ImageDescription","Make","Model","Software","DateTime","Sub
Information","ExposureTime","FNumber","ExposureProgram","ISOSpeedRatings","ExifVersion","DateTimeOriginal","DateTimeDigitized","Brigh
tnessValue","ExposureBiasValue","MaxApertureValue","MeteringMode","LightSource","Flash","FocalLength","ImageWidth","ImageHeight","Exp
osureMode","WhiteBalance","DigitalZoomRatio","FocalLength(35mm)","SceneCaptureType","GainControl","Contrast","Saturation","Sharpness"
,"SubjectDistanceRange"
As you might imagine my database is for images. Anyway,
- PHP: Select all
$data = fgetcsv($handle, $length);
reads it all in and creates my database OK. But as I say I want to release it and make it as fail safe as possible for myself and others. If one of the first three fields has a ' or a ` in it then fgetcsv reads in the data ok. If two of the fields have those characters it fails. A vardump of $data gives...
- Code: Select all
array(4) {
[0]=>
string(13) "File`Location"
[1]=>
string(13) "FileDirectory"
[2]=>
string(9) "Fi'lename"
[3]=>
string(0) ""
}
Strangely, if the second ' or ` is later on in the fields list it all works OK
Needless to say I've looked at this all ways up and it's doing my bonce in.
Hope someone can help.
Thanks
Phillip
Login
Contact Us
Advertise
Page Info
Anyway I've 'released' my csv to mysql script to anyone who needs such a thing. It still has the above 'bug' in it. Probably a lot more besides. Whether it will actually cause problems in other peoples real life data is probably not that likely, but I've warned of the problem in the notes.
