使用PHP在按下按钮时将SQL表导出到Excel

<?php
require 'path/to/PHPExcel.php';

// 连接到数据库
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "database";
$conn = new mysqli($servername, $username, $password, $dbname);

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

// 执行SQL查询
$sql = "SELECT * FROM your_table";
$result = $conn->query($sql);

// 创建Excel对象
$objPHPExcel = new PHPExcel();
$objPHPExcel->getActiveSheet()->setTitle('Sheet1');

// 将查询结果插入Excel中
$row = 1;
while ($row_data = $result->fetch_assoc()) {
    $col = 0;
    foreach ($row_data as $value) {
        $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col, $row, $value);
        $col++;
    }
    $row++;
}

// 导出Excel文件
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');
$objWriter->save('path/to/save/file.xlsx');

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