Re: how to recognize CSV file?

From: Date: Fri, 19 Sep 2008 19:24:04 +0000
Subject: Re: how to recognize CSV file?
References: 1 2 3 4  Groups: php.general 
Request: Send a blank email to php-general+get-280545@lists.php.net to get a copy of this message
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 :-)

« previous php.general (#280545) next »