Tul xxx Tul

Viewing: _inspect.php

<?php
$db = new PDO('mysql:host=127.0.0.1;dbname=progressgym;charset=utf8mb4', 'root', '');
$stmt = $db->query('SELECT id, titulo, json_data FROM roadmaps ORDER BY id DESC LIMIT 1');
$row = $stmt->fetch(PDO::FETCH_ASSOC);
echo "ID: " . $row['id'] . "\n";
echo "Titulo: " . $row['titulo'] . "\n";
$data = json_decode($row['json_data'], true);
echo "Modules count: " . (isset($data['modules']) ? count($data['modules']) : 'NO MODULES KEY') . "\n";
if (isset($data['modules']) && count($data['modules']) > 0) {
    echo "First module keys: " . implode(', ', array_keys($data['modules'][0])) . "\n";
    if (isset($data['modules'][0]['execution_items'])) {
        echo "Items count in module 1: " . count($data['modules'][0]['execution_items']) . "\n";
    } else {
        echo "NO execution_items key in module 1\n";
    }
}
$stmt2 = $db->prepare('SELECT COUNT(*) FROM roadmap_items WHERE roadmap_id = ?');
$stmt2->execute([$row['id']]);
echo "DB Items count: " . $stmt2->fetchColumn() . "\n";

User / IP	: 216.73.216.217
Host / Server	: 45.84.207.204 / aircan.me
System	: Linux lt-bnk-web1726.main-hosting.eu 5.14.0-611.36.1.el9_7.x86_64 #1 SMP PREEMPT_DYNAMIC Tue Mar 3 11:23:52 EST 2026 x86_64