File "fetch_area.php"

Full Path: C:/wamp64/www/PERSONAL/Personal/fetch_area.php
File size: 801 bytes
MIME-type: text/x-php
Charset: utf-8

<?php
// Incluir el archivo de conexión
include('../connection.php');

// Término de búsqueda de Select2
$search = isset($_GET['q']) ? $_GET['q'] : '';
$search_term = "%" . $search . "%";

// Query para obtener Áreas
$sql = "SELECT id, area 
        FROM area 
        WHERE area LIKE ?
        ORDER BY area ASC";

$stmt = $con->prepare($sql);
$stmt->bind_param('s', $search_term);
$stmt->execute();
$result = $stmt->get_result();

$data = [];
while ($row = $result->fetch_assoc()) {
    $data[] = [
        'id'   => $row['area'],   // Se guarda el nombre del área
        'text' => $row['area']    // Lo que se muestra al usuario
    ];
}

$stmt->close();
mysqli_close($con);

header('Content-Type: application/json');
echo json_encode(['results' => $data]);
?>