prepare(" SELECT COUNT(*) as total, SUM(CASE WHEN current_status = 'pending' THEN 1 ELSE 0 END) as pending, SUM(CASE WHEN current_status = 'completed' THEN 1 ELSE 0 END) as completed FROM replacement_requests WHERE user_id = ? "); $stats->execute([$user_id]); $s = $stats->fetch(); // 2. Fetch User's Requests (Newest first) $stmt = $pdo->prepare("SELECT * FROM replacement_requests WHERE user_id = ? ORDER BY created_at DESC"); $stmt->execute([$user_id]); $requests = $stmt->fetchAll(); ?>

Total Requests

Pending

Completed

My Replacement List

Add New Customer

0): ?>

ID	Customer Name	Replacing Email	Plan	Status	Date
#
No requests found. Start by adding one!