Pasted

<?php
require_once 'vendor/autoload.php';
require_once 'config.php';
 
use PhpOffice\PhpSpreadsheet\Spreadsheet;
use PhpOffice\PhpSpreadsheet\Writer\Xlsx;
 
$date = $_POST['date']; // Get the user-defined date from a form
 
// Fetch data from the "data_storage" table
$stmt = $conn->prepare("SELECT * FROM data_storage WHERE DATE(created_at) = :date");
$stmt->bindParam(':date', $date);
$stmt->execute();
$data = $stmt->fetchAll(PDO::FETCH_ASSOC);
 
$spreadsheet = new Spreadsheet();
$sheet = $spreadsheet->getActiveSheet();
 
// Write data to the spreadsheet
foreach ($data as $index => $row) {
    $sheet->fromArray(json_decode($row['register_data'], true), null, "A" . ($index + 1));
}
 
$writer = new Xlsx($spreadsheet);
$filename = "data_export_" . $date . ".xlsx";
$writer->save($filename);
 
header("Content-Type: application/vnd.ms-excel");
header("Content-Disposition: attachment; filename=\"$filename\"");
header("Cache-Control: max-age=0");
readfile($filename);
unlink($filename);
?>