How to use PHP to develop automated product inventory management tools

How to use PHP to develop automated product inventory management tools

Commodity inventory management is one of the daily tasks that every enterprise must face, and it is developed using PHP Automated merchandise inventory management tools can greatly improve the efficiency and accuracy of your business. This article will introduce how to use PHP to develop a simple and practical automated product inventory management tool, and come with code samples for reference.

1. Requirements Analysis

Before we start writing code, we first need to conduct a needs analysis to clarify our goals and functional requirements. A basic product inventory management tool should have the following functions:

1. Product management: It can easily add, modify and delete product information, including product name, price, inventory quantity, etc.
2. Inventory management: Update product inventory quantities in real time to ensure the accuracy of inventory information.
3. Sales Management: Record the sales record and sales quantity of goods for sales statistics and forecasting.
4. Report generation: Able to generate various statistical reports, such as monthly statistical reports, quarterly statistical reports on sales and sales volume, etc.
5. User management: supports multiple users to use it at the same time, and can assign different permissions and roles.

2. Database design

Based on the above requirements, we need to design the database and create corresponding data tables. Here we create a database named "inventory_management", which contains two data tables: product table (products) and sales record table (sales).

1. Product table (products)

   • id INT(11) PRIMARY KEY AUTO_INCREMENT: The unique identifier of the product.
   • name VARCHAR(255): product name.
   • price DECIMAL(10,2): Product price.
   • quantity INT(11): Product inventory quantity.

2. Sales record table (sales)

   • id INT(11) PRIMARY KEY AUTO_INCREMENT: The unique identifier of the sales record.
   • product_id INT(11): product ID, associated with the id field in the product table.
   • quantity INT(11): Sales quantity.
   • sale_date DATE: Sales date.

3. Code implementation

1. Connect to database

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

$pdo = new PDO("mysql:host=$host;dbname=$dbname;charset=utf8", $username, $password);
$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$pdo->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_ASSOC);

2. Commodity management function

<?php
// 添加商品
function addProduct($name, $price, $quantity) {
    global $pdo;
    
    $stmt = $pdo->prepare("INSERT INTO products (name, price, quantity) VALUES (?, ?, ?)");
    $stmt->execute([$name, $price, $quantity]);
    
    return $pdo->lastInsertId();
}

// 修改商品信息
function updateProduct($id, $name, $price, $quantity) {
    global $pdo;
    
    $stmt = $pdo->prepare("UPDATE products SET name = ?, price = ?, quantity = ? WHERE id = ?");
    $stmt->execute([$name, $price, $quantity, $id]);
    
    return $stmt->rowCount();
}

// 删除商品
function deleteProduct($id) {
    global $pdo;
    
    $stmt = $pdo->prepare("DELETE FROM products WHERE id = ?");
    $stmt->execute([$id]);
    
    return $stmt->rowCount();
}

3. Inventory management function

<?php
// 更新库存数量
function updateQuantity($id, $quantity) {
    global $pdo;
    
    $stmt = $pdo->prepare("UPDATE products SET quantity = ? WHERE id = ?");
    $stmt->execute([$quantity, $id]);
    
    return $stmt->rowCount();
}

4. Sales management function

<?php
// 添加销售记录
function addSale($productId, $quantity, $saleDate) {
    global $pdo;
    
    $stmt = $pdo->prepare("INSERT INTO sales (product_id, quantity, sale_date) VALUES (?, ?, ?)");
    $stmt->execute([$productId, $quantity, $saleDate]);
    
    return $pdo->lastInsertId();
}

5. Report generation function

slightly.

6. User management functions

Omitted.

4. Summary

Through the above code examples, we can see that it is not difficult to develop automated product inventory management tools using PHP. This simple and practical tool can not only improve the efficiency and accuracy of enterprises, but also provide various statistical reports to help enterprises conduct sales statistics and forecasts. Of course, this is just a basic example, and actual applications need to be expanded and optimized according to specific business needs.

I hope this article will help you understand how to use PHP to develop automated product inventory management tools!

The above is the detailed content of How to use PHP to develop automated product inventory management tools. For more information, please follow other related articles on the PHP Chinese website!