<?php

include "/var/www/apifidfarma/env/db_ini.php";

try {
    // Crear una instancia PDO
    $dsn = "mysql:host=" . $dct_db_config['default']["hostname"] . ";dbname=" . $dct_db_config['default']["name"] . ";port=" . $dct_db_config['default']["port"];
    $username = $dct_db_config['default']["username"];
    $password = $dct_db_config['default']["password"];
    $emulate_prepares = $dct_db_config['default']["emulate_prepares"];
    $options = [
        PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
        PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC,
        PDO::ATTR_EMULATE_PREPARES => $emulate_prepares,
    ];

    $pdo = new PDO($dsn, $username, $password, $options);

    // Ejecutar la consulta
    $stmt = $pdo->query('SELECT * FROM Customer WHERE id = 26');

    $data = array();

    // Recuperar los resultados
    while ($row = $stmt->fetch())
   {

        $data["id"] = $row['id'];
        $data["cardid"] = $row['cardid'];
        $data["adults"] = $row['adults'];
		$data["name"] = $row['name'];

        echo json_encode($data, JSON_PRETTY_PRINT);
    }

} catch (PDOException $e) {
    printf("Falló la conexión: %s\n", $e->getMessage());
    exit();
}
?>