如何上传CSV文件，才能将其发送到php以便php可以添加数组中的所有内容？

Question

我有如下代码：

Html：

<input type="file" name="filename" id="filename">

jQuery：

$("#filename").change(function(e) {
var url = $("input#filename").val();

 $.ajax({            
        type: "POST",
        url: "/importArticleCsv",
        dataType: "json",
        data: "url="+ url,
        success: function(response)
        {
            alert("succes");

        }
    });
    return false;

});

php：

public function importArticleCsv(){      
    $url = $this->input->post('url');

        $csv_file = CSV_PATH . $url; // Name of your CSV file

$csvfile = fopen($csv_file, 'r');

$theData = fgets($csvfile);

$i = 0;

while (!feof($csvfile)) {
    $csv_data[] = fgets($csvfile, 1024);
    $csv_array = explode(",", $csv_data[$i]);

    $insert_csv = array();
    $insert_csv['ID'] = $csv_array[0];
    $insert_csv['name'] = $csv_array[1];
    $insert_csv['email'] = $csv_array[2];

$i++;

}

fclose($csvfile);

}

我该如何上传CSV文件，才能将其发送到php以便php可以添加数组中的所有内容？上面的这些代码都会转到正确的函数，但是它们并不起作用——为什么？

Answer 1

You can't use the .val() from a file upload directly (for good privacy/security reasons, e.g. otherwise website would be able to traverse your entire computer).

Try letting the script make the form do a post request (effectively sending the file to the desired PHP file for processing).

Or have a look at: How can i upload a file using jquery's $.ajax function with json and php