prepare("SELECT name, email, points, created_at, role FROM users WHERE id = :id"); $stmt->bindParam(':id', $user_id, PDO::PARAM_INT); $stmt->execute(); $user = $stmt->fetch(PDO::FETCH_ASSOC); if (!$user) { // Handle user not found, though unlikely if session is set session_destroy(); header("location: login.php"); exit; } // Fetch user submissions $stmt_submissions = $db->prepare("SELECT item_type, quantity, points_awarded, submission_date FROM waste_submissions WHERE user_id = :user_id ORDER BY submission_date DESC"); $stmt_submissions->bindParam(':user_id', $user_id, PDO::PARAM_INT); $stmt_submissions->execute(); $submissions = $stmt_submissions->fetchAll(PDO::FETCH_ASSOC); ?> Dashboard - E-Waste Reclaimer

Welcome, !

Your Points

Keep recycling to earn more!

Total Submissions

Thank you for your contribution!

Your Submission History

You haven't made any submissions yet. Click the "Submit E-Waste" button to get started!

Date	Item Type	Quantity	Points Awarded