<?php
require_once 'db-connect.php';

try {
    $pdo = getDB();
    echo "✅ DB Connect OK\n\n";
    
    // 1. Vérifier hamid_providers
    echo "=== hamid_providers ===\n";
    $stmt = $pdo->query('SELECT * FROM admin.hamid_providers LIMIT 5');
    $rows = $stmt->fetchAll();
    foreach ($rows as $row) {
        echo "Provider: " . ($row['provider_name'] ?? $row['name'] ?? 'N/A') . "\n";
        echo "  URL: " . ($row['api_url'] ?? 'N/A') . "\n";
        echo "  Key: " . (isset($row['api_key']) && !empty($row['api_key']) ? 'SET' : 'EMPTY') . "\n";
        echo "  Active: " . ($row['is_active'] ?? 'unknown') . "\n";
        echo "---\n";
    }
    
    // 2. Vérifier ai_providers  
    echo "\n=== ai_providers ===\n";
    $stmt = $pdo->query('SELECT * FROM admin.ai_providers LIMIT 5');
    $rows = $stmt->fetchAll();
    foreach ($rows as $row) {
        echo "Provider: " . ($row['name'] ?? 'N/A') . "\n";
        echo "  URL: " . ($row['api_url'] ?? 'N/A') . "\n";
        echo "  Key: " . (isset($row['api_key']) && !empty($row['api_key']) ? 'SET' : 'EMPTY') . "\n";
        echo "---\n";
    }
    
} catch(Exception $e) {
    echo "❌ Error: " . $e->getMessage() . "\n";
}