/**
 * Database Connection Test
 * Veritabanı bağlantısını test eder
 * KULLANDIKTAN SONRA SİLİN!
 */

error_reporting(E_ALL);
ini_set('display_errors', 1);

echo "<h1>🔍 Database Connection Test</h1>";
echo "<hr>";

// Config değerlerini manuel gir
$host = 'localhost';
$dbname = 'georgiantransfer_booking';
$username = 'georgiantransfer_transfer';
$password = 'k3l3m3nali331!';

echo "<h2>📋 Connection Details:</h2>";
echo "<ul>";
echo "<li><strong>Host:</strong> $host</li>";
echo "<li><strong>Database:</strong> $dbname</li>";
echo "<li><strong>Username:</strong> $username</li>";
echo "<li><strong>Password:</strong> " . str_repeat('*', strlen($password)) . "</li>";
echo "</ul>";
echo "<hr>";

try {
    echo "<h2>🔌 Attempting Connection...</h2>";
    
    $dsn = "mysql:host=$host;dbname=$dbname;charset=utf8mb4";
    $pdo = new PDO($dsn, $username, $password, [
        PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
        PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC,
    ]);
    
    echo "<div style='background: #d4edda; border: 1px solid #28a745; padding: 15px; border-radius: 5px;'>";
    echo "<h3>✅ CONNECTION SUCCESSFUL!</h3>";
    echo "</div>";
    
    // Test: Admins tablosu var mı?
    echo "<hr>";
    echo "<h2>🗄️ Table Check: admins</h2>";
    
    $stmt = $pdo->query("SELECT COUNT(*) as count FROM admins");
    $result = $stmt->fetch();
    
    echo "<div style='background: #d4edda; border: 1px solid #28a745; padding: 15px; border-radius: 5px;'>";
    echo "<h3>✅ Admins table exists!</h3>";
    echo "<p>Total admin users: <strong>" . $result['count'] . "</strong></p>";
    echo "</div>";
    
    // Admin kullanıcıları listele
    echo "<hr>";
    echo "<h2>👥 Admin Users:</h2>";
    
    $stmt = $pdo->query("SELECT id, username, email, created_at FROM admins");
    $admins = $stmt->fetchAll();
    
    if (count($admins) > 0) {
        echo "<table border='1' cellpadding='10' style='border-collapse: collapse; width: 100%;'>";
        echo "<tr style='background: #f8f9fa;'>";
        echo "<th>ID</th><th>Username</th><th>Email</th><th>Created At</th>";
        echo "</tr>";
        
        foreach ($admins as $admin) {
            echo "<tr>";
            echo "<td>" . htmlspecialchars($admin['id']) . "</td>";
            echo "<td><strong>" . htmlspecialchars($admin['username']) . "</strong></td>";
            echo "<td>" . htmlspecialchars($admin['email']) . "</td>";
            echo "<td>" . htmlspecialchars($admin['created_at']) . "</td>";
            echo "</tr>";
        }
        
        echo "</table>";
    } else {
        echo "<div style='background: #fff3cd; border: 1px solid #ffc107; padding: 15px; border-radius: 5px;'>";
        echo "<h3>⚠️ No admin users found!</h3>";
        echo "<p>Run the CREATE_TABLES.sql script.</p>";
        echo "</div>";
    }
    
    // Password hash kontrol
    echo "<hr>";
    echo "<h2>🔐 Password Hash Check:</h2>";
    
    $stmt = $pdo->query("SELECT username, password_hash FROM admins");
    $admins = $stmt->fetchAll();
    
    echo "<table border='1' cellpadding='10' style='border-collapse: collapse; width: 100%;'>";
    echo "<tr style='background: #f8f9fa;'>";
    echo "<th>Username</th><th>Password Hash</th><th>Hash Type</th>";
    echo "</tr>";
    
    foreach ($admins as $admin) {
        $hashType = 'Unknown';
        if (strpos($admin['password_hash'], '$2y$') === 0) {
            $hashType = 'bcrypt ($2y$)';
        } elseif (strpos($admin['password_hash'], '$2a$') === 0) {
            $hashType = 'bcrypt ($2a$)';
        } elseif (strpos($admin['password_hash'], '$2b$') === 0) {
            $hashType = 'bcrypt ($2b$)';
        }
        
        echo "<tr>";
        echo "<td><strong>" . htmlspecialchars($admin['username']) . "</strong></td>";
        echo "<td style='font-family: monospace; font-size: 11px;'>" . htmlspecialchars(substr($admin['password_hash'], 0, 50)) . "...</td>";
        echo "<td>" . $hashType . "</td>";
        echo "</tr>";
    }
    
    echo "</table>";
    
    echo "<hr>";
    echo "<div style='background: #d1ecf1; border: 1px solid #17a2b8; padding: 15px; border-radius: 5px;'>";
    echo "<h3>✅ ALL TESTS PASSED!</h3>";
    echo "<p>Database connection is working correctly.</p>";
    echo "<p><strong>⚠️ DELETE THIS FILE AFTER TESTING!</strong></p>";
    echo "</div>";
    
} catch (PDOException $e) {
    echo "<div style='background: #f8d7da; border: 1px solid #dc3545; padding: 15px; border-radius: 5px;'>";
    echo "<h3>❌ CONNECTION FAILED!</h3>";
    echo "<p><strong>Error:</strong> " . htmlspecialchars($e->getMessage()) . "</p>";
    echo "</div>";
    
    echo "<hr>";
    echo "<h2>🔧 Troubleshooting:</h2>";
    echo "<ol>";
    echo "<li>Check database name is correct</li>";
    echo "<li>Check username/password is correct</li>";
    echo "<li>Check user has permissions to access database</li>";
    echo "<li>Check database exists (phpMyAdmin)</li>";
    echo "</ol>";
}
?>

<style>
body {
    font-family: Arial, sans-serif;
    max-width: 1200px;
    margin: 20px auto;
    padding: 20px;
    background: #f5f5f5;
}
h1 { color: #333; }
h2 { color: #555; margin-top: 20px; }
</style>