Files
wevads-platform/scripts/api_test-db2.php
2026-02-26 04:53:11 +01:00

34 lines
1.2 KiB
PHP
Executable File

<?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";
}