在LOAD DATA LOCAL INFILE PHP中使用变量

<?php
$filename = '/path/to/file.csv'; // 可以通过变量来指定文件路径

// 建立数据库连接
$conn = mysqli_connect("localhost", "username", "password", "database");

// 检查连接是否成功
if (!$conn) {
    die("连接失败: " . mysqli_connect_error());
}

// 使用LOAD DATA LOCAL INFILE导入数据
$query = "LOAD DATA LOCAL INFILE '" . mysqli_real_escape_string($conn, $filename) . "' INTO TABLE table_name FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n'";

if (mysqli_query($conn, $query)) {
    echo "数据导入成功";
} else {
    echo "数据导入失败: " . mysqli_error($conn);
}

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