CORE_V5 // vfa

PATH: home / u865795251 / domains / whatisnewis.com / public_html / vfa /

Editing: export-csv.php

<?php
require_once __DIR__ . '/db.php';
session_start();

if (!isset($_SESSION['authenticated']) || $_SESSION['authenticated'] !== true) {
    http_response_code(403);
    echo 'Unauthorized access.';
    exit;
}

try {
    header('Content-Type: text/csv; charset=utf-8');
    header('Content-Disposition: attachment; filename=webinar_registrations_' . date('Y-m-d') . '.csv');

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

// Add dynamic columns
    fputcsv($output, [
        'ID', 'Name', 'Email', 'Phone', 'Country Code', 
        'Goal Message', 'Call Reminder Support', 'Subtotal (INR)', 
        'GST Amount (INR)', 'Total Paid (INR)', 'Order ID', 
        'Payment ID', 'Payment Status', 'Registration Date'
    ]);

$stmt = $db->query("SELECT * FROM users ORDER BY id DESC");
    while ($row = $stmt->fetch()) {
        fputcsv($output, [
            $row['id'],
            $row['name'],
            $row['email'],
            $row['phone'],
            $row['country_code'],
            $row['message'],
            $row['reminder_added'] == 1 ? 'Yes' : 'No',
            $row['subtotal'],
            $row['gst_amount'],
            $row['amount_paid'],
            $row['razorpay_order_id'],
            $row['payment_id'],
            $row['payment_status'],
            $row['date']
        ]);
    }

fclose($output);

} catch (Exception $e) {
    http_response_code(500);
    echo 'Export failed: ' . $e->getMessage();
}

CANCEL