上传csv文件到数据库- php [duplicate]

56lgkhnf  于 2023-03-21  发布在  PHP
关注(0)|答案(1)|浏览(147)

此问题在此处已有答案

(29个答案)
三年前关闭了。
这是我的代码。我得到错误“注意:未定义的偏移:9”。如果我有直到$item9它的工作,但我想实际上有直到$item13。

if(isset($_POST["submit"]))
{
    if($_FILES['file']['name'])
    {
        $filename = explode(".", $_FILES['file']['name']);
        if($filename[1] == 'csv')
        {
            $handle = fopen($_FILES['file']['tmp_name'], "r");
            while($data = fgetcsv($handle))
            {
                $item1 = mysqli_real_escape_string($connect, $data[0]);
                $item2 = mysqli_real_escape_string($connect, $data[1]);
                $item3 = mysqli_real_escape_string($connect, $data[2]);
                $item4 = mysqli_real_escape_string($connect, $data[3]);
                $item5 = mysqli_real_escape_string($connect, $data[4]);
                $item6 = mysqli_real_escape_string($connect, $data[5]);
                $item7 = mysqli_real_escape_string($connect, $data[6]);
                $item8 = mysqli_real_escape_string($connect, $data[7]);
                $item9 = mysqli_real_escape_string($connect, $data[8]);
                $item10 = mysqli_real_escape_string($connect, $data[9]);

                $query = "INSERT into tab1(country, jan, feb,mar,apr,may,jun,jul,aug) values('$item1','$item2','$item3','$item4','$item5','$item6','$item7','$item8','$item9','$item10')";
                mysqli_query($connect, $query);
            }
            fclose($handle);
8i9zcol2

8i9zcol21#

你在最后一条评论中回答了自己的问题。所以照你说的做--例如,像这样替换每一个项目行:

$item1 = array_key_exists(0, $data) ? mysqli_real_escape_string($connect, $data[0]) : '0';

相关问题