<?php
ini_set('display_errors', 1);
ini_set('display_startup_errors', 1);
error_reporting(E_ALL);
function db_connect(): PDO {
    $dsn = 'mysql:host=' . DB_HOST . ';dbname=' . DB_NAME . ';charset=utf8mb4';
    $pdo = new PDO($dsn, DB_USER, DB_PASS, [
        PDO::ATTR_ERRMODE            => PDO::ERRMODE_EXCEPTION,
        PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC,
    ]);
    return $pdo;
}
// Set headers to return clean JSON data
header('Content-Type: application/json');

// Ensure you only run this if a state ID is provided
if (isset($_GET['state_id'])) {
    $state_id = $_GET['state_id'];

    // Assuming your db_connect function is accessible here
    // require_once 'db.php'; 
    require_once("config.php");
    $pdo = db_connect(); 

    // Use prepared statements to prevent SQL injection
    $stmt = $pdo->prepare("SELECT id, district_name FROM districts WHERE state_id = :state_id"); 
    $stmt->execute(['state_id' => $state_id]);
    
    $districts = $stmt->fetchAll(PDO::FETCH_ASSOC);

    // Convert the database array directly into a JSON string
    echo json_encode($districts);
    exit;
}

// Return an empty array if no ID was provided
echo json_encode([]);