-
Notifications
You must be signed in to change notification settings - Fork 2
/
Copy pathopinion_info.php
84 lines (75 loc) · 2.93 KB
/
opinion_info.php
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
<?php
session_start();
require_once("db_config.php");
if(!(isset($_SESSION['U_ID']))&& ($_SESSION['U_ID']='manager')){
header("Refresh: 0; url=manager_login.php");
}
if (isset($_GET["id"])) {
$DELETE ="DELETE FROM contact WHERE contact_id=".$_GET["id"];
if(mysqli_query($link,$DELETE)){
mysqli_close($link);
header("Location: opinion_info.php");
}
}
?>
<!DOCTYPE html>
<html>
<head>
<title></title>
<link rel="stylesheet" href="css/opinion_info.css">
<meta name="viewport" content="width=device-width, user-scalable=no, initial-scale=1.0, maximum-scale=1.0, minimum-scale=1.0">
<script src="js/forfun.js"></script>
<script src="https://code.jquery.com/jquery-3.1.0.js"></script>
<meta charset="UTF-8">
</head>
<body background="\images\bg.png">
<div class="abc"><a href="member_info.php"><button type="submit" class="account_manage">帳號管理</button></a></div><br>
<div class="abc"><a href="travel_info_edit.php"><button type="submit" class="add">新增旅遊資訊</button></a></div><br>
<div class="abc"><a href="travel_info_rw.php"><button type="submit" class="message_manage">修改、刪除旅遊資訊</button></a></div>
<div class="clear"></div>
<a href="#top" id="back_to_top">
<img id="back_to_top_pic" src="http://4.bp.blogspot.com/-b7Ev7YbY1yw/VdmyzHNe1FI/AAAAAAAAAIE/CMcNxhnaDoc/s200/ScrollToTop-ARSDK.png" alt=""><br>
</a>
<?php
require_once("db_config.php");
$get_sql = "SELECT contact. * , member.member_name FROM contact LEFT JOIN member ON contact.member_id = member.member_id
ORDER BY contact.contact_type";
$data= mysqli_query($link, $get_sql);
for($i=1;$i<=mysqli_num_rows($data);$i++){
$rs=mysqli_fetch_row($data);
?>
<ul>
<li>
<div class="travel_information">
<div class="travel_pic">
<?php
if (strlen($rs[1]) < 15) {
echo "<img src='picture/head.png' width='225px' height='225px'><br>";
}else{
echo "<img src='https://graph.facebook.com/$rs[1]/picture?type=large'><br>";
}
?>
</div>
<div class="travel_word">
<P>姓名：<?php echo $rs[5]?></P>
<p>意見類型：<?php echo $rs[2]?></p>
<p>主旨：<?php echo $rs[3]?></p>
<p>意見內容：<?php echo $rs[4]?></p>
<a href="opinion_info.php?id=<?php echo $rs[0] ?>"><button type="button" class="delete_information">確定刪除</button></a>
</div>
<div class="clear"></div>
</div>
</li>
</ul>
<?php }?>
</div>
<?php echo "$DELETE";?>
</div>
<div class="footer">
<div class="footer_word"><p><br>For Fun旅遊網<br>拜託PHP讓我過<br>資料、圖片皆來自鳳凰旅行社<br> 期末專題用<br>若造成任何人的不便<br>會立即撤下</p>
</div>
</div>
<script src="js/forfun.js"></script>
<script src="https://code.jquery.com/jquery-3.1.0.js"></script>
</body>
</html>