<?php
// Narrow read-only lookup for the user-requested HostBill integration of kiwerkzeuge.de:
// schema + order pages + product names/IDs (needed for cart links) + brand list.
require '/home/support.panomity.com/public_html/includes/config.php';
$pdo = new PDO("mysql:host=$db_host;dbname=$db_name;charset=utf8mb4", $db_user, $db_pass, [PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION]);

foreach (['hb_categories', 'hb_products', 'hb_brands'] as $tbl) {
    echo "=== DESCRIBE $tbl ===\n";
    try {
        foreach ($pdo->query("DESCRIBE $tbl") as $r) echo $r['Field'] . ' ' . $r['Type'] . "\n";
    } catch (Exception $e) { echo "ERR: " . $e->getMessage() . "\n"; }
    echo "\n";
}

echo "=== ORDER PAGES (hb_categories) ===\n";
foreach ($pdo->query("SELECT id, name, visible FROM hb_categories ORDER BY id LIMIT 40") as $r) {
    echo $r['id'] . ' | ' . $r['name'] . ' | visible=' . $r['visible'] . "\n";
}

echo "\n=== PRODUCTS (hb_products) ===\n";
foreach ($pdo->query("SELECT id, category_id, name, visible FROM hb_products ORDER BY id LIMIT 80") as $r) {
    echo $r['id'] . ' | cat=' . $r['category_id'] . ' | ' . $r['name'] . ' | visible=' . $r['visible'] . "\n";
}

echo "\n=== BRANDS (hb_brands) ===\n";
foreach ($pdo->query("SELECT * FROM hb_brands LIMIT 10") as $r) {
    $r = array_filter($r, fn($k) => !is_int($k), ARRAY_FILTER_USE_KEY);
    echo json_encode($r, JSON_UNESCAPED_UNICODE) . "\n";
}
echo "(Ende)\n";