📊 Database Data Inspector for " . htmlspecialchars(DB_NAME) . ""; $db = Database::getInstance(); // 1. Check Users echo "

1. Users Table (ผู้ใช้ทั้งหมดในระบบ)

"; $users = $db->query("SELECT id, username, email, full_name, role, status, created_at FROM users ORDER BY id ASC")->fetchAll(); echo ""; echo ""; foreach ($users as $u) { echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } echo "
IDUsernameEmailFull NameRoleStatusCreated At
" . $u['id'] . "" . htmlspecialchars($u['username']) . "" . htmlspecialchars($u['email']) . "" . htmlspecialchars($u['full_name']) . "" . htmlspecialchars($u['role']) . "" . htmlspecialchars($u['status']) . "" . htmlspecialchars($u['created_at']) . "
"; // 2. Check Products echo "

2. Products Table (สินค้าทั้งหมดในระบบ)

"; $products = $db->query("SELECT p.id, p.title, p.price, p.sale_price, p.stock_quantity, p.status, sp.shop_name FROM products p LEFT JOIN seller_profiles sp ON p.seller_id = sp.id ORDER BY p.id ASC")->fetchAll(); echo ""; echo ""; foreach ($products as $p) { echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } echo "
IDTitlePriceStockStatusShop Name
" . $p['id'] . "" . htmlspecialchars($p['title']) . "฿" . number_format($p['price'], 2) . "" . $p['stock_quantity'] . "" . htmlspecialchars($p['status']) . "" . htmlspecialchars($p['shop_name'] ?? 'None') . "
"; // 3. Check Orders echo "

3. Orders Table (ประวัติคำสั่งซื้อ)

"; $orders = $db->query("SELECT o.id, o.order_number, u.username, o.total_amount, o.status, o.created_at FROM orders o LEFT JOIN users u ON o.user_id = u.id ORDER BY o.id DESC")->fetchAll(); echo ""; echo ""; foreach ($orders as $o) { echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } echo "
IDOrder No.UserTotalStatusCreated At
" . $o['id'] . "" . htmlspecialchars($o['order_number']) . "" . htmlspecialchars($o['username'] ?? 'None') . "฿" . number_format($o['total_amount'], 2) . "" . htmlspecialchars($o['status']) . "" . htmlspecialchars($o['created_at']) . "
";