PHP を使用して製品在庫管理を実装するためのヒント

CREATE DATABASE inventory;

USE inventory;

CREATE TABLE products (
    id INT PRIMARY KEY,
    name VARCHAR(255),
    description TEXT,
    price DECIMAL(10,2)
);

CREATE TABLE inventory (
    id INT PRIMARY KEY,
    product_id INT,
    quantity INT,
    last_updated TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    FOREIGN KEY (product_id) REFERENCES products(id)
);

<?php
// 连接到数据库
$conn = mysqli_connect("localhost", "username", "password", "inventory");

// 获取表单数据
$id = $_POST['id'];
$name = $_POST['name'];
$description = $_POST['description'];
$price = $_POST['price'];

// 插入商品数据
$sql = "INSERT INTO products (id, name, description, price) VALUES ('$id', '$name', '$description', '$price')";
mysqli_query($conn, $sql);

// 插入库存数据
$sql = "INSERT INTO inventory (id, product_id, quantity) VALUES ('$id', '$id', 0)";
mysqli_query($conn, $sql);

// 关闭数据库连接
mysqli_close($conn);
?>

<?php
// 连接到数据库
$conn = mysqli_connect("localhost", "username", "password", "inventory");

// 获取表单数据
$id = $_POST['id'];
$quantity = $_POST['quantity'];

// 更新库存数量
$sql = "UPDATE inventory SET quantity = quantity + '$quantity' WHERE product_id = '$id'";
mysqli_query($conn, $sql);

// 关闭数据库连接
mysqli_close($conn);
?>

<?php
// 连接到数据库
$conn = mysqli_connect("localhost", "username", "password", "inventory");

// 查询库存数量
$sql = "SELECT p.name, i.quantity FROM products p JOIN inventory i ON p.id = i.product_id";
$result = mysqli_query($conn, $sql);

// 显示库存信息
if (mysqli_num_rows($result) > 0) {
    while($row = mysqli_fetch_assoc($result)) {
        echo "商品名称: " . $row["name"]. " - 库存数量: " . $row["quantity"]. "<br>";
    }
} else {
    echo "暂无商品库存";
}

// 关闭数据库连接
mysqli_close($conn);
?>