File "get_items.php"

Full Path: C:/wamp64/www/loteo/get_items.php
File size: 569 bytes
MIME-type: text/x-php
Charset: utf-8

<?php
require_once 'connection.php';
header('Content-Type: application/json');

$beneficio = $_GET['beneficio'] ?? '';

if ($beneficio === 'Beneficio Pollo') {
    $tabla = 'items';
} elseif ($beneficio === 'Beneficio Pavo') {
    $tabla = 'items_Pavos';
} else {
    echo json_encode(['error' => 'beneficio no válido']);
    exit;
}

$conn = connection();
$result = $conn->query("SELECT item, descripcion FROM $tabla ORDER BY item");
$items = [];
if ($result) {
    while ($row = $result->fetch_assoc()) {
        $items[] = $row;
    }
}
echo json_encode($items);
?>