api/test_db.php

<?php
/**
 * Database Test Endpoint - For debugging only
 */
header('Content-Type: application/json');

$host = getenv('DB_HOST') ?: "localhost";
$user = getenv('DB_USER') ?: "root";
$pass = getenv('DB_PASS') ?: "";
$db = getenv('DB_NAME') ?: "kiit_kaffe_db";

$result = [
    'config' => [
        'host' => $host,
        'user' => $user,
        'pass' => $pass ? '***' : '(empty)',
        'db' => $db
    ]
];

try {
    // Test connection without database
    $conn = new PDO("mysql:host=$host;charset=utf8mb4", $user, $pass);
    $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
    $result['connection'] = 'OK (no db)';
    
    // Test with database
    $conn = new PDO("mysql:host=$host;dbname=$db;charset=utf8mb4", $user, $pass);
    $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
    $result['connection'] = 'OK (with db)';
    
    // Check if tables exist
    $tables = $conn->query("SHOW TABLES")->fetchAll(PDO::FETCH_COLUMN);
    $result['tables'] = $tables;
    $result['tables_count'] = count($tables);
    
    // Check users table
    if (in_array('users', $tables)) {
        $count = $conn->query("SELECT COUNT(*) FROM users")->fetchColumn();
        $result['users_count'] = $count;
    }
    
    $result['status'] = 'success';
    
} catch (PDOException $e) {
    $result['status'] = 'error';
    $result['error'] = $e->getMessage();
}

echo json_encode($result);
?>