PHP 전자상거래 시스템 개발: 기능에 대한 자세한 설명

<?php
// 1. 获取产品数据
$name = $_POST['name'];
$description = $_POST['description'];
$price = $_POST['price'];

// 2. 建立数据库连接并查询语句
$mysqli = new mysqli('localhost', 'user', 'password', 'database');
$stmt = $mysqli->prepare('INSERT INTO products (name, description, price) VALUES (?, ?, ?)');
$stmt->bind_param('sss', $name, $description, $price);

// 3. 执行查询并关闭连接
$stmt->execute();
$stmt->close();
$mysqli->close();

// 4. 重定向到产品列表页
header('Location: product-list.php');
?>

<?php
// 1. 获取订单数据
$customer_id = $_POST['customer_id'];
$product_id = $_POST['product_id'];
$quantity = $_POST['quantity'];

// 2. 建立数据库连接并查询语句
$mysqli = new mysqli('localhost', 'user', 'password', 'database');
$stmt = $mysqli->prepare('INSERT INTO orders (customer_id, product_id, quantity) VALUES (?, ?, ?)');
$stmt->bind_param('iii', $customer_id, $product_id, $quantity);

// 3. 执行查询并关闭连接
$stmt->execute();
$stmt->close();
$mysqli->close();

// 4. 发送订单确认邮件
$to = 'customer@example.com';
$subject = '订单确认';
$message = '感谢您的订单！您的订单号为：' . $order_id;
mail($to, $subject, $message);

// 5. 重定向到订单列表页
header('Location: order-list.php');
?>

<?php
// 1. 获取客户数据
$name = $_POST['name'];
$email = $_POST['email'];
$password = $_POST['password'];

// 2. 建立数据库连接并查询语句
$mysqli = new mysqli('localhost', 'user', 'password', 'database');
$stmt = $mysqli->prepare('INSERT INTO customers (name, email, password) VALUES (?, ?, ?)');
$stmt->bind_param('sss', $name, $email, $password);

// 3. 执行查询并关闭连接
$stmt->execute();
$stmt->close();
$mysqli->close();

// 4. 发送欢迎电子邮件
$to = $email;
$subject = '欢迎来到我们的商店！';
$message = '感谢您注册！您现在可以享受我们广泛的产品和优惠。';
mail($to, $subject, $message);

// 5. 重定向到登录页
header('Location: login.php');
?>