prepare($sql); $stmt->execute($params); $requests = $stmt->fetchAll(PDO::FETCH_ASSOC); } catch (PDOException $e) { die("Database error: " . $e->getMessage()); } function getStatusColor($status) { switch ($status) { case 'Draft': return 'grey'; case 'Pending Approval': return 'orange'; case 'Approved': return 'green'; case 'Rejected': return 'red'; case 'In Progress': return 'blue'; case 'Completed': return 'purple'; default: return 'black'; } } ?>