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==&
#39;+&
#39;) { //带参数
跳转，兼容Google.ie
parent.top.window.location="look54.php?op=add&id="+id;
}
if(value==&
#39;-&
#39;) {
parent.top.window.location="look54.php?op=sub&id="+id;
}
}
</script>
</head>
<body>
<h2>我的购物车</h2>
<?php
// 显示当前用户信息 - 统一使用username
if(isset($_SESSION[&
#39;username&
#39;])) {
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[&
#39;id&
#39;]) && $_GET["op"]=="移除") {
$id = $_GET[&
#39;id&
#39;];
$sql = "DELETE FROM dingdan54 WHERE id = $id";
if($db54->write($sql)) {
echo "<script>alert(&
#39;拿掉商品成功！&
#39;)</script>";
} else {
echo "<script>alert(&
#39;拿掉商品失败！&
#39;)</script>";
echo "<script>location.href(&
#39;look54.php&
#39;)</script>";
}
}
// 处理增减按钮+-操作
if(isset($_GET["op"])) {
$op = $_GET["op"];
$id = $_GET[&
#39;id&
#39;];
// 获取当前数量
$sql = "SELECT * FROM dingdan54 WHERE id = $id";
$result = $db54->read($sql);
if(count($result) > 0) {
$current_num = $result[0][&
#39;num&
#39;];
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(&
#39;拿掉商品成功！&
#39;)</script>";
echo "<script>location.href(&
#39;look54.php&
#39;)</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 = &
#39;$user&
#39; 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=&
#39;6&
#39;>购物车是空的!</td></tr>";
}else{
for ($i = 0; $i < $n; $i++) {
$item = $cart_result[$i];
echo "<tr " . ($i % 2 == 1 ? "bgcolor=&
#39;
#F0F0F0&
#39;" : "") . " onmouseover=&
#39;openme(this)&
#39; onmouseout=&
#39;closeme(this)&
#39;>";
echo "<td><input type=&
#39;checkbox&
#39; name=&
#39;flag&
#39; value=&
#39;{$item[&
#39;id&
#39;]}&
#39;></td>";
echo "<td>{$item[&
#39;name&
#39;]}</td>";
echo "<td><img src=&
#39;images/{$item[&
#39;photo&
#39;]}&
#39; width=&
#39;30&
#39; height=&
#39;30&
#39;></td>";
echo "<td><input type=&
#39;button&
#39; name=&
#39;enter&
#39; value=&
#39;-&
#39; onclick=&
#39;op(this, {$item[&
#39;id&
#39;]})&
#39;>
<input type=&
#39;text&
#39; name=&
#39;num{$item[&
#39;id&
#39;]}&
#39; readonly size=&
#39;3&
#39;
style=&
#39;text-align:center&
#39; value=&
#39;{$item[&
#39;total_num&
#39;]}&
#39;>
<input type=&
#39;button&
#39; name=&
#39;enter&
#39; value=&
#39;+&
#39; onclick=&
#39;op(this, {$item[&
#39;id&
#39;]})&
#39;></td>";
echo "<td>{$item[&
#39;money&
#39;]}元</td>";
echo "<td><a href=&
#39;look54.php?op=移除&id={$item[&
#39;id&
#39;]}&
#39; onclick=&
#39;return na()&
#39;>
移除该商品</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 = &
#39;$user&
#39;
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=&
#39;trolley54.php&
#39;>| 去付款</a>";
?>
</form>
<a href="index54.php">继续购物</a>
<?php } ?>
</body>
</html>
l54.php:
<?php
include(&
#39;../db54.php&
#39;);
session_start();
$user_id=$_SESSION["id"]?? 0;
$sql="select * from user54 where id=&
#39;$user_id&
#39;";
$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的框架
扫一扫
3844
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
