Repository navigation
Expand file tree
/
Copy patharticle.php
More file actions
182 lines (175 loc) · 9.18 KB
/
Copy patharticle.php
File metadata and controls
182 lines (175 loc) · 9.18 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
173
174
175
176
177
178
179
180
181
182
<?php
//插入连接数据库的相关信息
require_once('./php/mysqli_connect.php');
$error_msg = "";
//判断用户是否已经设置cookie，如果未设置$_COOKIE['user_id']时，执行以下代码
if(!isset($_COOKIE['user_id'])){
if(isset($_POST['submit'])){//判断用户是否提交登录表单，如果是则执行如下代码
// $dbc = mysqli_connect(DB_HOST,DB_USER,DB_PASSWORD,DB_NAME);
$user_username = mysqli_real_escape_string($dbc,trim($_POST['id']));
$user_password = mysqli_real_escape_string($dbc,trim($_POST['pwd']));
// echo $user_username;
// echo $user_password;
if(!empty($user_username)&&!empty($user_password)){
//MySql中的SHA()函数用于对字符串进行单向加密
$query = "SELECT * FROM teacher WHERE tname = '$user_username' AND "."password = '$user_password'";
//用用户名和密码进行查询
$data = mysqli_query($dbc,$query);
if(!$data){
$error_msg = 'Sorry, you must enter a valid username and password to log in.';
}
//若查到的记录正好为一条，则设置COOKIE，同时进行页面重定向
else{
if(mysqli_num_rows($data)==1){
$row = mysqli_fetch_array($data);
setcookie('user_id',$row['tid']);
setcookie('user_name',$row['tname']);
setcookie('user_type','1');
$home_url = './teacher/index.php';
header('Location: '.$home_url);
}
else if(mysqli_num_rows($data)==0){
$query = "SELECT * FROM student WHERE sname = '$user_username' AND "."password = '$user_password'";
$data = mysqli_query($dbc,$query);
if(!$data){
$error_msg = 'Sorry, you must enter a valid username and password to log in.';
}
//若查到的记录正好为一条，则设置COOKIE，同时进行页面重定向
else{
if(mysqli_num_rows($data)==1){
$row = mysqli_fetch_array($data);
setcookie('user_id',$row['sid']);
setcookie('user_name',$row['sname']);
setcookie('user_type','2');
$home_url = './student/index.php';
header('Location: '.$home_url);
}
}
}
}
}else{
$error_msg = 'Sorry, you must enter a valid username and password to log in.';
}
echo $error_msg;
}
}else{//如果用户已经登录，则直接跳转到已经登录页面
// echo "enter else";
if($_COOKIE['user_type']=='1')
$home_url = './teacher/index.php';
else if($_COOKIE['user_type']=='2')
$home_url = './student/index.php';
else
$home_url = './index.php';
header('Location: '.$home_url);
}
require_once('./include/article_index_header.html');
?>
<div class="content-warp" id="barba-wrapper" aria-live="polite">
<div class="container list-container" style="visibility: visible;">
<div class="row">
<div class="col-md-12 main-content-timeline">
<!-- <div>-->
<!-- <button class="btn btn-info">新增文章</button>-->
<!-- </div>-->
<div class="input-group" id="searchContainer" style="position: relative;top: 25px;">
<input type="text" id="searchText" class="form-control">
<span class="input-group-btn">
<button class="btn btn-success" id="search">搜索</button>
</span>
</div>
<div style="position: relative;top: 50px;">
<?php
require_once('./php/mysqli_connect.php');
$display = 10;
if(isset($_GET['search_word']))// 获得搜索词
{
$searchWord = $_GET['search_word'];
}
else{
$searchWord = "";
}
if(isset($_GET['page_num']) AND is_numeric($_GET['page_num']))//获得总页数
{
$pages = $_GET['page_num'];
}
else
{
$query = "select count(id) from article where title like '%$searchWord%'";
$result = @mysqli_query($dbc, $query);
$row = @mysqli_fetch_array($result, MYSQLI_NUM); //从结果集$r得到数字数组
$record = $row[0]; //$row[0]即为count(id)
$pages = ceil($record / $display); //计算总页数，ceil函数向上舍入为最接近的整数
}
if(isset($_GET['start']) && is_numeric($_GET['start']))//获得起始留言编号
{
$start = $_GET['start'];
}
else
{
$start = 0; //如果首次载入页面，则起始编号为0
}
$query = "select id,title,content,DATE_FORMAT(article_date, '%M %d, %Y') as dr from article where title like '%$searchWord%' order by dr limit $start, $display";
$result = @mysqli_query($dbc, $query);
if($result){
while($row = mysqli_fetch_array($result, MYSQLI_ASSOC))//从结果集$r得到关联数组
{
echo '<div class="timeline-post">
<h4 class="post-title">
<a href="./article_detail.php?id='.$row['id'].'" class="animation">'.$row['title'].'</a>
</h4>
<p>'.$row['content'].'...</p>
<p class="time">'.$row['dr'].'</p>
</div>';
}
}
//释放结果集
if($result)
mysqli_free_result($result);
//关闭数据库
mysqli_close($dbc);
//如果页数大于1，则显示分页
if($pages > 1)
{
$current_page = ($start / $display) + 1;
echo '<ul style="position: relative;left: 38%;" class="pagination">';
if($current_page != 1) //当前页不是第一页，则显示向前连接
{
echo '<li><a href="article.php?search_word='.$searchWord.'&start=' . ($start - $display) . '&page_num=' . $pages . '">«</a></li>';
}
if($current_page <= 3)
$page_start = 1;
elseif ($current_page > $pages - 3)
$page_start = $pages - 4;
else
$page_start = $current_page - 2;
if ($pages <=5 )
$page_display = $pages;
else
$page_display = 5;
for ($i=$page_start;$i<($page_display+$page_start);$i++){
if ($i != $current_page)
echo '<li><a href="#">'.$i.'</a></li>';
else
echo '<li class="active"><a href="#">'.$i.'</a></li>';
}
if($current_page != $pages) //当前页不是最后一页，则显示向后连接
{
echo '<li><a href="article.php?search_word='.$searchWord.'&start='.($start + $display).'&page_num='.$pages.'">»</a></li>';
}
echo '</ul>';
}
?>
</div>
</div>
</div>
</div>
</div>
<script>
$("#search").click(function(){
window.location.href="./article.php?search_word="+$("#searchText").val()
});
</script>
<div style="height: 50px;"></div>
<?php
require_once('./include/footer_index.html')
?>