« Back to History
__debug_status.php
|
20260721_154032.php
Initial Bulk Import
Copy Code
<?php require_once __DIR__ . '/config.php'; $pdo = new PDO('mysql:host='.DB_HOST.';dbname='.DB_NAME, DB_USER, DB_PASS); $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $col = $pdo->query("SHOW COLUMNS FROM daily_tasks LIKE 'status'")->fetch(PDO::FETCH_ASSOC); echo "Column type: " . $col['Type'] . "\n"; echo "Default: " . $col['Default'] . "\n\n"; $rows = $pdo->query("SELECT id, task_name, task_type, status, last_reset_date FROM daily_tasks WHERE task_type='on_demand' LIMIT 10")->fetchAll(PDO::FETCH_ASSOC); foreach ($rows as $row) { echo "ID:{$row['id']} | {$row['task_name']} | status=[{$row['status']}] | last_reset_date=[{$row['last_reset_date']}]\n"; } echo "\nPHP today: " . date('Y-m-d') . "\n"; echo "MySQL CURDATE: " . $pdo->query("SELECT CURDATE()")->fetchColumn() . "\n"; echo "MySQL NOW: " . $pdo->query("SELECT NOW()")->fetchColumn() . "\n";