csv上传到mysql php

<?php
$host = 'localhost';
$user = 'username';
$password = 'password';
$dbname = 'database_name';

// 创建连接
$conn = new mysqli($host, $user, $password, $dbname);

// 检查连接
if ($conn->connect_error) {
    die("连接失败: " . $conn->connect_error);
}

// 设置字符集
$conn->set_charset("utf8");

// 读取CSV文件
$csvFile = 'path_to_your_csv_file.csv';
if (($handle = fopen($csvFile, "r")) !== FALSE) {
    while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) {
        // 假设CSV文件有三列：col1, col2, col3
        $col1 = mysqli_real_escape_string($conn, $data[0]);
        $col2 = mysqli_real_escape_string($conn, $data[1]);
        $col3 = mysqli_real_escape_string($conn, $data[2]);

        // 插入数据到MySQL
        $sql = "INSERT INTO table_name (col1, col2, col3) VALUES ('$col1', '$col2', '$col3')";
        if (!$conn->query($sql)) {
            echo "插入失败: " . $sql . "<br>" . $conn->error . "<br>";
        }
    }
    fclose($handle);
}

echo "数据导入完成";

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