文件上传错误“application / octet-stream”

Question

我不是很精通 PHP，我用以下的PHP代码上传一个csv文件却怎么都实现不了。我已经修复了上传最大尺寸等相关属性的问题。其在我的本地网站上运行良好，但在沙盒网站上就不行了。错误：“ application / octet-stream”。 我该怎么办？

数据非常简单，以.csv 格式存储：

27589   16990   161.7000095 0.838494
27589   17067   161.7000095 0.838494
27820   17144   315.7000095 0.859458
27820   17221   315.7000095 0.859458
27820   17606   315.7000095 0.866033
27820   17683   315.7000095 0.866033

错误输出： "-- CSV file to load: Invalid type: application/octet-stream"

<?php
ini_set('display_errors', 1); error_reporting(E_ALL);

// using upload at click from http://code.google.com/p/upload-at-click/
// FileData is the name for the input file

$file_result = "";
$file = $_FILES['Filedata'];

$allowedExtensions = array("csv", "txt");
$arrayVar = explode(".", $file["name"]);
$extension = end($arrayVar);

//commented out for strict standard error
//$extension = end(explode(".", $file["name"]));


function isAllowedExtension($fileName) {
    global $allowedExtensions;
    return in_array(end(explode(".", $fileName)), $allowedExtensions);
}

if($file["error"] > 0){
    echo "failure to upload the file >>> ". "Error code: ".$file["error"]."<br>";
}else{
    //echo " >>> CURRENT DIR: ".getcwd() . "
";
    $workDir = getcwd();

    $dir = substr($workDir, 0, -10);
    $path = $file["name"];
    $newFileLoc = $dir.$path;

    $file_result.=
    "<br>     Upload: " . $file["name"] . "<br>" .
    "     Type: " . $file["type"] . "<br>" .
    "     Size: " . $file["size"] . "<br>" .
    "     file uploaded to: ".$newFileLoc."<br>";

    // txt - text/plain
    // rtf - application/msword
    // dat/obj - application/octet-stream
    // csv - application/vnd.ms-excel
    // maximum 200 MB file - 200,000,000 k

    if ($file["type"] == "application/vnd.ms-excel" || $file["type"] == "text/plain"){
        if( isAllowedExtension($file["name"]) )
        {
            if( $file["size"] < 200000000 )
            {
                move_uploaded_file($file["tmp_name"], $newFileLoc);
                echo "|".$path;//"filePath : " . $newFileLoc;
            }
            else
            {
                echo "Invalid file size: " . $file["size"] . "
";   
            }
        }
        else 
        {   
            echo "Invalid extension: " . $file["name"]."
";
        }
    }
    else
    {
        echo "Invalid type: " . $file["type"] . "
";
    }
}
?>

Answer 1

Try the last piece of code like this, as $file['type'] is set by the client, not the server. Should be fine this way. Make sure to upload the files in a location unreachable to public.

<?php // txt - text/plain
// rtf - application/msword
// dat/obj - application/octet-stream
// csv - application/vnd.ms-excel
// maximum 200 MB file - 200,000,000 k

//if ($file["type"] == "application/vnd.ms-excel" || $file["type"] == "text/plain"){
    if( isAllowedExtension($file["name"]) )
    {
        if( $file["size"] < 200000000 )
        {
            //try to read the first line with a csv reader

             $handle = fopen( $file["tmp_name"], "r");
            if( $data = fgetcsv($handle)) !== false) {
             if( count( $data ) > 1 ){ //Set 1 to the number of fields - 1

               move_uploaded_file($file["tmp_name"], $newFileLoc);
               echo "|".$path;//"filePath : " . $newFileLoc;
             }
              else{
               echo "Error: Cannot load file, not a CSV file";   
             }

            }else{
             echo "Error: File not uploaded
";  //should never happen  
            }
        }
        else
        {
            echo "Invalid file size: " . $file["size"] . "
";   
        }
    }
    else 
    {   
        echo "Invalid extension: " . $file["name"]."
";
    }
}
//else
//{
//    echo "Invalid type: " . $file["type"] . "
";
//}
}