javascript - 无法将php中的excel文件上传到mysql数据库

Question

我一直在尝试在 php 文件中构建一个部分，从中我可以将 excel 文件上传到数据库。我完成了所有的编码部分，但它不起作用。数据没有上传。所以请帮助我。

这是我的代码

这是我将使用 enctype="multipart/form-data" 上传 excel 文件的 html 部分：

<div class="panel panel-primary">

    <div class="panel-body">
    <form method="POST" action="uploads.php?y='.$y.'&m='.$m.'" style="margin-left: 100px;" enctype="multipart/form-data">
    <label for="fileToUpload">Select file to upload:
    <br/> <small style="color: red;">*Please attach only .xls & .xlsx files. 
   </small>
    </label>
<input class="form-control" type="file" name="fileToUpload" id="fileToUpload" style="width:300px; align: center;">
<br/>
<input class="btn btn-sm btn-info" type="submit" value="Upload File" name="submit">
    </form>
</div>

</div>

PHP 文件 uploads.php ：

然后将excel文件的数据发送到php文件以上传到数据库中，但这不起作用。

  require_once('vendor/php-excel-reader/excel_reader2.php');
    require_once('vendor/SpreadsheetReader.php');

    $y=$_GET['y'];
    $m=$_GET['m'];
    $year=$y.'_'.$m;

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

$allowedFileType = ['application/vnd.ms-excel','text/xls','text/xlsx','application/vnd.openxmlformats-officedocument.spreadsheetml.sheet'];

if(in_array($_FILES["file"]["type"],$allowedFileType))
{

    $targetPath = 'uploads/'.$_FILES['file']['name'];
    move_uploaded_file($_FILES['file']['tmp_name'], $targetPath);

    $Reader = new SpreadsheetReader($targetPath);

    $sheetCount = count($Reader->sheets());
    for($i=0;$i<$sheetCount;$i++)
    {
        $Reader->ChangeSheet($i);

        foreach ($Reader as $Row) {

            $date = "";
            if(isset($Row[0])) {
                $date = mysqli_real_escape_string($con,$Row[0]);
            }

            $janmin = "";
            if(isset($Row[1])) {
                $janmin = mysqli_real_escape_string($con,$Row[1]);
            }

            $janmax = "";
            if(isset($Row[2])) {
                $janmax = mysqli_real_escape_string($con,$Row[2]);
            }               

            $febmin = "";
            if(isset($Row[3])) {
                $febmin = mysqli_real_escape_string($con,$Row[3]);
            }

            $febmax = "";
            if(isset($Row[4])) {
                $febmax = mysqli_real_escape_string($con,$Row[4]);
            }

            $marmin = "";
            if(isset($Row[5])) {
                $marmin = mysqli_real_escape_string($con,$Row[5]);
            }

            $marmax = "";
            if(isset($Row[6])) {
                $marmax = mysqli_real_escape_string($con,$Row[6]);
            }

            $aprmin = "";
            if(isset($Row[7])) {
                $aprmin = mysqli_real_escape_string($con,$Row[7]);
            }

            $aprmax = "";
            if(isset($Row[8])) {
                $aprmax = mysqli_real_escape_string($con,$Row[8]);
            }

            $maymin = "";
            if(isset($Row[9])) {
                $maymin = mysqli_real_escape_string($con,$Row[9]);
            }

            $maymax = "";
            if(isset($Row[10])) {
                $maymax = mysqli_real_escape_string($con,$Row[10]);
            }

            $junemin = "";
            if(isset($Row[11])) {
                $junemin = mysqli_real_escape_string($con,$Row[11]);
            }

            $junemax = "";
            if(isset($Row[12])) {
                $junemax = mysqli_real_escape_string($con,$Row[12]);
            }

            $julymin = "";
            if(isset($Row[13])) {
                $julymin = mysqli_real_escape_string($con,$Row[13]);
            }

            $julymax = "";
            if(isset($Row[14])) {
                $julymax = mysqli_real_escape_string($con,$Row[14]);
            }

            $augmin = "";
            if(isset($Row[15])) {
                $augmin = mysqli_real_escape_string($con,$Row[15]);
            }

            $augmax = "";
            if(isset($Row[16])) {
                $augmax = mysqli_real_escape_string($con,$Row[16]);
            }

            $sepmin = "";
            if(isset($Row[17])) {
                $sepmin = mysqli_real_escape_string($con,$Row[17]);
            }

            $sepmax = "";
            if(isset($Row[18])) {
                $sepmax = mysqli_real_escape_string($con,$Row[18]);
            }

            $octmin = "";
            if(isset($Row[19])) {
                $octmin = mysqli_real_escape_string($con,$Row[19]);
            }

            $octmax = "";
            if(isset($Row[20])) {
                $octmax = mysqli_real_escape_string($con,$Row[20]);
            }

            $novmin = "";
            if(isset($Row[21])) {
                $novmin = mysqli_real_escape_string($con,$Row[21]);
            }

            $novmax = "";
            if(isset($Row[22])) {
                $novmax = mysqli_real_escape_string($con,$Row[22]);
            }

            $decmin = "";
            if(isset($Row[23])) {
                $decmin = mysqli_real_escape_string($con,$Row[23]);
            }

            $decmax = "";
            if(isset($Row[24])) {
                $decmax = mysqli_real_escape_string($con,$Row[24]);
            }

            if (!empty($date)) {
                $query = "INSERT INTO `$year` (janmin,janmax,febmin,febmax,marmin,marmax,aprilmin,aprilmax,maymin,maymax,junemin,junemax,julymin,julymax,augmin,augmax,sepmin,sepmax,octmin,octmax,novmin,novmax,decmin,decmax,user_id,date) 
 VALUES ('$janmin','$janmax','$febmin','$febmax','$marmin','$marmax','$aprmin','$aprmax','$maymin','$maymax','$junemin','$junemax','$julymin','$julymax','$augmin','$augmax','$sepmin','$sepmax','$octmin','$octmax','$novmin','$novmax','$decmin','$decmax','$user_id','$date')";
                $result = mysqli_query($con, $query);

                if (! empty($result)) {
                    $type = "success";
                    $message = "Excel Data Imported into the Database";
                    echo $type.'<br />'.$message;

                } else {
                    $type = "error";
                    $message = "Problem in Importing Excel Data";
                    echo $type.'<br />'.$message;
                }
            }



        }


    }
}
}

标签： javascriptphphtmlcss