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的框架
博客内容展示了一段HTML代码，其中`<tr>`标签使用`onclick`属性绑定了一个点击事件，点击表格行时会弹出该行的索引，体现了前端开发中事件交互的应用。
扫一扫
979
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
