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(); }
SAVE
CANCEL