prepare("INSERT INTO point_transactions
(user_id, amount, type, description, status, created_at)
VALUES (?, ?, 'recharge', ?, 'completed', NOW())");
$stmt->bind_param("iis", $_SESSION['user_id'], $points_added, $transaction_desc);
$stmt->execute();
$stmt->close();
} else {
$_SESSION['error'] = "卡密无效或已被使用";
}
}
header("Location: recharge.php");
exit;
}
// 获取用户当前积分
$stmt = $conn->prepare("SELECT points FROM users WHERE id = ?");
$stmt->bind_param("i", $_SESSION['user_id']);
$stmt->execute();
$result = $stmt->get_result();
$user = $result->fetch_assoc();
?>
| 时间 |
类型 |
积分 |
状态 |
描述 |
prepare("SELECT * FROM point_transactions
WHERE user_id = ? AND type = 'recharge'
ORDER BY created_at DESC");
$stmt->bind_param("i", $_SESSION['user_id']);
$stmt->execute();
$result = $stmt->get_result();
if ($result->num_rows > 0):
while($row = $result->fetch_assoc()):
?>
|
充值 |
+ |
已完成 |
|
|
暂无充值记录
|