PHPで構築した中古品リサイクルサイトが高品質なサプライチェーンマネジメントをサポート

CREATE DATABASE recycle;
USE recycle;

CREATE TABLE users (
    id INT PRIMARY KEY AUTO_INCREMENT,
    name VARCHAR(50) NOT NULL,
    email VARCHAR(100) NOT NULL,
    password VARCHAR(100) NOT NULL
);

CREATE TABLE products (
    id INT PRIMARY KEY AUTO_INCREMENT,
    name VARCHAR(100) NOT NULL,
    description TEXT NOT NULL,
    price DECIMAL(10, 2) NOT NULL,
    user_id INT NOT NULL,
    FOREIGN KEY (user_id) REFERENCES users(id)
);

<?php
if ($_SERVER["REQUEST_METHOD"] == "POST") {
    $name = $_POST["name"];
    $email = $_POST["email"];
    $password = $_POST["password"];

    // 将用户信息插入数据库
    $sql = "INSERT INTO users (name, email, password) VALUES ('$name', '$email', '$password')";
    $result = mysqli_query($conn, $sql);
    if ($result) {
        echo "用户注册成功！";
    } else {
        echo "用户注册失败，请重试！";
    }
}
?>

<?php
if ($_SERVER["REQUEST_METHOD"] == "POST") {
    $email = $_POST["email"];
    $password = $_POST["password"];

    // 验证登录信息
    $sql = "SELECT * FROM users WHERE email='$email' AND password='$password'";
    $result = mysqli_query($conn, $sql);
    if (mysqli_num_rows($result) == 1) {
        echo "登录成功！";
    } else {
        echo "登录失败，请检查用户名和密码";
    }
}
?>

<?php
$sql = "SELECT * FROM products";
$result = mysqli_query($conn, $sql);
while ($row = mysqli_fetch_assoc($result)) {
    echo "<div>";
    echo "<h3>".$row["name"]."</h3>";
    echo "<p>".$row["description"]."</p>";
    echo "<p>价格：".$row["price"]."元</p>";
    echo "</div>";
}
?>

<?php
if ($_SERVER["REQUEST_METHOD"] == "POST") {
    $name = $_POST["name"];
    $description = $_POST["description"];
    $price = $_POST["price"];
    $user_id = $_SESSION["user_id"];

    // 添加产品到数据库
    $sql = "INSERT INTO products (name, description, price, user_id) VALUES ('$name', '$description', '$price', '$user_id')";
    $result = mysqli_query($conn, $sql);
    if ($result) {
        echo "产品添加成功！";
    } else {
        echo "产品添加失败，请重试！";
    }
}
?>