How to use PHP to write the code for the daily inventory counting function in the inventory management system

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

1. Introduction
Having accurate inventory data is very important for any enterprise. Inventory counting is one of the important steps in maintaining inventory accuracy. Through daily inventory, inventory data can be verified, potential problems can be discovered, and inventory records can be adjusted in a timely manner to ensure the accuracy of inventory data. This article will introduce how to use PHP to write the daily inventory function code in a simple inventory management system.

2. Database design
Before starting to write code, we first need to design a database to store inventory data. In this article, we simplify the database structure and include only the following two tables: product table and inventory table.

Product table (products):

• id: product ID, primary key
• name: product name
• price: product price
• quantity: Product quantity

Inventory table (inventory):

• id: inventory ID, primary key
• product_id: product ID, foreign key
• quantity: inventory quantity

3. Code implementation

1. Connect to database

$host = "localhost"; //Host name
$username = "root"; //Username
$password = "password"; //Password
$dbname = "inventory"; // Database name

$conn = new mysqli($host, $username, $password, $dbname);
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
?>

2. Get the product list

$sql = "SELECT * FROM products";
$result = $conn->query($sql);

if ($result->num_rows > 0) {
while($row = $result->fetch_assoc()) {

  echo "商品ID: " . $row["id"]. " - 商品名称: " . $row["name"]. " - 商品价格: " . $row["price"]. "<br>";

}
} else {
echo "0 results";
}
?>

3. Counting inventory
   Before taking inventory, we first need to select a product for inventory.

if(isset($_POST['submit'])) {
$product_id = $_POST['product_id'];

$sql = "SELECT * FROM inventory WHERE product_id = $product_id";
$result = $conn->query($sql);

if ($result->num_rows > 0) {

  $row = $result->fetch_assoc();
  echo "商品ID: " . $row["id"]. " - 商品数量: " . $row["quantity"];

} else {

  echo "该商品暂无库存信息";

}
}
?>

Select product:

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

     if ($result->num_rows > 0) {
        while($row = $result->fetch_assoc()) {
           echo "<option value='". $row["id"]. "'>". $row["name"]. "</option>";
        }
     }
  ?>

4. Summary
Through the above code example, we can implement a simple Daily inventory counting function in the inventory management system. Users can select the product to be counted, and the system will display the inventory quantity of the product. If there is no inventory information for the product in the database, the system will prompt that there is no inventory information. Based on actual needs, we can further improve functions, such as adding inventory records, generating inventory reports, etc., as well as performing data verification and security processing. I hope this article will help you understand how to use PHP to write inventory daily inventory function code.

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