<?php
if (!in_array($_SERVER['REMOTE_ADDR'] ?? '', ['127.0.0.1', '::1', '::ffff:127.0.0.1'])) {
    http_response_code(403); exit;
}
header('Content-Type: text/plain; charset=utf-8');

echo "fbclient.dll loaded: " . (extension_loaded('pdo_firebird') ? 'YES' : 'NO') . "\n";
echo "PHP version: " . PHP_VERSION . "\n\n";

// Teste 1: remota localhost
$dsns = [
    'remota-host' => "firebird:host=localhost;port=3050;dbname=C:\\Banco\\FIRE.FDB;charset=UTF8",
    'remota-dbname' => "firebird:dbname=localhost/3050:C:\\Banco\\FIRE.FDB;charset=UTF8",
    'local-direto' => "firebird:dbname=C:\\Banco\\FIRE.FDB;charset=UTF8",
];

foreach ($dsns as $nome => $dsn) {
    echo "=== Testando: $nome ===\n";
    echo "DSN: $dsn\n";
    try {
        $pdo = new PDO($dsn, 'SYSDBA', 'masterkey', [PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION]);
        echo "CONECTOU!\n";
        $r = $pdo->query("SELECT COUNT(*) FROM ABERT_MESA")->fetchColumn();
        echo "ABERT_MESA count: $r\n";
        $pdo = null;
    } catch (Throwable $e) {
        echo "ERRO: " . $e->getMessage() . "\n";
    }
    echo "\n";
}