使用php将excel/ csv文件导入phpmyadmin

<?php
require_once 'PHPExcel/Classes/PHPExcel.php';

// 打开Excel文件
$excelFile = 'path/to/your/excel/file.xlsx';
$excelReader = PHPExcel_IOFactory::createReaderForFile($excelFile);
$excelObj = $excelReader->load($excelFile);

// 选择第一个工作表
$worksheet = $excelObj->getSheet(0);

// 获取行数和列数
$highestRow = $worksheet->getHighestRow();
$highestColumn = $worksheet->getHighestColumn();

// 循环读取数据
$data = array();
for ($row = 1; $row <= $highestRow; $row++) {
    $rowData = $worksheet->rangeToArray('A' . $row . ':' . $highestColumn . $row, null, true, false);
    $data[] = $rowData[0];
}

// 连接到数据库
$servername = 'your_servername';
$username = 'your_username';
$password = 'your_password';
$dbname = 'your_dbname';

$conn = new mysqli($servername, $username, $password, $dbname);
if ($conn->connect_error) {
    die('连接数据库失败：' . $conn->connect_error);
}

// 插入数据到数据库表
foreach ($data as $row) {
    $sql = "INSERT INTO your_table (column1, column2, column3) VALUES ('" . $row[0] . "', '" . $row[1] . "', '" . $row[2] . "')";
    if ($conn->query($sql) !== true) {
        echo '插入数据失败：' . $conn->error;
    }
}

// 关闭数据库连接
$conn->close();

echo '数据导入成功！';
?>