php下载数据库

header('Content-Type: application/octet-stream');
header('Content-Disposition: attachment; filename="data.csv"');
header('Expires: 0');
header('Cache-Control: must-revalidate');
header('Pragma: public');
header('Content-Length: ' . filesize($file_path));
readfile($file_path);

<?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);
}

// SQL查询语句
$sql = 'SELECT * FROM table_name';

// 执行查询
$result = $conn->query($sql);

// 检查查询结果
if ($result->num_rows > 0) {
    // 创建CSV文件并写入数据
    $file_path = 'data.csv';
    $file = fopen($file_path, 'w');
    if ($file === false) {
        die('无法创建文件');
    }
    while ($row = $result->fetch_assoc()) {
        fputcsv($file, $row);
    }
    fclose($file);

    // 设置HTTP头信息以提供文件下载
    header('Content-Type: text/csv');
    header('Content-Disposition: attachment; filename="data.csv"');
    header('Expires: 0');
    header('Cache-Control: must-revalidate');
    header('Pragma: public');
    header('Content-Length: ' . filesize($file_path));
    readfile($file_path);
} else {
    echo '没有数据可供导出';
}

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