如何用PHP實現庫存管理系統中的商品入庫功能

<?php

 // 連接數據庫

$servername = "localhost";

 $username = "username";

 $password = "password";

 $dbname = "dbname";

 $conn = new mysqli($servername, $username, $password, $dbname);

 if ($conn->connect_error) {

 die("連接失敗: " . $conn->connect_error);

 }

 // 獲取表單數據

$productid = $_POST['productid'];

 $productname = $_POST['productname'];

 $productprice = $_POST['productprice'];

 $inventory = $_POST['inventory'];

 // 驗證數據

if (empty($productid) || empty($productname) || empty($productprice) || empty($inventory)) {

 echo "請填寫完整信息";

 } else {

 // 插入商品信息

 $sql_insert_product = "INSERT INTO product (productid, productname, productprice, inventory) VALUES ('$productid', '$productname', '$productprice', '$inventory')";

 if ($conn->query($sql_insert_product) === TRUE) {

 echo "商品插入成功";

 } else {

 echo "商品插入失敗: " . $conn->error;

 }

 // 插入入庫記錄

 $sql_insert_inventory = "INSERT INTO inventory (productid, quantity, datetime) VALUES ('$productid', '$inventory', NOW())";

 if ($conn->query($sql_insert_inventory) === TRUE) {

 echo "入庫記錄插入成功";

 } else {

 echo "入庫記錄插入失敗: " . $conn->error;

 }

 }

 $conn->close();

 ?>