Re: how to recognize CSV file?
| From: | Afan Pasalic | 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
:-)