Detailed explanation of using PHP to write an inventory alarm system

With the rapid development of e-commerce, inventory management has become an important matter that every enterprise cannot ignore. In order to avoid excessive inventory and improve inventory turnover, it is necessary to monitor inventory status in real time. This article will introduce how to use PHP to write an inventory alarm system.

1. Create database

Create a database named "inventory" in MySQL, and then create two tables: one for storing product information and the other for Store inventory information.

Create "products" table:

CREATE TABLE `products` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `price` decimal(10,2) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

Create "inventory" table:

CREATE TABLE `inventory` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `product_id` int(11) NOT NULL,
  `quantity` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  FOREIGN KEY (`product_id`) REFERENCES `products`(`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

2. Create PHP connection database

In PHP In the file, connect to the MySQL database:

<?php
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "inventory";

// 创建连接
$conn = mysqli_connect($servername, $username, $password, $dbname);

// 检测连接
if (!$conn) {
    die("Connection failed: " . mysqli_connect_error());
}
?>

3. Implement inventory alarm

When the inventory quantity is less than 5, send an email to notify the administrator. Here we use PHP's built-in mail() function to send emails.

// 查询低库存产品
$sql = "SELECT products.name, inventory.quantity
        FROM products
        INNER JOIN inventory ON products.id = inventory.product_id
        WHERE inventory.quantity < 5";

$result = mysqli_query($conn, $sql);

if(mysqli_num_rows($result) > 0) {
    // 构建电子邮件
    $to = "admin@example.com";
    $subject = "低库存警报";
    $message = "";
    while($row = mysqli_fetch_assoc($result)) {
        $message .= "产品: " . $row["name"] . ", 库存数量: " . $row["quantity"] . "\n";
    }

    // 发送电子邮件
    mail($to, $subject, $message);
}

4. Scheduled execution script

In order to continuously monitor inventory and send alert emails in a timely manner, you can use Windows scheduled tasks or Linux's cron scheduled task function to run regularly the above code.

5. Integrate the code into the existing inventory management system

Integrate the above code into the existing inventory management system. When entering inventory, ensure that the "quantity" field in the inventory database table is updated correctly. In this way, we can send inventory alarm emails by regularly running interactions with the inventory database.

Conclusion:

To implement the PHP inventory alarm function, you need to establish an inventory management system and store the inventory data in the MySQL database. By writing PHP code to interact with the inventory database, find low-stock products, and then use PHP's built-in mail() function to send an alert email to notify the administrator. At the same time, in order to track the inventory situation in time, we need to use scheduled tasks (Windows) or cron scheduled tasks (Linux) to execute the code regularly.

The above is the detailed content of Detailed explanation of using PHP to write an inventory alarm system. For more information, please follow other related articles on the PHP Chinese website!