如何导入文件excel 2007到phpmyadmin使用php - How to import file excel 2007 into phpmyadmin using php?

How to import file excel 2007 into phpmyadmin using php?

如何使用php导入文件excel 2007到phpmyadmin ?我有一个大文件excel .xlsx格式(40MB)，我想导入此文件到phpmyadmin.

<?php
 if(isset($_POST['form_submit']))
 {
    include("db.php"); 
    require_once 'Classes/excel_reader.php';
    $file1 = $_FILES['excelfile']['tmp_name'];
    $data = new Spreadsheet_Excel_Reader($file1);
    $sheet = $data->sheets[0];
    $rows = $sheet['cells'];
    $rowCount = count($rows);

    for($i=2;$i<=$rowCount;$i++)
    {
        $name = $data->val($i,1);
        $email = $data->val($i,2);
        $password = $data->val($i,3);
        $sql = "insert into $tabel_name (`name`,`email`,`password`) values ('$name','$email','$password')";
mysql_query($sql);
    }
 }
 ?>
 <html>
      <head>
          <title>How To Import Excel (.xls) File To MySql Database Using PHP</title>
      </head>
      <body>
      <center><h1>zero-error-script.blogspot.in</h1></center>
      <form name="import_export_form" method="post" action="import.php" enctype="multipart/form-data">
      <label>Select Excel File : </label><input type="file" name="excelfile"/><br>
      <input type="submit" name="form_submit"/>
      </form>
      </body>
 </html>

下载完整示例及源代码