<?php
header('Content-Type: application/json');
include '../includes/session_control.php';
include '../db/db.php'; // Asegúrate de que tienes una conexión a la base de datos aquí

$idDepartamento = $_GET['idDepartamento'];

$query = "SELECT id, nombre FROM tb_ciudades WHERE idDepartamento = ? ORDER BY nombre";
$stmt = $conn->prepare($query);
$stmt->bind_param("i", $idDepartamento);
$stmt->execute();
$result = $stmt->get_result();

$cities = [];
while ($row = $result->fetch_assoc()) {
    $cities[] = $row;
}

echo json_encode($cities);

$stmt->close();
$conn->close();
?>