~NAXC~

File Content: `export_xls.php`

<?php
include("new_con.php"); // Ensure this file contains a valid PDO connection in $sqlfun

// Set headers for XLS download
header("Content-Type: application/vnd.ms-excel");
header("Content-Disposition: attachment; filename=exported_data.xls");

// Start output buffer
echo "<table border='1'>";

// Fetch data from the database
$sql = "SELECT * FROM enquiry";
$stmt = $sqlfun->query($sql);

// Fetch column names dynamically
if ($stmt->rowCount() > 0) {
    $firstRow = $stmt->fetch(PDO::FETCH_ASSOC);
    $columns = array_keys($firstRow);
    
    // Print column headers
    echo "<tr><th>" . implode("</th><th>", $columns) . "</th></tr>";

    // Print first row data
    echo "<tr><td>" . implode("</td><td>", $firstRow) . "</td></tr>";

    // Fetch and print remaining rows
    while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
        echo "<tr><td>" . implode("</td><td>", $row) . "</td></tr>";
    }
}

echo "</table>";
exit();
?>
File Content: export_xls.php

File Content: `export_xls.php`
