add_product.php

<?php
include 'connect.php';

if ($_SERVER["REQUEST_METHOD"] == "POST") {
    $name = $_POST['name'];
    $price = $_POST['price'];

    $stmt = $conn->prepare("INSERT INTO products (name, price) VALUES (?, ?)");
    $stmt->execute([$name, $price]);

    echo "เพิ่มสินค้าสำเร็จ!";
    header("Location: index.php");
}
?>
<form method="post">
    ชื่อสินค้า: <input type="text" name="name" required>
    ราคา: <input type="number" name="price" required>
    <button type="submit">เพิ่มสินค้า</button>
</form>