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');
?>

<?php
// 1. 获取订单数据（已省略）

// 2. 初始化 PayPal 付款
$apiContext = new PayPal\Rest\ApiContext(
    new PayPal\Auth\OAuthTokenCredential(
        'YOUR_CLIENT_ID',
        'YOUR_CLIENT_SECRET'
    )
);
$payment = new PayPal\Api\Payment();
$payment->setIntent('sale');

// 3. 添加交易项目
$itemList = new PayPal\Api\ItemList();
foreach ($order_items as $item) {
    $productInfo = new PayPal\Api\Product();
    $productInfo->setName($item['name']);
    $productInfo->setDescription($item['description']);

    $item = new PayPal\Api\Item();
    $item->setName($item['name']);
    $item->setQuantity($item['quantity']);
    $item->setCurrency('USD');
    $item->setPrice($item['price']);
    $item->setProductInfo($productInfo);

    $itemList->addItem($item);
}

$payment->setItemList($itemList);

// 4. 执行 PayPal 付款并获取付款 ID
$transaction = new PayPal\Api\Transaction();
$amount = new PayPal\Api\Amount();
$amount->setTotal($order_total);
$amount->setCurrency('USD');
$transaction->setAmount($amount);

$payment->addTransaction($transaction);
$response = $payment->create($apiContext);

// 5. 重定向到 PayPal 付款确认页
header('Location: ' . $response->getApprovalLink() . '&useraction=commit');
?>