BROOKO icon
BROOKO UK NETWORK
Where code meets creativity & adventure
File viewer

db_check.php

Type
php
Size
879 B
Modified
15 May
db_check.php 879 B
<?php
header('Content-Type: text/plain; charset=utf-8');
$cfg = __DIR__ . '/config/database.php';
echo "WorkersPanel DB quick check\n";
echo "===========================\n\n";
if (!file_exists($cfg)) {
    echo "config/database.php not found\n";
    exit(1);
}

echo 'PHP version: ' . PHP_VERSION . "\n";
echo 'pdo_mysql loaded: ' . (extension_loaded('pdo_mysql') ? 'yes' : 'no') . "\n\n";

try {
    require $cfg;
    if (!isset($pdo) || !($pdo instanceof PDO)) {
        throw new RuntimeException('config/database.php did not create $pdo');
    }
    $stmt = $pdo->query('SELECT NOW() AS now_time');
    $row = $stmt->fetch(PDO::FETCH_ASSOC);
    echo "Database connection: OK\n";
    echo 'Server time: ' . ($row['now_time'] ?? 'unknown') . "\n";
} catch (Throwable $e) {
    echo "Database connection: FAILED\n";
    echo 'Error: ' . $e->getMessage() . "\n";
    exit(2);
}