Product management and inventory control with PHP and mini-programs

Commodity management and inventory control with PHP and mini-programs

With the development of the Internet, e-commerce has become one of the important pillars of economic growth. Product management and inventory control are one of the core issues in e-commerce platforms. This article will introduce how to use PHP and small programs to implement product management and inventory control functions, and provide relevant code examples.

1. Product Management

Product management mainly involves the functions of adding, deleting, modifying and querying products. The following is an example of using PHP and MySQL to implement product management.

1. Create product table

First, we need to create a product table in the database to store product-related information. You can use the following SQL statement to create a table named "goods":

CREATE TABLE goods (

id INT AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(100) NOT NULL,
price FLOAT NOT NULL,
quantity INT NOT NULL

);

2. Add goods

Here is an example of PHP code for adding an item:

$name = $_POST['name'];
$price = $_POST['price'];
$quantity = $_POST['quantity'];

$conn = mysqli_connect('localhost', 'root', 'password', 'database');
if (!$conn) {
    die('连接数据库失败: ' . mysqli_error($conn));
}

$sql = "INSERT INTO goods (name, price, quantity) VALUES ('$name', '$price', '$quantity')";
if (mysqli_query($conn, $sql)) {
    echo "商品添加成功";
} else {
    echo "商品添加失败: " . mysqli_error($conn);
}
mysqli_close($conn);

?>

3. Deleting an item

The following is an example of PHP code for deleting an item:

$id = $_POST['id'];

$conn = mysqli_connect('localhost', 'root', 'password', 'database');
if (!$conn) {
    die('连接数据库失败: ' . mysqli_error($conn));
}

$sql = "DELETE FROM goods WHERE id='$id'";
if (mysqli_query($conn, $sql)) {
    echo "商品删除成功";
} else {
    echo "商品删除失败: " . mysqli_error($conn);
}
mysqli_close($conn);

?>

4. Modify item

The following is an example of PHP code for modifying product information:

$id = $_POST['id'];
$price = $_POST['price'];
$quantity = $_POST['quantity'];

$conn = mysqli_connect('localhost', 'root', 'password', 'database');
if (!$conn) {
    die('连接数据库失败: ' . mysqli_error($conn));
}

$sql = "UPDATE goods SET price='$price', quantity='$quantity' WHERE id='$id'";
if (mysqli_query($conn, $sql)) {
    echo "商品信息修改成功";
} else {
    echo "商品信息修改失败: " . mysqli_error($conn);
}
mysqli_close($conn);

?>

5. Query Product

The following is an example of PHP code for querying product information:

$conn = mysqli_connect('localhost', 'root', 'password', 'database');
if (!$conn) {
    die('连接数据库失败: ' . mysqli_error($conn));
}

$sql = "SELECT * FROM goods";
$result = mysqli_query($conn, $sql);

if (mysqli_num_rows($result) > 0) {
    while($row = mysqli_fetch_assoc($result)) {
        echo "ID: " . $row["id"]. " - Name: " . $row["name"]. " - Price: " . $row["price"]. " - Quantity: " . $row["quantity"]. "<br>";
    }
} else {
    echo "暂无商品信息";
}
mysqli_close($conn);

?>

2. Inventory control

Inventory control is an important link in the e-commerce platform. It involves functions such as inventory increase and decrease of goods, inventory inquiry, etc. Below is a sample code that uses a small program to implement inventory control.

1. Modify inventory

First, we need to write a function for modifying inventory in the applet. The following is a code example of a small program that modifies inventory:

const db = wx.cloud.database();
const _ = db.command;

function updateInventory(productId, quantity) {
  db.collection('goods').doc(productId).update({
    data: {
      quantity: _.inc(quantity)
    },
    success: res => {
      console.log('库存修改成功');
    },
    fail: err => {
      console.error('库存修改失败', err);
    }
  });
}

2. Query inventory

The following is a code example of a small program that queries inventory:

const db = wx.cloud.database();

function getInventory(productId) {
  db.collection('goods').doc(productId).get({
    success: res => {
      console.log('商品库存为', res.data.quantity);
    },
    fail: err => {
      console.error('查询库存失败', err);
    }
  });
}

The above is a sample code for using PHP and applet to implement commodity management and inventory control. Through these codes, we can implement functions such as adding, deleting, modifying, and checking products, as well as adding and querying inventory. Of course, in actual applications, the code needs to be modified and supplemented according to specific circumstances. Hope this article helps you!

The above is the detailed content of Product management and inventory control with PHP and mini-programs. For more information, please follow other related articles on the PHP Chinese website!