Re: how to recognize CSV file?

On Fri, 2008-09-19 at 14:24 -0500, Afan Pasalic wrote: > > Eric Butera wrote: > > On Fri, Sep 19, 2008 at 3:14 PM, Afan Pasalic <afan@afan.net> wrote: > > > >> Eric Butera wrote: > >> > >>> On Fri, Sep 19, 2008 at 2:59 PM, Afan Pasalic <afan@afan.net> wrote: > >>> > >>> > >>>> hi, > >>>> I have form where administrator has toupload csv file to update dome > >>>> data in mysql. > >>>> I was trying to validate entered file but got some crazy stuff I don't > >>>> understand: > >>>> > >>>> for the same uploaded csv file, in different browser I'll get different > >>>> results: > >>>> > >>>> Windows machine and IE: $_FILES['UploadedFile']['type'] = > >>>> 'text/plain' > >>>> Windows machine and Firefox: > >>>> $_FILES['UploadedFile']['type'] = > >>>> 'application/octet-stream' > >>>> Windows machine and Opera: $_FILES['UploadedFile']['type'] > >>>> = > >>>> 'comma-separated-values' > >>>> Windows machine and Chrome: > >>>> $_FILES['UploadedFile']['type'] = '' > >>>> (doesn't show anything! empty?!?!!??) > >>>> openSuse machine and Firefox: > >>>> $_FILES['UploadedFile']['type'] = 'text/csv' > >>>> openSuse machine and Opera: > >>>> $_FILES['UploadedFile']['type'] = > >>>> 'text/comma-separated-values' > >>>> openSuse machine and Konqueror: > >>>> $_FILES['UploadedFile']['type'] = 'text/csv' > >>>> > >>>> ok. what's CORRECT way to validate uploaded file? > >>>> > >>>> thanks. > >>>> > >>>> -afan > >>>> > >>>> > >>> Get the mime type of the uploaded tmp file, no what the browser sends. > >>> > >>> > >> Fatal error: Call to undefined function mime_content_type() in /srv/www/... > >> > >> it looks like Mimetype is not installed on my server > >> :-) > >> > >> > >> > >> > >> > > > > Do you have fileinfo? It's a php5 pecl extension. Aside from that > > I'm not really sure. This is how I always test files since browser > > mime type is unreliable/spoofable. > > > > Fatal error: Call to undefined function finfo_open() in /srv/www/... > no luck > :-) > > > > If you don't have access to the functions, you could try reading the first line of the file to determine it's in the right format. Ash www.ashleysheridan.co.uk