const express = require('express'); const mysql = require('mysql2'); const router = express.Router(); const db = mysql.createConnection({ host: 'localhost', user: 'root', password: '', database: 'ecommerce' }); // เพิ่มสินค้า router.post('/add', (req, res) => { const { name, description, price, quantity } = req.body; const query = 'INSERT INTO products (name, description, price, quantity) VALUES (?, ?, ?, ?)'; db.query(query, [name, description, price, quantity], (err, result) => { if (err) { return res.status(500).json({ message: 'Error adding product' }); } res.status(201).json({ message: 'Product added successfully' }); }); }); // แก้ไขสินค้า router.put('/update/:id', (req, res) => { const { id } = req.params; const { name, description, price, quantity } = req.body; const query = 'UPDATE products SET name = ?, description = ?, price = ?, quantity = ? WHERE product_id = ?'; db.query(query, [name, description, price, quantity, id], (err, result) => { if (err) { return res.status(500).json({ message: 'Error updating product' }); } res.status(200).json({ message: 'Product updated successfully' }); }); }); // ลบสินค้า router.delete('/delete/:id', (req, res) => { const { id } = req.params; const query = 'DELETE FROM products WHERE product_id = ?'; db.query(query, [id], (err, result) => { if (err) { return res.status(500).json({ message: 'Error deleting product' }); } res.status(200).json({ message: 'Product deleted successfully' }); }); }); // ค้นหาสินค้า router.get('/search', (req, res) => { const { query } = req.query; const searchQuery = `SELECT * FROM products WHERE name LIKE ?`; db.query(searchQuery, [`%${query}%`], (err, results) => { if (err) { return res.status(500).json({ message: 'Error searching products' }); } res.status(200).json(results); }); }); module.exports = router;