PHP를 활용하여 개발된 중고 재활용 웹사이트는 온라인 입찰 기능을 지원합니다.

CREATE TABLE `user` (
 `id` INT NOT NULL AUTO_INCREMENT,
 `username` VARCHAR(50) NOT NULL,
 `password` VARCHAR(50) NOT NULL,
 `email` VARCHAR(50) NOT NULL,
 PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE `item` (
 `id` INT NOT NULL AUTO_INCREMENT,
 `title` VARCHAR(50) NOT NULL,
 `image` VARCHAR(100) NOT NULL,
 `description` TEXT NOT NULL,
 `price` DECIMAL(10,2) NOT NULL,
 `status` INT NOT NULL DEFAULT 0,
 PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

<?php
// 连接数据库
$conn = mysqli_connect("localhost","root","root","db_name");
// 检查连接是否成功
if (mysqli_connect_errno()) {
    echo "Failed to connect to MySQL: " . mysqli_connect_error();
    exit();
}

// 接收注册表单提交的数据
$username = $_POST['username'];
$password = $_POST['password'];
$email = $_POST['email'];

// 验证用户名是否已存在
$sql = "SELECT * FROM user WHERE username='$username'";
$result = mysqli_query($conn, $sql);
if(mysqli_num_rows($result) > 0){
    echo "用户名已存在";
    exit();
}

// 验证邮箱是否已存在
$sql = "SELECT * FROM user WHERE email='$email'";
$result = mysqli_query($conn, $sql);
if(mysqli_num_rows($result) > 0){
    echo "邮箱已存在";
    exit();
}

// 将用户注册信息插入数据库
$sql = "INSERT INTO user (username, password, email) VALUES ('$username', '$password', '$email')";
if (mysqli_query($conn, $sql)) {
    echo "注册成功";
} else {
    echo "Error: " . $sql . "<br>" . mysqli_error($conn);
}

mysqli_close($conn);
?>

<?php
session_start();

// 连接数据库
$conn = mysqli_connect("localhost","root","root","db_name");
// 检查连接是否成功
if (mysqli_connect_errno()) {
    echo "Failed to connect to MySQL: " . mysqli_connect_error();
    exit();
}

// 接收登录表单提交的数据
$username = $_POST['username'];
$password = $_POST['password'];

// 验证用户名和密码是否匹配
$sql = "SELECT * FROM user WHERE username='$username' AND password='$password'";
$result = mysqli_query($conn, $sql);
if(mysqli_num_rows($result) > 0){
    // 登录成功，保存用户信息到session
    $_SESSION['username'] = $username;
    echo "登录成功";
} else {
    echo "用户名或密码错误";
}

mysqli_close($conn);
?>

<?php
session_start();

// 连接数据库
$conn = mysqli_connect("localhost","root","root","db_name");
// 检查连接是否成功
if (mysqli_connect_errno()) {
    echo "Failed to connect to MySQL: " . mysqli_connect_error();
    exit();
}

// 用户是否登录检查
if (!isset($_SESSION['username'])) {
    echo "请先登录";
    exit();
}

// 获取用户ID
$sql = "SELECT id FROM user WHERE username='{$_SESSION['username']}'";
$result = mysqli_query($conn, $sql);
$row = mysqli_fetch_assoc($result);
$user_id = $row['id'];

// 接收物品发布表单提交的数据
$title = $_POST['title'];
$image = $_POST['image'];
$description = $_POST['description'];
$price = $_POST['price'];

// 将物品信息插入数据库
$sql = "INSERT INTO item (user_id, title, image, description, price) VALUES ($user_id, '$title', '$image', '$description', $price)";
if (mysqli_query($conn, $sql)) {
    echo "物品发布成功";
} else {
    echo "Error: " . $sql . "<br>" . mysqli_error($conn);
}

mysqli_close($conn);
?>

<?php
$conn = mysqli_connect("localhost","root","root","db_name");
// 检查连接是否成功
if (mysqli_connect_errno()) {
    echo "Failed to connect to MySQL: " . mysqli_connect_error();
    exit();
}

// 查询物品信息
$sql = "SELECT * FROM item";
$result = mysqli_query($conn, $sql);

// 输出物品列表
while($row = mysqli_fetch_assoc($result)) {
    echo "物品名称：" . $row['title'] . "<br>";
    echo "物品图片：<img src="" . $row['image'] . ""><br>";
    echo "物品描述：" . $row['description'] . "<br>";
    echo "当前竞价价格：" . $row['price'] . "<br><br>";
}

mysqli_close($conn);
?>

<?php
session_start();

// 连接数据库
$conn = mysqli_connect("localhost","root","root","db_name");
// 检查连接是否成功
if (mysqli_connect_errno()) {
    echo "Failed to connect to MySQL: " . mysqli_connect_error();
    exit();
}

// 用户是否登录检查
if (!isset($_SESSION['username'])) {
    echo "请先登录";
    exit();
}

// 获取用户ID
$sql = "SELECT id FROM user WHERE username='{$_SESSION['username']}'";
$result = mysqli_query($conn, $sql);
$row = mysqli_fetch_assoc($result);
$user_id = $row['id'];

// 接收物品竞价表单提交的数据
$item_id = $_POST['item_id'];
$bid_price = $_POST['bid_price'];

// 更新物品竞价价格
$sql = "UPDATE item SET price=$bid_price WHERE id=$item_id";
if (mysqli_query($conn, $sql)) {
    echo "竞价成功";
} else {
    echo "Error: " . $sql . "<br>" . mysqli_error($conn);
}

mysqli_close($conn);
?>