-
Notifications
You must be signed in to change notification settings - Fork 4
Expand file tree
/
Copy patharticlelist.php
More file actions
172 lines (144 loc) · 6.26 KB
/
articlelist.php
File metadata and controls
172 lines (144 loc) · 6.26 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
<?php
include '../conn.php';
?>
<!DOCTYPE html>
<html lang="zh">
<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1">
<!-- The above 3 meta tags *must* come first in the head; any other head content must come *after* these tags -->
<!-- <meta name="description" content=""> -->
<!-- <meta name="author" content=""> -->
<!-- <link rel="icon" href="../../favicon.ico"> -->
<title>文章管理</title>
<!-- Bootstrap core CSS -->
<link href="./css/bootstrap.min.css" rel="stylesheet">
<!-- IE10 viewport hack for Surface/desktop Windows 8 bug -->
<!-- <link href="../../assets/css/ie10-viewport-bug-workaround.css" rel="stylesheet"> -->
<!-- Custom styles for this template -->
<link href="./css/navbar-fixed-top.css" rel="stylesheet">
<!-- Just for debugging purposes. Don't actually copy these 2 lines! -->
<!--[if lt IE 9]><script src="../../assets/js/ie8-responsive-file-warning.js"></script><![endif]-->
<!-- <script src="../../assets/js/ie-emulation-modes-warning.js"></script> -->
<!-- HTML5 shim and Respond.js for IE8 support of HTML5 elements and media queries -->
<!--[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]-->
<script src="/js/jquery.js"></script>
<script src="./js/bootstrap.min.js"></script>
<!-- IE10 viewport hack for Surface/desktop Windows 8 bug -->
<!-- <script src="../../assets/js/ie10-viewport-bug-workaround.js"></script> -->
</head>
<body>
<!-- Fixed navbar -->
<nav class="navbar navbar-default navbar-fixed-top">
<div class="container">
<div class="navbar-header">
<button type="button" class="navbar-toggle collapsed" data-toggle="collapse" data-target="#navbar" aria-expanded="false" aria-controls="navbar">
<span class="sr-only">Toggle navigation</span>
<span class="icon-bar"></span>
<span class="icon-bar"></span>
<span class="icon-bar"></span>
</button>
<a class="navbar-brand" href="#">后台管理</a>
</div>
<div id="navbar" class="navbar-collapse collapse">
<ul class="nav navbar-nav">
<li><a href="/admin/main.php">首页</a></li>
<li><a href="/admin/goodslist.php">商品管理</a></li>
<li><a href="/admin/userlist.php">用户管理</a></li>
<li class="active"><a href="/admin/articlelist.php">文章管理</a></li>
<li><a href="/admin/advlist.php">广告管理</a></li>
</ul>
<ul class="nav navbar-nav navbar-right">
<li class="active"><a href="/index.php">进入前台 <span class="sr-only">(current)</span></a></li>
</ul>
</div><!--/.nav-collapse -->
</div>
</nav>
<div class="container">
<!-- Main component for a primary marketing message or call to action -->
<div class="jumbotron">
<h1>文章管理</h1>
<p>这里是文章管理，你可以对文章进行增删改查的管理</p>
<p>精彩购物，尽在聚宝盆商城！</p>
</div>
<table class="table table-striped">
<a href="addarticle.php" class="btn btn-success">增加文章</a>
<thead>
<tr>
<th>id</th>
<th>标题</th>
<th>作者</th>
<th>时间</th>
<th>操作</th>
</tr>
</thead>
<tbody>
<?php
$sql = "SELECT * FROM wenzhang";
$result = $conn->query($sql);
if ($result->num_rows > 0) {
// 输出每行数据
while($row = $result->fetch_assoc()) {
?>
<tr>
<td><?php echo $row["id"]; ?></td>
<td><?php echo $row["title"]; ?></td>
<td><?php echo $row["author"]; ?></td>
<td><?php echo $row["time"]; ?></td>
<td>
<a href="editarticle.php?aid=<?php echo $row["id"]; ?>" class="btn btn-primary">编辑</a>
<!-- 按钮触发模态框 -->
<button class="btn btn-danger" data-toggle="modal" onclick="delarticle(<?php echo $row['id']?>)" data-target="#myModal">删除</button>
</td>
</tr>
<?php
}
} else {
echo "0 个结果";
}
$conn->close();
?>
</tbody>
</table>
<!-- 模态框（Modal） -->
<div class="modal fade" id="myModal" tabindex="-1" role="dialog" aria-labelledby="myModalLabel" aria-hidden="true">
<div class="modal-dialog">
<div class="modal-content">
<div class="modal-header">
<button type="button" class="close" data-dismiss="modal" aria-hidden="true">×</button>
<h4 class="modal-title" id="myModalLabel">提示</h4>
</div>
<div class="modal-body">确认是否要删除？</div>
<div class="modal-footer">
<button type="button" class="btn btn-default" data-dismiss="modal">取消</button>
<button type="button" id="del" class="btn btn-danger" >删除</button>
<script type="text/javascript">
function delarticle(articleid) {
$.post("/admin/delarticle.php",{
aid:articleid,
},function(data,status){
sleep(300);
// if (data == 1) {
alert('删除成功！');
// }
//休眠3秒
sleep(300);
//跳转商品列表
location.href="/admin/articlelist.php";
});
}
function sleep(n) { //n表示的毫秒数
var start = new Date().getTime();
while (true) if (new Date().getTime() - start > n) break;
}
</script>
</div>
</div><!-- /.modal-content -->
</div><!-- /.modal -->
</div> <!-- /container -->
</body>
</html>