Check file uploaded is in csv format

Question

I am uploading a file in php and only want to upload it if it s a csv file  I believe my syntax is right for the content type  It always goes to else statement when it s a csv file  What I am doing wrong here   if     FILES  file    type       text csv         else        If I change the content type it works for that format just not csv

User · Answer

As you are worried about user upload other file by mistake  I would suggest you to use accept   csv  in  lt input gt  tag  It will show only csv files in browser when the user uploads the file  If you have found some better solution then please let me know as I am also trying to do same and in the same condition -  trusted users but trying to avoid mistake

User · Answer

So I ran into this today    Was attempting to validate an uploaded CSV file s MIME type by looking at   FILES  upload file    type    but for certain users on various browsers  and not necessarily the same browsers between said users  for instance it worked fine for me in FF but for another user it didn t work on FF  the   FILES  upload file    type   was coming up as  application vnd ms-excel  instead of the expected  text csv  or  text plain     So I resorted to using the  IMHO  much more reliable finfo   functions something like this    acceptable mime types   array  text plain    text csv    text comma-separated-values     if   empty   FILES   amp  amp  array key exists  upload file     FILES   amp  amp    FILES  upload file    error      UPLOAD ERR OK         tmpf     FILES  upload file    tmp name            Make sure  tmpf is kosher  then        finfo   finfo open FILEINFO MIME TYPE        mime type   finfo file  finfo   tmpf        if   in array  mime type   acceptable mime types                Unacceptable mime type

User · Answer

Mime type option is not best option for validating CSV file  I used this code this worked well in all browser   type   explode       FILES  file    name     if strtolower end  type       csv       else

User · Answer

the mime type might not be text csv some systems can read save them different   for example sometimes IE sends  csv files as application vnd ms-excel  so you best bet would be to build an array of allowed values and test against that  then find all possible values to test against     mimes   array  application vnd ms-excel   text plain   text csv   text tsv    if in array   FILES  file    type    mimes         do something   else     die  Sorry  mime type not allowed        if you wished you could add a further check if mime is returned as text plain you could run a preg match to make sure it has enough commas in it to be a csv

User · Answer

You can t always rely on MIME type    According to  http   filext com file-extension CSV  text comma-separated-values  text csv  application csv  application excel  application vnd ms-excel  application vnd msexcel  text anytext   There are various MIME types for CSV   Your probably best of checking extension  again not very reliable  but for your application it may be fine    info   pathinfo   FILES  uploadedfile    tmp name      if  info  extension       csv        Good to go     Code untested

User · Answer

There are a lot of possible MIME types for CSV files  depending on the user s OS and browser version   This is how I currently validate the MIME types of my CSV files    csv mimetypes   array       text csv        text plain        application csv        text comma-separated-values        application excel        application vnd ms-excel        application vnd msexcel        text anytext        application octet-stream        application txt       if  in array   FILES  upload    type     csv mimetypes            possible CSV file        could also check for file content at this point

User · Answer

simple use  accept  and  required  in   and avoiding so much typical and unwanted coding

[php] Check file uploaded is in csv format

Examples related to php

Examples related to syntax

Examples related to file-upload

Examples related to content-type