prepare("SELECT * FROM users WHERE id = ?");
$stmt->execute([$userId]);
$user = $stmt->fetch();
// Fetch shortage predictions
$stmt = $pdo->prepare("SELECT * FROM shortage_predictions WHERE user_id = ? ORDER BY days_to_shortage ASC");
$stmt->execute([$userId]);
$predictions = $stmt->fetchAll();
// Prepare data for the chart
$prediction_labels = [];
$prediction_data = [];
foreach ($predictions as $prediction) {
$prediction_labels[] = $prediction['medicine_name'];
$prediction_data[] = $prediction['days_to_shortage'];
}
?>
Shortage Predictions - Kotkakey
Shortage Predictions
