PHP如何实现数据导出_PHP数据导出Excel或CSV的方法与代码实例

// 示例数据
$data = [
    ['姓名', '年龄', '城市'],
    ['张三', '28', '北京'],
    ['李四', '32', '上海'],
    ['王五', '25', '广州']
];

// 设置响应头
header('Content-Type: text/csv; charset=utf-8');
header('Content-Disposition: attachment; filename=data.csv');

// 打开输出流
$output = fopen('php://output', 'w');

// 输出BOM防止乱码（Excel识别UTF-8）
fprintf($output, "\xEF\xBB\xBF");

// 写入数据
foreach ($data as $row) {
    fputcsv($output, $row);
}

// 关闭输出流
fclose($output);
exit;

composer require phpoffice/phpspreadsheet

require_once 'vendor/autoload.php';

use PhpOffice\PhpSpreadsheet\Spreadsheet;
use PhpOffice\PhpSpreadsheet\Writer\Xlsx;

// 创建工作簿
$spreadsheet = new Spreadsheet();
$sheet = $spreadsheet->getActiveSheet();

// 填充数据
$data = [
    ['姓名', '年龄', '城市'],
    ['张三', 28, '北京'],
    ['李四', 32, '上海'],
    ['王五', 25, '广州']
];

$rowIndex = 1;
foreach ($data as $row) {
    $colIndex = 'A';
    foreach ($row as $cell) {
        $sheet->setCellValue($colIndex . $rowIndex, $cell);
        $colIndex++;
    }
    $rowIndex++;
}

// 设置响应头
header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
header('Content-Disposition: attachment;filename="data.xlsx"');
header('Cache-Control: max-age=0');

// 输出文件
$writer = new Xlsx($spreadsheet);
$writer->save('php://output');
exit;

// 假设已连接数据库 $pdo
$sql = "SELECT name, age, city FROM users";
$stmt = $pdo->query($sql);

header('Content-Type: text/csv; charset=utf-8');
header('Content-Disposition: attachment; filename=users.csv');

$output = fopen('php://output', 'w');
fprintf($output, "\xEF\xBB\xBF"); // UTF-8 BOM

// 写入表头
fputcsv($output, ['姓名', '年龄', '城市']);

// 写入数据行
while ($row = $stmt->fetch(PDO::FETCH_NUM)) {
    fputcsv($output, $row);
}

fclose($output);
exit;