look54.php:
<?php
session_start();
require "../db54.php";
if(!isset($_SESSION["username"])) {
header("Location: ../login54.php");
exit;
}
$user = $_SESSION["username"];
?>
<!DOCTYPE html>
<html>
<head>
<title>我的购物车</title>
<style>
table { width: 100%; border-collapse: collapse; }
th, td { padding: 8px; text-align: left; border-bottom: 1px solid #ddd; }
img { max-width: 100px; }
</style>
<script>
function openme(row) {
row.style.backgroundColor = "#FFFFCC";
}
function closeme(row) {
row.style.backgroundColor = (row.rowIndex % 2 == 1 ? "#F0F0F0" : "");
}
function op(button, id) {
// Implement quantity increase/decrease logic
}
function select_all() {
// Implement select all checkboxes
}
function reset_all() {
// Implement reset all checkboxes
}
function delete_all() {
// Implement delete selected items
}
function na() {
return confirm("确定要移除该商品吗?");
}
function op(t,id) {
value=t.value; //按钮上显示的文字
if(value=='+') { //带参数跳转，兼容Google.ie
parent.top.window.location="look54.php?op=add&id="+id;
}
if(value=='-') {
parent.top.window.location="look54.php?op=sub&id="+id;
}
}
</script>
</head>
<body>
<h2>我的购物车</h2>
<?php
// 显示当前用户信息 - 统一使用username
if(isset($_SESSION['username'])) {
echo "<p>查看购物车 | 当前用户：" . htmlspecialchars($user) . "</p>";
?>
<form name="cartForm" method="post">
<table border=0 align=center width=100% cellspacing=0 bordercolordark=#9CC7EF cellpadding=4 style="line-height:35px">
<tr bgcolor="#FDF5E6">
<th>选择</th>
<th>商品名称</th>
<th>商品
图片</th>
<th>订阅数量</th>
<th>单价</th>
<th>操作</th>
</tr>
<?php
// 处理"拿掉该商品"超链接删除
if(isset($_GET['id']) && $_GET["op"]=="移除") {
$id = $_GET['id'];
$sql = "DELETE FROM dingdan54 WHERE id = $id";
if($db54->write($sql)) {
echo "<script>alert('拿掉商品成功！')</script>";
} else {
echo "<script>alert('拿掉商品失败！')</script>";
echo "<script>location.href('look54.php')</script>";
}
}
// 处理增减按钮+-操作
if(isset($_GET["op"])) {
$op = $_GET["op"];
$id = $_GET['id'];
//
获取当前数量
$sql = "SELECT * FROM dingdan54 WHERE id = $id";
$result = $db54->read($sql);
if(count($result) > 0) {
$current_num = $result[0]['num'];
if($op == "add") {
$new_num = $current_num + 1;
} elseif($op == "sub" && $current_num > 1) {
$new_num = $current_num - 1;
} else {
$new_num = $current_num;
}
// 更新数量
$update_sql = "UPDATE dingdan54 SET num = $new_num WHERE id = $id";
$db54->write($update_sql);
}
}
// 处理"拿掉选中商品"按钮
if(isset($_GET["str"])) {
$ids = explode("|", trim($_GET["str"], "|"));
foreach($ids as $id) {
if(is_numeric($id)) {
$sql = "DELETE FROM dingdan54 WHERE id = $id";
$db54->write($sql);
}
}
echo "<script>alert('拿掉商品成功！')</script>";
echo "<script>location.href('look54.php')</script>";
}
// 显示购物车
$cart_sql = "SELECT dingdan54.id AS id, sp54.name AS name, sp54.photo AS photo, SUM(dingdan54.num)
AS total_num, sp54.money AS money FROM sp54
JOIN dingdan54 ON sp54.id = dingdan54.sp_id
WHERE sp54.id = dingdan54.sp_id AND dingdan54.user = '$user' AND dingdan54.flag = 0
GROUP BY sp54.id, sp54.name, sp54.photo, sp54.money";
$cart_result = $db54->read($cart_sql);
$n = count($cart_result);
if ($n == 0) {
echo "<tr><td colspan='6'>购物车是空的!</td></tr>";
}else{
for ($i = 0; $i < $n; $i++) {
$item = $cart_result[$i];
echo "<tr " . ($i % 2 == 1 ? "bgcolor='#F0F0F0'" : "") . " onmouseover='openme(this)' onmouseout='closeme(this)'>";
echo "<td><input type='checkbox' name='flag' value='{$item['id']}'></td>";
echo "<td>{$item['name']}</td>";
echo "<td><img src='
images/{$item['photo']}' width='30' height='30'></td>";
echo "<td><input type='button' name='enter' value='-' onclick='op(this, {$item['id']})'>
<input type='text' name='num{$item['id']}' readonly size='3'
style='text-align:center' value='{$item['total_num']}'>
<input type='button' name='enter' value='+' onclick='op(this, {$item['id']})'></td>";
echo "<td>{$item['money']}元</td>";
echo "<td><a href='look54.php?op=移除&id={$item['id']}' onclick='return na()'>
移除该商品</a></td>";
echo "</tr>";
}
}
?>
<tr align="center">
<td colspan="5" style="padding-top:8px;">
<input type="button" name="enter" value="全选" onclick="select_all()">
<input type="button" name="enter" value="全部取消" onclick="reset_all()">
<input type="button" name="enter" value="删除选中商品" onclick="delete_all()">
</td>
</tr>
</table>
<?php
$total_sql = "SELECT sp54.money AS money, dingdan54.num AS num
FROM sp54, dingdan54
WHERE sp54.id = dingdan54.sp_id AND dingdan54.user = '$user'
AND dingdan54.flag = 0";
$total_result = $db54->read($total_sql);
$sum = 0;
foreach ($total_result as $item) {
$sum += $item["money"] * $item["num"];
}
echo "应付金额：<b><font color=#FF0000>¥";
echo $sum . " 元";
echo " <a href='trolley54.php'>| 去付款</a>";
?>
</form>
<a href="index54.php">继续购物</a>
<?php } ?>
</body>
</html>
l54.php:
<?php
include('../db54.php');
session_start();
$user_id=$_SESSION["id"]?? 0;
$sql="select * from user54 where id='$user_id'";
$result=$db54->read($sql);
$username=$result[0]["username"];
?>
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<title>信安28班54何雨霏PHP实训</title>
<meta name="description" content="">
<meta name="viewport" content="width=device-width, initial-scale=1">
<meta name="robots" content="all,follow">
<link rel="stylesheet" href="../css/bootstrap.css">
<!-- Bootstrap CSS-->
<link rel="stylesheet" href="https://www.jq22.com/jquery/bootstrap-4.2.1.css">
<!-- Font Awesome CSS-->
<link rel="stylesheet" href="https://www.jq22.com/jquery/font-awesome.4.7.0.css">
<!-- Fontastic Custom icon font-->
<link rel="stylesheet" href="css/fontastic.css">
<!-- Google fonts - Roboto -->
<link rel="stylesheet" href="https://fonts.googleapis.com/css?family=Roboto:300,400,500,700">
<!-- jQuery Circle-->
<link rel="stylesheet" href="css/grasp_mobile_progress_circle-1.0.0.min.css">
<!-- Custom Scrollbar-->
<link rel="stylesheet" href="vendor/malihu-custom-scrollbar-plugin/jquery.mCustomScrollbar.css">
<!-- theme stylesheet-->
<link rel="stylesheet" href="css/style.default.css" id="theme-stylesheet">
<!-- Custom stylesheet - for your changes-->
<link rel="stylesheet" href="css/custom.css">
<!-- Favicon-->
<link rel="shortcut icon" href="img/favicon.ico">
<!-- Tweaks for older IEs--><!--[if lt IE 9]>
<script src="https://oss.maxcdn.com/html5shiv/3.7.3/html5shiv.min.
js"></script>
<script src="https://oss.maxcdn.com/respond/1.4.2/respond.min.
js"></script><![endif]-->
</head>
<body>
<!-- Side Navbar -->
<nav class="side-navbar">
<div class="side-navbar-wrapper">
<!-- Sidebar Header -->
<div class="sidenav-header d-flex align-items-center justify-content-center">
<!-- User Info-->
<div class="sidenav-header-inner text-center"><img src="img/avatar-7.jpg" alt="person" class="img-fluid rounded-circle">
<h2 class="h5">Nathan Andrews</h2><span>Web Developer</span>
</div>
<!-- Small Brand information, appears on minimized sidebar-->
<div class="sidenav-header-logo"><a href="index.html" class="brand-small text-center"> <strong>B</strong><strong class="text-primary">D</strong></a></div>
</div>
<!-- Sidebar Navigation Menus-->
<div class="main-menu">
<h5 class="sidenav-heading">Main</h5>
<ul id="side-main-menu" class="side-menu list-unstyled">
<li><a href="../index.php"> <i class="icon-home"></i>何雨霏的留言板 </a></li>
<li><a href="forms.html"> <i class="icon-form"></i>实训页面1 </a></li>
<li><a href="charts.html"> <i class="fa fa-bar-chart"></i>实训页面2 </a></li>
<li><a href="tables.html"> <i class="icon-grid"></i>实训页面3 </a></li>
<li><a href="#exampledropdownDropdown" aria-expanded="false" data-toggle="collapse"> <i class="icon-interface-windows"></i>Example dropdown </a>
<ul id="exampledropdownDropdown" class="collapse list-unstyled ">
<li><a href="#">admin</a></li>
<li><a href="#">查看购物车</a></li>
<li><a href="#">后台管理</a></li>
</ul>
</li>
<li><a href="login.html"> <i class="icon-interface-windows"></i>Login page </a></li>
<li> <a href="#"> <i class="icon-mail"></i>Demo
<div class="badge badge-warning">6 New</div></a></li>
</ul>
</div>
<div class="admin-menu">
<h5 class="sidenav-heading">Second menu</h5>
<ul id="side-admin-menu" class="side-menu list-unstyled">
<li> <a href="#"> <i class="icon-screen"> </i>admin</a></li>
<li> <a href=""> <i class="icon-screen"> </i>查看购物车</a></li>
<li> <a href=""> <i class="icon-screen"> </i>后台管理</a></li>
</ul>
</div>
</div>
</nav>
<div class="page">
<!-- navbar-->
<header class="header">
<nav class="navbar">
<div class="container-fluid">
<div class="navbar-holder d-flex align-items-center justify-content-between">
<div class="navbar-header"><a id="toggle-btn" href="#" class="menu-btn"><i class="icon-bars"> </i></a><a href="index.html" class="navbar-brand">
<div class="brand-text d-none d-md-inline-block"><span>
<?php
?>
</span><strong class="text-primary">信安28班54何雨霏PHP实训 <?php echo $username; ?></strong></div></a></div>
<ul class="nav-menu list-unstyled d-flex flex-md-row align-items-md-center">
<!-- Notifications dropdown-->
<li class="nav-item dropdown"> <a id="notifications" rel="nofollow" data-target="#" href="#" data-toggle="dropdown" aria-haspopup="true" aria-expanded="false" class="nav-link"><i class="fa fa-bell"></i><span class="badge badge-warning">12</span></a>
<ul aria-labelledby="notifications" class="dropdown-menu">
<li><a rel="nofollow" href="#" class="dropdown-item">
<div class="notification d-flex justify-content-between">
<div class="notification-content"><i class="fa fa-envelope"></i>You have 6 new messages </div>
<div class="notification-time"><small>4 minutes ago</small></div>
</div></a></li>
<li><a rel="nofollow" href="#" class="dropdown-item">
<div class="notification d-flex justify-content-between">
<div class="notification-content"><i class="fa fa-twitter"></i>You have 2 followers</div>
<div class="notification-time"><small>4 minutes ago</small></div>
</div></a></li>
<li><a rel="nofollow" href="#" class="dropdown-item">
<div class="notification d-flex justify-content-between">
<div class="notification-content"><i class="fa fa-upload"></i>Server Rebooted</div>
<div class="notification-time"><small>4 minutes ago</small></div>
</div></a></li>
<li><a rel="nofollow" href="#" class="dropdown-item">
<div class="notification d-flex justify-content-between">
<div class="notification-content"><i class="fa fa-twitter"></i>You have 2 followers</div>
<div class="notification-time"><small>10 minutes ago</small></div>
</div></a></li>
<li><a rel="nofollow" href="#" class="dropdown-item all-notifications text-center"> <strong> <i class="fa fa-bell"></i>view all notifications </strong></a></li>
</ul>
</li>
<!-- Messages dropdown-->
<li class="nav-item dropdown"> <a id="messages" rel="nofollow" data-target="#" href="#" data-toggle="dropdown" aria-haspopup="true" aria-expanded="false" class="nav-link"><i class="fa fa-envelope"></i><span class="badge badge-info">10</span></a>
<ul aria-labelledby="notifications" class="dropdown-menu">
<li><a rel="nofollow" href="#" class="dropdown-item d-flex">
<div class="msg-profile"> <img src="img/avatar-1.jpg" alt="..." class="img-fluid rounded-circle"></div>
<div class="msg-body">
<h3 class="h5">Jason Doe</h3><span>sent you a direct message</span><small>3 days ago at 7:58 pm - 10.06.2019</small>
</div></a></li>
<li><a rel="nofollow" href="#" class="dropdown-item d-flex">
<div class="msg-profile"> <img src="img/avatar-2.jpg" alt="..." class="img-fluid rounded-circle"></div>
<div class="msg-body">
<h3 class="h5">Frank Williams</h3><span>sent you a direct message</span><small>3 days ago at 7:58 pm - 10.06.2019</small>
</div></a></li>
<li><a rel="nofollow" href="#" class="dropdown-item d-flex">
<div class="msg-profile"> <img src="img/avatar-3.jpg" alt="..." class="img-fluid rounded-circle"></div>
<div class="msg-body">
<h3 class="h5">Ashley Wood</h3><span>sent you a direct message</span><small>3 days ago at 7:58 pm - 10.06.2019</small>
</div></a></li>
<li><a rel="nofollow" href="#" class="dropdown-item all-notifications text-center"> <strong> <i class="fa fa-envelope"></i>Read all messages </strong></a></li>
</ul>
</li>
<!-- Languages dropdown -->
<li class="nav-item dropdown"><a id="languages" rel="nofollow" data-target="#" href="#" data-toggle="dropdown" aria-haspopup="true" aria-expanded="false" class="nav-link language dropdown-toggle"><img src="img/flags/16/GB.png" alt="English"><span class="d-none d-sm-inline-block">English</span></a>
<ul aria-labelledby="languages" class="dropdown-menu">
<li><a rel="nofollow" href="#" class="dropdown-item"> <img src="img/flags/16/DE.png" alt="English" class="mr-2"><span>German</span></a></li>
<li><a rel="nofollow" href="#" class="dropdown-item"> <img src="img/flags/16/FR.png" alt="English" class="mr-2"><span>French </span></a></li>
</ul>
</li>
<!-- Log out-->
<li class="nav-item"><a href="login.html" class="nav-link logout"> <span class="d-none d-sm-inline-block">Logout</span><i class="fa fa-sign-out"></i></a></li>
</ul>
</div>
</div>
</nav>
</header>
<section>
<?php require "daohang54.php"; ?>
<div class="main">
<?php require "look54.php"; ?>
</div>
</section>
<footer class="main-footer">
<div class="container-fluid">
<div class="row">
<div class="col-sm-6">
<p>Copyright © 信安28班54何雨霏《Web应用与安全管理实训》 All rights reserved.</p>
</div>
<!--<div class="col-sm-6 text-right"></div>-->
</div>
</div>
</div>
</footer>
</div>
<!-- JavaScript files-->
<script src="https://www.jq22.com/jquery/jquery-1.10.2.
js"></script>
<script src="vendor/popper.
js/umd/popper.min.
js"> </script>
<script src="https://www.jq22.com/jquery/bootstrap-4.2.1.
js"></script>
<script src="
js/grasp_mobile_progress_circle-1.0.0.min.
js"></script>
<script src="vendor/jquery.cookie/jquery.cookie.
js"> </script>
<script src="vendor/chart.
js/Chart.min.
js"></script>
<script src="vendor/jquery-validation/jquery.validate.min.
js"></script>
<script src="vendor/malihu-custom-scrollbar-plugin/jquery.mCustomScrollbar.concat.min.
js"></script>
<script src="
js/charts-home.
js"></script>
<!-- Main File-->
<script src="
js/front.
js"></script>
</body>
</html>
页面能显示look54的内容，不能显示l54的框架
本文介绍了一种在JSP页面中获取项目路径的方法，通过使用request对象获取上下文路径，并利用JavaScript来读取页面元素的数据属性，实现路径的动态获取。
扫一扫
1016
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
