prepare(" SELECT fl.*, u.name AS restaurant_name FROM food_listings fl JOIN users u ON fl.user_id = u.id WHERE fl.status = 'listed' ORDER BY fl.pickup_deadline ASC "); $stmt_available->execute(); $available_listings = $stmt_available->fetchAll(PDO::FETCH_ASSOC); // Fetch listings claimed by the current NGO $stmt_claimed = $pdo->prepare(" SELECT fl.*, u.name AS restaurant_name FROM food_listings fl JOIN users u ON fl.user_id = u.id WHERE fl.status = 'claimed' AND fl.claimed_by_id = ? ORDER BY fl.pickup_deadline ASC "); $stmt_claimed->execute([$ngo_id]); $claimed_listings = $stmt_claimed->fetchAll(PDO::FETCH_ASSOC); ?>

NGO Dashboard

Logout

Welcome, ! Here are the current listings.

Donation claimed successfully! You can see it in your claimed donations list below.
There was an error. The donation might have already been claimed.

My Claimed Donations

You have not claimed any donations yet.
Claimed
From:

  • Pickup By:

Available Food Donations

There are no available food donations at the moment. Please check back later.
From:

  • Quantity:
  • Pickup By:
Claim Donation