Re: how to recognize CSV file?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 





Ashley Sheridan wrote:
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@xxxxxxxx> wrote:
Eric Butera wrote:
On Fri, Sep 19, 2008 at 2:59 PM, Afan Pasalic <afan@xxxxxxxx> 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.

could you please be more specific?
I don't remember I ever saw file type when I was opening csv or txt or doc file?

-afan



Ash
www.ashleysheridan.co.uk


--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux