Steps and techniques for implementing product inventory counting with PHP

Steps and techniques for implementing product inventory in PHP

In the e-commerce industry, product inventory management is a very important task. Timely and accurate inventory counting can avoid sales delays, customer complaints and other problems caused by inventory errors. This article will introduce the steps and techniques on how to use PHP to implement product inventory counting, and provide code examples.

Step 1: Create a database

First, we need to create a database to store product information. Create a database named "inventory", and then create a table named "products" to store product ID, name, inventory quantity and other information. The following is the SQL statement to create the table:

CREATE TABLE `products` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(100) NOT NULL,
  `quantity` INT(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

Step 2: Connect to the database

In the PHP code, we need to connect to the database for data operations. The following is a sample code for connecting to the database named "inventory":

<?php
  $host = "localhost"; //数据库主机
  $username = "root"; //数据库用户名
  $password = "123456"; //数据库密码
  $dbname = "inventory"; //数据库名称
  
  //创建连接
  $conn = new mysqli($host, $username, $password, $dbname);
  
  //检查连接是否成功
  if ($conn->connect_error) {
    die("数据库连接失败: " . $conn->connect_error);
  }
?>

Step 3: Display the product list

Before inventory counting, we need to display the current product list for convenience The operator makes the choice. The following is a sample code for getting the product list from the "products" table and displaying it:

<?php
  //查询商品列表
  $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["quantity"]. "<br>";
    }
  } else {
    echo "暂无商品";
  }
  
  //关闭数据库连接
  $conn->close();
?>

Step 4: Select the products to be counted

After displaying the product list, the operator can Select the items you want to inventory. The following is a sample code that displays the product selection form and processes the selection submitted by the user:

<?php
  if ($_SERVER["REQUEST_METHOD"] == "POST") {
    //获取用户提交的商品ID
    $selectedProduct = $_POST["product"];
    
    //根据商品ID查询商品信息
    $sql = "SELECT * FROM products WHERE id = $selectedProduct";
    $result = $conn->query($sql);
    
    //检查是否有结果
    if ($result->num_rows > 0) {
      //输出商品信息
      while($row = $result->fetch_assoc()) {
        echo "商品名称: " . $row["name"]. " - 库存数量: " . $row["quantity"];
      }
    } else {
      echo "未找到商品";
    }
    
  }
?>

<form method="post" action="<?php echo htmlspecialchars($_SERVER["PHP_SELF"]);?>">
  请选择要盘点的商品：
  <select name="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>";
        }
      } else {
        echo "<option value=''>暂无商品</option>";
      }
    ?>
  </select>
  <input type="submit" value="提交">
</form>

<?php
  //关闭数据库连接
  $conn->close();
?>

Step 5: Update the inventory quantity

After completing the inventory, the operator needs to update the inventory quantity. The following is a sample code for updating the inventory quantity of selected products:

<?php
  if ($_SERVER["REQUEST_METHOD"] == "POST") {
    //获取用户提交的商品ID和库存数量
    $selectedProduct = $_POST["product"];
    $newQuantity = $_POST["quantity"];
    
    //更新库存数量
    $sql = "UPDATE products SET quantity = $newQuantity WHERE id = $selectedProduct";
    
    if ($conn->query($sql) === TRUE) {
      echo "库存数量更新成功";
    } else {
      echo "库存数量更新失败: " . $conn->error;
    }
  }
?>

<form method="post" action="<?php echo htmlspecialchars($_SERVER["PHP_SELF"]);?>">
  商品名称：<span id="productName"></span><br>
  剩余库存数量：<span id="productQuantity"></span><br>
  新的库存数量：<input type="text" name="quantity"><br>
  <input type="hidden" name="product" id="productId">
  <input type="submit" value="更新">
</form>

<script>
  //根据选中的商品更新相应的数据
  function updateProduct() {
    var productSelect = document.getElementsByName("product")[0];
    var productNameSpan = document.getElementById("productName");
    var productQuantitySpan = document.getElementById("productQuantity");
    
    productNameSpan.innerHTML = productSelect.options[productSelect.selectedIndex].text;
    productQuantitySpan.innerHTML = productSelect.options[productSelect.selectedIndex].getAttribute("data-quantity");
    document.getElementById("productId").value = productSelect.value;
  }
  
  //页面加载完成后执行更新
  window.onload = updateProduct;
  //商品选择改变时执行更新
  document.getElementsByName("product")[0].onchange = updateProduct;
</script>

<?php
  //关闭数据库连接
  $conn->close();
?>

Through the above steps, we can use PHP to implement the function of product inventory counting. It provides operators with convenient tools and operation interfaces from displaying product lists, selecting products, updating inventory quantities, etc. Of course, according to specific business needs, you can customize and improve the above code to meet actual needs.

The above is the detailed content of Steps and techniques for implementing product inventory counting with PHP. For more information, please follow other related articles on the PHP Chinese website!