<?php
// TAMPILKAN ERROR (sementara untuk debugging)
ini_set('display_errors', 1);
ini_set('display_startup_errors', 1);
error_reporting(E_ALL);
header('Content-Type: text/plain; charset=UTF-8');

// CEK WEBROOT & PHP
echo "Booting test-db.php\n";
echo "DocumentRoot: " . __DIR__ . "\n";
echo "PHP Version: " . PHP_VERSION . "\n";
echo "mysqli loaded: " . (extension_loaded('mysqli') ? 'yes' : 'no') . "\n\n";

// GANTI kredensial sesuai .env TERBARU (bukan yang bocor)
$H = 'localhost';              // coba juga '127.0.0.1' jika gagal
$D = 'leminera_data';
$U = 'leminer_app';            // user baru yang kamu buat di cPanel
$P = 'pZ{7E-&$qdWo';          // password baru

mysqli_report(MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT);

try {
    $db = new mysqli($H, $U, $P, $D, 3306);
    $db->set_charset('utf8mb4');
    echo "OK: connected as $U to $D\n";

    $res = $db->query("SHOW TABLES");
    echo "Tables:\n";
    while ($row = $res->fetch_row()) {
        echo "- {$row[0]}\n";
    }
} catch (Throwable $e) {
    http_response_code(500);
    echo "ERROR: " . $e->getMessage() . "\n";
}