prepare("SELECT * FROM blood_stock");
$stmt->execute();
$result = $stmt->get_result();
if ($result->num_rows > 0) {
while($row = $result->fetch_assoc()) {
$units = $row["totalUnits"];
if ($units == 0) {
$status_class = 'status-depleted';
$status_text = 'Critical Depletion';
} elseif ($units < 5) {
$status_class = 'status-deficit';
$status_text = 'Biological Deficit';
} else {
$status_class = 'status-equilibrium';
$status_text = 'Genetic Equilibrium';
}
echo '
';
echo '
' . htmlspecialchars($row["bloodGroup"]) . '
';
echo '
' . htmlspecialchars($units) . ' Units Available
';
echo '
' . $status_text . '
';
echo '
';
}
} else {
echo '
No stock data currently available.
';
}
?>