File manager - Edit - /home/webapp69.cm.in.th/u69319090014/shop non 014/check_db.php
Back
<?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"; }
| ver. 1.4 |
Github
|
.
| PHP 7.4.33 | Generation time: 0.25 |
proxy
|
phpinfo
|
Settings