How to use PHP to write product warehousing function code in the inventory management system

How to use PHP to write the product warehousing function code in the inventory management system

In the inventory management system, the warehousing of goods is a very important link. Reasonable and efficient writing of product warehousing function codes can improve the efficiency and accuracy of the system. This article will introduce how to use PHP to write the product warehousing function code in the inventory management system, and provide corresponding code examples.

1. Database design

First, we need to create a product table and a warehousing record table in the database.

The product table includes the following fields: product ID, product name, product price, and product inventory.

The warehousing record table includes the following fields: record ID, product ID, warehousing quantity, and warehousing time.

2. Front-end interface design

In the front-end interface of the inventory management system, we need to provide a form for inputting product information and warehousing quantity.

Code example:

<form action="submit_inventory.php" method="post">
    <label for="productid">商品ID：</label>
    <input type="text" id="productid" name="productid"><br><br>
    <label for="productname">商品名称：</label>
    <input type="text" id="productname" name="productname"><br><br>
    <label for="productprice">商品价格：</label>
    <input type="text" id="productprice" name="productprice"><br><br>
    <label for="inventory">入库数量：</label>
    <input type="number" id="inventory" name="inventory"><br><br>
    <input type="submit" value="提交">
</form>

3. Back-end code writing

In the back-end code, we need to complete the following tasks:

1. Get form data and verify it;
2. Insert product information into the product table;
3. Insert a warehousing record in the warehousing record table;

Code example:

<?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();

?>

4. Summary

Through the above steps, we have completed the code writing of the product warehousing function. In practical applications, functions can also be expanded according to specific needs, such as adding inventory update functions, warehousing record queries, etc. Writing high-quality code can improve system stability and user experience, and provide strong support for inventory management work.

The above is the detailed content of How to use PHP to write product warehousing function code in the inventory management system. For more information, please follow other related articles on the PHP Chinese website!