使用PHP開發的商城會員等級與積分關係設計思路

session_start();
$memberId = $_SESSION['memberId'];

// 通过会员ID从数据库中获取会员信息
$sql = "SELECT name, points, level FROM members WHERE id = $memberId";
$result = mysqli_query($connection, $sql);
$row = mysqli_fetch_assoc($result);

$name = $row['name'];
$points = $row['points'];
$level = $row['level'];

// 根据会员等级ID从数据库中获取等级信息
$sql = "SELECT name, discount FROM member_level WHERE id = $level";
$result = mysqli_query($connection, $sql);
$row = mysqli_fetch_assoc($result);

$levelName = $row['name'];
$discount = $row['discount'];

// 在页面中显示会员等级和积分信息
echo "欢迎，$name！您的当前等级是$levelName，您的积分为$points，享受$discount折优惠。";

// 更新会员积分
$deductPoints = 100; // 扣除的积分
$rewardPoints = 50; // 获取的积分
$newPoints = $points - $deductPoints + $rewardPoints;

$sql = "UPDATE members SET points = $newPoints WHERE id = $memberId";
mysqli_query($connection, $sql);

// 记录积分变动明细
$datetime = date("Y-m-d H:i:s");
$sql = "INSERT INTO points_change (member_id, change_type, change_points, datetime) 
        VALUES ($memberId, '订单消费', $deductPoints, '$datetime')";
mysqli_query($connection, $sql);

$sql = "INSERT INTO points_change (member_id, change_type, change_points, datetime) 
        VALUES ($memberId, '积分奖励', $rewardPoints, '$datetime')";
mysqli_query($connection, $sql);