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

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

The inventory management system is crucial for any enterprise. It can help the enterprise track the inventory of goods in real time. Accurately grasp inventory quantity and location to improve work efficiency. Among them, inventory location management is one of the key functions in the inventory management system. It can help companies manage and classify different types of locations to ensure that the warehouse is clean and orderly. This article will teach you how to use PHP to write code for inventory location management functions.

First, we need to create a database table to store location information. The following is an example table structure:

CREATE TABLE warehouse (
   id INT PRIMARY KEY AUTO_INCREMENT,
   name VARCHAR(50),
   capacity INT,
   status TINYINT(1)
);

The above table structure contains the unique identification (id), location name (name), location capacity (capacity) and location status (status) of the location. Next, we write PHP code to complete the addition, deletion, modification and query operations of the library location.

1. Connect to database

<?php
$host = "localhost";
$username = "root";
$password = "password";
$dbname = "inventory_management";

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

if ($conn->connect_error) {
    die("连接数据库失败: " . $conn->connect_error);
}
?>

2. Add location

<?php
if (isset($_POST['add'])) {
    $name = $_POST['name'];
    $capacity = $_POST['capacity'];

    $sql = "INSERT INTO warehouse (name, capacity, status) VALUES ('$name', $capacity, 1)";

    if ($conn->query($sql) === TRUE) {
        echo "成功添加库位！";
    } else {
        echo "添加库位失败: " . $conn->error;
    }
}
?>

3. Delete location

<?php
if (isset($_GET['delete'])) {
    $id = $_GET['delete'];

    $sql = "DELETE FROM warehouse WHERE id = $id";

    if ($conn->query($sql) === TRUE) {
        echo "成功删除库位！";
    } else {
        echo "删除库位失败: " . $conn->error;
    }
}
?>

4. Update location information

<?php
if (isset($_POST['edit'])) {
    $id = $_POST['id'];
    $name = $_POST['name'];
    $capacity = $_POST['capacity'];

    $sql = "UPDATE warehouse SET name = '$name', capacity = $capacity WHERE id = $id";

    if ($conn->query($sql) === TRUE) {
        echo "成功更新库位信息！";
    } else {
        echo "更新库位信息失败: " . $conn->error;
    }
}
?>

5. Display location list

<?php
$sql = "SELECT * FROM warehouse";
$result = $conn->query($sql);

if ($result->num_rows > 0) {
    while ($row = $result->fetch_assoc()) {
        echo "库位ID: " . $row['id'] . "<br>";
        echo "库位名称: " . $row['name'] . "<br>";
        echo "库位容量: " . $row['capacity'] . "<br>";
        echo "库位状态: " . ($row['status'] ? "可用" : "不可用") . "<br>";
        echo "<a href='edit.php?id=" . $row['id'] . "'>编辑</a> | ";
        echo "<a href='?delete=" . $row['id'] . "'>删除</a><br><br>";
    }
} else {
    echo "暂无库位信息";
}

$conn->close();
?>

Through the above code, we can add location, Delete, edit and display functions. You can customize the pages and interactions to suit your needs and integrate the code into your inventory management system.

To sum up, inventory location management is an important function in the inventory management system. With the help of PHP programming language, you can easily add, delete, edit and display the location. I hope this article was helpful and I wish you good luck in writing an inventory management system!

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