<?php
// Start the session and include database connection
session_start();
require 'config/db.php';

// Ensure the user is logged in (optional, depending on your system setup)
if (!isset($_SESSION['user_id'])) {
    header('Location: login.php');
    exit();
}

// Fetch all active alerts from the database
$stmt = $pdo->prepare("SELECT * FROM alerts WHERE status = 'active' ORDER BY timestamp DESC");
$stmt->execute();

// Fetch the result
$alerts = $stmt->fetchAll(PDO::FETCH_ASSOC);

// Return the alerts as a JSON response
echo json_encode($alerts);
?>