// Create test-db.php in your public_html folder
<?php
// Replace with your actual database details from wp-config.php
$host = 'localhost';
$dbname = 'verona_new';
$username = 'verona_new';
$password = 'verona_new';

try {
    $pdo = new PDO("mysql:host=$host;dbname=$dbname", $username, $password);
    echo "✅ Database connected successfully!<br><br>";
    
    // Check WordPress tables
    $stmt = $pdo->query("SHOW TABLES LIKE 'wp_%'");
    $tables = $stmt->fetchAll(PDO::FETCH_COLUMN);
    echo "📊 WordPress tables found: " . count($tables) . "<br>";
    foreach($tables as $table) {
        echo "- " . $table . "<br>";
    }
    
    // Check wp_options table
    echo "<br>🔍 Checking wp_options:<br>";
    $stmt = $pdo->query("SELECT option_name, option_value FROM wp_options WHERE option_name IN ('home', 'siteurl', 'template', 'stylesheet') LIMIT 10");
    $options = $stmt->fetchAll(PDO::FETCH_ASSOC);
    foreach($options as $option) {
        echo "- " . $option['option_name'] . ": " . $option['option_value'] . "<br>";
    }
    
    // Check users
    echo "<br>👥 Checking users:<br>";
    $stmt = $pdo->query("SELECT user_login, user_email FROM wp_users LIMIT 5");
    $users = $stmt->fetchAll(PDO::FETCH_ASSOC);
    foreach($users as $user) {
        echo "- " . $user['user_login'] . " (" . $user['user_email'] . ")<br>";
    }
    
} catch(PDOException $e) {
    echo "❌ Database error: " . $e->getMessage();
}
?>