<?php
// check_db.php - Verify database setup and orders
require_once 'db.php';

echo "=== DATABASE DIAGNOSTICS ===\n";

try {
    $p_count = $pdo->query("SELECT COUNT(*) FROM products")->fetchColumn();
    echo "Products count: $p_count\n";
    
    $o_count = $pdo->query("SELECT COUNT(*) FROM orders")->fetchColumn();
    echo "Orders count: $o_count\n";
    
    $oi_count = $pdo->query("SELECT COUNT(*) FROM order_items")->fetchColumn();
    echo "Order items count: $oi_count\n";

    if ($o_count > 0) {
        echo "\n=== LAST ORDER ===\n";
        $last_order = $pdo->query("SELECT * FROM orders ORDER BY id DESC LIMIT 1")->fetch(PDO::FETCH_ASSOC);
        print_r($last_order);
        
        echo "\n=== LAST ORDER ITEMS ===\n";
        $items = $pdo->prepare("SELECT oi.*, p.name FROM order_items oi JOIN products p ON oi.product_id = p.id WHERE oi.order_id = :id");
        $items->execute([':id' => $last_order['id']]);
        print_r($items->fetchAll(PDO::FETCH_ASSOC));
    }
} catch (Exception $e) {
    echo "Error: " . $e->getMessage() . "\n";
}