php - PHP - 无法导入 CSV

Question

我遵循了一个教程，但尝试在工作时对其进行编辑。我无法让我的数据从 csv 传输到我不断获取的数据库，导入时出现问题，但无法弄清楚原因

希望有人能帮忙

<?php
$conn = mysqli_connect("localhost", "admin", "password", "cards");

if (isset($_POST["import"])) {

    $fileName = $_FILES["file"]["tmp_name"];

    if ($_FILES["file"]["size"] > 0) {

        $file = fopen($fileName, "r");

        while (($column = fgetcsv($file, 10000, ",")) !== FALSE) {
            $sqlInsert = "INSERT into `cards` (`number`,`status`) values ('" . $column[1] . "','" . $column[2] . "')";

            $result = mysqli_query($conn, $sqlInsert);

            if (! empty($result)) {
                $type = "success";
                $message = "CSV Data Imported into the Database";
            } else {

                $type = "error";
                $message = "Problem in Importing CSV Data";
            }
        }
    }
}

?>

标签： php