将数据从CSV文件导入PHP

$file = fopen('data.csv', 'r');

while (($data = fgetcsv($file)) !== false) {
    // 处理每行数据
}

// 示例：将数据存储到数据库中
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "database";

$conn = new mysqli($servername, $username, $password, $dbname);

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

// 处理每行数据
while (($data = fgetcsv($file)) !== false) {
    $name = $data[0];
    $age = $data[1];
    $email = $data[2];

    // 执行插入操作
    $sql = "INSERT INTO users (name, age, email) VALUES ('$name', '$age', '$email')";
    $conn->query($sql);
}

$conn->close();

fclose($file);