<?php
require_once 'db.php';
session_start();
$user_id = $_SESSION['user_id'];

$status = $_GET['status'] ?? 'pending';

$sql = "SELECT * FROM tasks WHERE user_id = ? AND status = ? ORDER BY created_at DESC";
$stmt = $conn->prepare($sql);
$stmt->bind_param("is", $user_id, $status);
$stmt->execute();
$result = $stmt->get_result();

$tasks = [];
while ($row = $result->fetch_assoc()) {
    $tasks[] = $row;
}

echo json_encode($tasks);
?>