芝麻web文件管理V1.00

编辑当前文件:/home/pulsehostuk9/public_html/teafund.pulsehost.co.uk/api/unpaid_list.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); $month = (int)($_GET['month'] ?? 0); $pdo = get_pdo(); header('Content-Type: text/plain'); header('Content-Disposition: attachment; filename="unpaid_list_'.$year.'_'.$month.'.txt"'); $stmt = $pdo->prepare("SELECT m.name, m.email FROM members m LEFT JOIN payments p ON p.member_id=m.id AND p.fund_id=? AND p.year=? AND p.month=? WHERE m.active=1 AND (p.status IS NULL OR p.status='unpaid') ORDER BY m.name"); $stmt->execute([$fund_id,$year,$month]); while ($r = $stmt->fetch()) { echo $r['name']; if (!empty($r['email'])) { echo ' <' . $r['email'] . '>'; } echo "\n"; } exit; ?>