芝麻web文件管理V1.00

编辑当前文件:/home/pulsehostuk9/public_html/teafund.pulsehost.co.uk/api/export_csv.php
<?php require_once __DIR__ . '/../includes/auth.php'; require_once __DIR__ . '/../includes/db.php'; require_manage(); $fund_id = (int)($_GET['fund_id'] ?? 0); $year = (int)($_GET['year'] ?? 0); $pdo = get_pdo(); $fund = $pdo->prepare("SELECT name FROM funds WHERE id=?"); $fund->execute([$fund_id]); $fund_name = $fund->fetchColumn() ?: 'fund'; header('Content-Type: text/csv'); header('Content-Disposition: attachment; filename="payments_'.$fund_name.'_'.$year.'.csv"'); $out = fopen('php://output', 'w'); fputcsv($out, ['Member ID','Name','Email','Month','Status']); $stmt = $pdo->prepare("SELECT m.id, m.name, m.email, p.month, p.status FROM members m LEFT JOIN payments p ON p.member_id=m.id AND p.year=? AND p.fund_id=? WHERE m.active=1 ORDER BY m.name, p.month"); $stmt->execute([$year,$fund_id]); while ($row = $stmt->fetch()) { fputcsv($out, [$row['id'],$row['name'],$row['email'],$row['month'],$row['status'] ?: 'unpaid']); } fclose($out); exit; ?>