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);
}