php把表格导入mysql数据库中

<?php
// 解析表格数据
$filename = 'example.csv';
$data = array_map('str_getcsv', file($filename));
$headers = $data[0];
$rows = array_slice($data, 1);

// 连接到MySQL数据库
$servername = 'localhost';
$username = 'root';
$password = 'password';
$dbname = 'database';
$conn = new mysqli($servername, $username, $password, $dbname);

// 创建表
$tableName = 'example_table';
$createTableQuery = "CREATE TABLE IF NOT EXISTS $tableName (";
foreach ($headers as $header) {
    $createTableQuery .= "`$header` VARCHAR(255), ";
}
$createTableQuery = rtrim($createTableQuery, ', ');
$createTableQuery .= ")";
$conn->query($createTableQuery);

// 插入数据
$insertQuery = "INSERT INTO $tableName (";
foreach ($headers as $header) {
    $insertQuery .= "`$header`, ";
}
$insertQuery = rtrim($insertQuery, ', ');
$insertQuery .= ") VALUES ";
foreach ($rows as $row) {
    $insertQuery .= "(";
    foreach ($row as $value) {
        $insertQuery .= "'$value', ";
    }
    $insertQuery = rtrim($insertQuery, ', ');
    $insertQuery .= "), ";
}
$insertQuery = rtrim($insertQuery, ', ');
$conn->query($insertQuery);

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