File manager - Edit - /home/webapp69.cm.in.th/u69319090033/Shop/api/test_db_ops.php
Back
<?php // Test script to verify seller_dashboard.php API operations directly $_SERVER['HTTP_HOST'] = 'localhost'; require_once __DIR__ . '/../db.php'; // Mock admin session $_SESSION['user_id'] = 1; $_SESSION['role'] = 'admin'; $_SESSION['seller_status'] = 'approved'; echo "--- 1. Testing INSERT Product ---\n"; $stmt = $conn->prepare("INSERT INTO products (seller_id, category_id, product_name, description, price, original_price, stock, image_url, badge, badge_text, approval_status, is_active) VALUES (1, 'electronics', 'TEST Product Unit', 'Test description', 999.00, 1590.00, 10, 'https://images.unsplash.com/photo-1505740420928-5e560c06d30e?w=800', 'new', 'มาใหม่', 'approved', 1)"); $stmt->execute(); $newId = $conn->insert_id; $stmt->close(); echo "Inserted Product ID: " . $newId . "\n"; echo "--- 2. Testing UPDATE Product (Edit Name & Price & Badge) ---\n"; $stmt = $conn->prepare("UPDATE products SET product_name = 'TEST Product Updated Name', price = 1290.00, badge = 'hot', badge_text = 'ขายดี' WHERE product_id = ?"); $stmt->bind_param('i', $newId); $stmt->execute(); $stmt->close(); $checkStmt = $conn->prepare("SELECT product_name, price, badge, badge_text FROM products WHERE product_id = ?"); $checkStmt->bind_param('i', $newId); $checkStmt->execute(); $row = $checkStmt->get_result()->fetch_assoc(); $checkStmt->close(); echo "Updated Data: " . json_encode($row, JSON_UNESCAPED_UNICODE) . "\n"; echo "--- 3. Testing DELETE Product ---\n"; $delStmt = $conn->prepare("DELETE FROM products WHERE product_id = ?"); $delStmt->bind_param('i', $newId); $delStmt->execute(); $delStmt->close(); $verifyStmt = $conn->prepare("SELECT product_id FROM products WHERE product_id = ?"); $verifyStmt->bind_param('i', $newId); $verifyStmt->execute(); $rem = $verifyStmt->get_result()->fetch_assoc(); $verifyStmt->close(); if (!$rem) { echo "Product successfully deleted from Database!\n"; } else { echo "Delete failed!\n"; } ?>
| ver. 1.4 |
Github
|
.
| PHP 7.4.33 | Generation time: 0.23 |
proxy
|
phpinfo
|
Settings