prepare("SELECT * FROM farmers WHERE id = ?"); $stmt->execute([$farmer_id]); $farmer = $stmt->fetch(PDO::FETCH_ASSOC); // Fetch applied schemes $stmt = $pdo->prepare(" SELECT s.id, s.name, s.description, a.application_date, a.status FROM applications a JOIN schemes s ON a.scheme_id = s.id WHERE a.farmer_id = ? ORDER BY a.application_date DESC "); $stmt->execute([$farmer_id]); $applied_schemes = $stmt->fetchAll(PDO::FETCH_ASSOC); ?> Dashboard - Smart Farmer

Welcome, !

This is your personal dashboard. Manage your applications and profile here.

My Profile

Edit

Name:

Email:

Phone:

District:

My Applications

You have not applied for any schemes yet. Explore schemes and apply now.
Applied on:

...

Status: