我正在尝试将字段上传到 mysql 数据库。该字段可以由用户手动输入或上传包含该字段的 .csv 文件上传。手动输入效果很好，但是当我尝试使用 .csv 上传时，它看不到文件并跳到我的代码的“其他”部分。这是我的代码:

<?php
    $classname = $_POST['classname'];
    $classname = stripslashes($classname);
    $classname = mysql_real_escape_string($classname);


    $save = $_POST['save'];
    $save = stripslashes($save);
    $save = mysql_real_escape_string($save);


    $myfile = $_POST['myfile'];
    $myfile = stripslashes($myfile);
    $myfile = mysql_real_escape_string($myfile);


    $import = $_POST['import'];
    $import = stripslashes($import);
    $import = mysql_real_escape_string($import);

    if($classname && $save)
    {
        $choose_db;
        $sql="INSERT INTO classes (`class`) VALUES ('$classname')";
        $res=mysql_query($sql, $connect) or die (mysql_error());

        if ($res)
        {
            echo "<script type='text/javascript'>
                    alert('Class added succefully');
                    window.location='../classes.php'
                </script>";
        }
        else
        {
            echo "<script type=text/javascript'>
                    alert('Class not added');
                    window.location('../classes.php');
                </script";
        }
    }




    elseif ($import && $myfile)
    {
        echo $filename = $_FILES["file"]["tmp_name"];

        if ($_FILES["file"]["size"] > 0)
        {
            $thefile=fopen($filename, "r");

            while (($thedata = fgetcsv($thefile, 10000, ",")) !== FALSE)
            {
                $sql_file="INSERT INTO classes (`class`) VALUES ('$thedata[1]')";
                $res_file=mysql_query($sql_file, $connect) or die (mysql_error());

                if (!$res_file)
                {
                    echo "<script type='text/javascript'>
                                alert ('Invalid file type!');
                                window.location = '../classes.php';
                        </script>                   
                    ";
                }
            }

            fclose($thefile);

            echo "<script type='text/javascript'>
                        alert ('File Imported Successfully!');
                        window.location = '../classes.php';
                    </script>                   
            ";

        }
    }




    else
    {
        echo "<script type='text/javascript'>
                        alert('Fill the form or choose a CSV file');
                        window.location='../classes.php'
                </script>";
    }


?>

这是html表单

<form class="form-horizontal" method="post" name="addclass" action="popups/saveclass.php">

    <div style="margin:5px" class="form-group">
        <label class="col-sm-12">New Class Name:</label>
        <div class="col-sm-12">
            <input type="text" name="classname" class="form-control" placeholder="Class Name" />
        </div>
    </div>

    <center><input type="submit" name="save" value="Save" id="submit" style="width:200px; height:30px; font-family:'Trebuchet MS', Arial, Helvetica, sans-serif; color:#002435; font-size:14px; cursor:pointer"/>
    </center>
</form> 

<form class="form-horizontal" method="post" name="uploadcsv" action="popups/saveclass.php" enctype="multipart/form-data">
    <br /><center>Or Upload CSV file</center><br />


    <div style="margin:5px" class="form-group">

        <div class="col-sm-12">
            <input type="file" name="myfile" class="form-control" />
        </div>
    </div>

    <center><input type="submit" name="import" value="Import" style="width:200px; height:30px; font-family:'Trebuchet MS', Arial, Helvetica, sans-serif; color:#002435; font-size:14px; cursor:pointer"/></center>

</form> 

最佳答案

文件上传仅在 $_FILES 中，而不是在 $_POST 中。所以 $myfile =$_POST['myfile'];不会做任何事情，摆脱与 $myfile` 相关的一切。

不需要在 $_POST['import'] 上调用 stripslashes 或 mysql_real_escape_string，因为您没有将它存储在数据库。

您使用 $_FILES['file']，但该输入的名称是 myfile，因此它应该是 $_FILES['myfile'] 。

所以代码应该是:

elseif (isset($_POST['import'], $_FILES['myfile'])) {
    echo $filename = $_FILES["myfile"]["tmp_name"];
    if ($_FILES["myfile"]["size"] > 0)
    {
        ...
    }
}

关于php - 上传时看不到 .csv 文件，我们在Stack Overflow上找到一个类似的问题： https://stackoverflow.com/questions/27666428/