PHP를 활용하여 개발된 중고 재활용 웹사이트는 반품/교환 기능을 지원합니다.

<?php
// 连接数据库
$conn = mysqli_connect("localhost", "root", "", "recycle");

// 查询用户的订单列表
$query = "SELECT * FROM orders WHERE user_name = '用户名'";
$result = mysqli_query($conn, $query);

// 展示订单列表
while ($row = mysqli_fetch_assoc($result)) {
    echo "<tr>";
    echo "<td>" . $row['id'] . "</td>";
    echo "<td>" . $row['product_id'] . "</td>";
    echo "<td>" . $row['user_name'] . "</td>";
    echo "<td>" . $row['email'] . "</td>";
    echo "<td>" . $row['address'] . "</td>";
    echo "<td>" . $row['order_type'] . "</td>";
    echo "<td>" . $row['create_time'] . "</td>";
    echo "</tr>";
}
?>

<?php
// 连接数据库
$conn = mysqli_connect("localhost", "root", "", "recycle");

// 获取选择的订单ID
$order_id = $_GET['order_id'];

// 查询订单信息
$query = "SELECT * FROM orders WHERE id = $order_id";
$result = mysqli_query($conn, $query);
$row = mysqli_fetch_assoc($result);

// 查询产品信息
$product_id = $row['product_id'];
$query = "SELECT * FROM products WHERE id = $product_id";
$result = mysqli_query($conn, $query);
$product = mysqli_fetch_assoc($result);

// 展示产品信息
echo "<h2>" . $product['name'] . "</h2>";
echo "<p>" . $product['description'] . "</p>";
echo "<p>价格：" . $product['price'] . "</p>";
echo "<img src='" . $product['image'] . "' alt='产品图片'>";

// 展示退货/换货表单
echo "<form action='handle_return.php' method='post'>";
echo "<input type='hidden' name='order_id' value='" . $order_id . "'>";
echo "<textarea name='reason' placeholder='请填写退货/换货原因和要求'></textarea>";
echo "<input type='submit' value='提交'>";
echo "</form>";
?>

<?php
// 连接数据库
$conn = mysqli_connect("localhost", "root", "", "recycle");

// 获取退货/换货请求的订单ID和原因
$order_id = $_POST['order_id'];
$reason = $_POST['reason'];

// 更新订单表中的订单类型为退货/换货
$query = "UPDATE orders SET order_type = 2 WHERE id = $order_id";
mysqli_query($conn, $query);

// 将退货/换货的原因和要求保存到订单表中
$query = "UPDATE orders SET reason = '$reason' WHERE id = $order_id";
mysqli_query($conn, $query);

// 提示退货/换货请求成功
echo "退货/换货请求已提交，我们会尽快处理。";
?>