query("SELECT id, name, client, start_date, status FROM projects ORDER BY created_at DESC");
$projects = $stmt->fetchAll(PDO::FETCH_ASSOC);
} catch (PDOException $e) {
// For a real app, log this error and show a friendly message.
$error_message = "Error fetching projects: " . $e->getMessage();
}
function getStatusClass($status) {
switch (strtolower($status)) {
case 'in progress':
return 'status-in-progress';
case 'completed':
return 'status-completed';
case 'not started':
default:
return 'status-not-started';
}
}
?>
Dashboard - ConstructApp
Projects
Project added successfully!
Project Name
Client
Start Date
Status
No projects yet. Click "Add New Project" to get started!