✏ 编辑: export_kundli.php

<?php
// Database configuration
$servername = "localhost";
$username = "askmanisha_newuser";
$password = "Webgennie@developers";
$dbname = "askmanisha_astrology_site";

$conn = new mysqli($servername, $username, $password, $dbname);

if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

// Fetch all kundli requests
$sql = "SELECT * FROM kundli_requests ORDER BY created_at DESC";
$result = $conn->query($sql);

// Set headers for CSV download
header('Content-Type: text/csv; charset=utf-8');
header('Content-Disposition: attachment; filename=kundli_requests_' . date('Y-m-d') . '.csv');

// Create output stream
$output = fopen('php://output', 'w');

// Add BOM to fix UTF-8 in Excel
fprintf($output, chr(0xEF).chr(0xBB).chr(0xBF));

// Add column headers
fputcsv($output, [
    'ID',
    'Name',
    'Birth Date',
    'Birth Month',
    'Birth Year',
    'Birth Hour',
    'Birth Minute',
    'Birth City',
    'Timezone Hour',
    'Timezone Minute',
    'Latitude Deg',
    'Latitude Min',
    'Longitude Deg',
    'Longitude Min',
    'DTS',
    'Wartime',
    'IP Address',
    'Created At'
]);

// Add data rows
if ($result->num_rows > 0) {
    while($row = $result->fetch_assoc()) {
        fputcsv($output, [
            $row['id'],
            $row['name'],
            $row['birth_date'],
            $row['birth_month'],
            $row['birth_year'],
            $row['birth_hour'],
            $row['birth_minute'],
            $row['birth_city'],
            $row['timezone_hour'],
            $row['timezone_minute'],
            $row['latitude_deg'],
            $row['latitude_min'],
            $row['longitude_deg'],
            $row['longitude_min'],
            $row['dts'],
            $row['wartime'],
            $row['ip_address'],
            $row['created_at']
        ]);
    }
}

fclose($output);
$conn->close();
exit;
?>

[X] 取消