php - 使用php读取.xlsx文件并写入数据库

Question

我想在我的项目中使用 PHPExcel 从一台服务器读取 xlsx 文件并将数据写入另一台服务器的数据库(phpmyadmin)中。我对 php 不太了解，我需要有人帮助我。而且我不知道如何连接到该服务器:(我的代码在这里有一些错误:

<?php
  $con = mysql_connect("localhost","root","");


        if (!$con)
        {
            die('Could not connect: ' . mysql_error());
            }
  mysql_select_db("osweh", $con);

  require_once 'PHPExcel.php';
  $objReader = PHPExcel_IOFactory::createReader('Excel2007');
  $objReader->setReadDataOnly(true);

  $objPHPExcel = $objReader->load("Book1.xlsx");
  $objWorksheet = $objPHPExcel->getActiveSheet();

  $highestRow = $objWorksheet->getHighestRow(); 
  $highestColumn = $objWorksheet->getHighestColumn(); 

  $highestColumnIndex = PHPExcel_Cell::columnIndexFromString($highestColumn); 

  $rows = array();
  for ($row = 2; $row <= $highestRow; ++$row) {
    for ($col = 0; $col <= $highestColumnIndex; ++$col) {
      $rows[$col] = mysql_real_escape_string($objWorksheet->getCellByColumnAndRow($col, $row)->getValue());

     }

     mysql_query("INSERT INTO xlsx ('f1','f2','f3','f4') VALUES ($rows[1],$rows[2],$row[3],$row[4]);");
    echo mysql_error;
  }

     mysql_close($con);
 ?>

Answer 1

尝试改变

mysql_query("INSERT INTO xlsx ('f1','f2','f3','f4') VALUES ($rows[1],$rows[2],$row[3],$row[4]);");
echo mysql_error;

至

$result = mysql_query("INSERT INTO xlsx ('f1','f2','f3','f4') VALUES ($rows[1],$rows[2],$row[3],$row[4]);");
if ($result === false) {
    die('Invalid query: ' . mysql_error());
}

它可以帮助您在插入不正确的数据时看到错误