如何用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();

?>