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
|
<?php
include_once('../../check_login.php');
ini_set('display_errors',0);
?>
<!DOCTYPE html>
<html>
<head>
<?php include_once('../../head.php'); ?>
<link rel="stylesheet" type="text/css" href="../../css/menu.css"/>
<script type="text/javascript" src="../../js/ddaccordion.js"></script>
<script type="text/javascript" src="../../js/menuddaccordion.js"></script>
<!-- End Main Menu -->
<script type="text/javascript">
function DeleteRow(refid) {
if (confirm("你確認刪除嗎?")) {
window.location.href = 'subscribe_delete.php?refid=' + refid;
}
}
</script>
</head>
<body>
<table width="1200" height="600" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="200" align="left" valign="top">
<table width="200" border="0" cellpadding="0" cellspacing="0">
<tr>
<td height="70" align="left" valign="middle"> </td>
</tr>
<tr>
<td width="200" align="left" valign="top"><!-- Main Menu -->
<?php require("../../menu.php");?><!-- End Main Menu --></td>
</tr>
</table>
</td>
<td align="left" valign="top">
<table border="0" cellpadding="0" cellspacing="0" style="margin-left:10px;">
<tr>
<td>
<table width="800" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="70" class="pagetitletxt"> </td>
<td width="50" align="center" class="icontxt">
<!--<a href="book_form.php"><img src="../../images/iconNew.png" alt="Add" width="32" height="32" border="0"/><br/> 新增
</a>--></td>
</tr>
</table>
</td>
</tr>
<tr>
<td class="pagetitletxt">
<b><img src="../../images/iconList.jpg" width="48" height="48" align="absmiddle"/> 訂閱名單</b></td>
</tr>
<tr>
<td height="25" align="left" valign="middle" class="msg"><?php if (!empty($_GET["msg"])) echo $_GET['msg']; ?></td>
</tr>
<tr>
<td align="left" valign="middle">
<form name="book_sort_update" method="post" action="book_sort_update.php" enctype="multipart/form-data">
<input type="hidden" name="type" value="<?=$type?>"/>
<table width="800" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="150" class="listtitletxt">名稱</td>
<td class="listtitletxt">電郵</td>
<td width="160" class="listtitletxt">訂閱日期</td>
<td width="20" class="listtitletxt"></td>
</tr>
<?php
$sql = "SELECT * FROM subscribe where deleted = ? ORDER BY lastupdate DESC";
$parameters = array("0");
if (!($sth = $dbh->prepare($sql))) {
throw new Exception('[' . $sth->errorCode() . ']: ' . print_r($sth->errorInfo()));
}
if (!$sth->execute($parameters)) {
throw new Exception('[' . $sth->errorCode() . ']: ' . print_r($sth->errorInfo()));
}
while ($row = $sth->fetch(PDO::FETCH_ASSOC)) {
print "<tr>";
print "<td class='listtxt' style='padding-left:5'>" . $row{'name'} . "</td>";
print "<td class='listtxt' style='padding-left:5'>" . $row{'email'} . "</td>";
print "<td class='listtxt' style='padding-left:5'>" . $row{'lastupdate'} . "</td>";
// Delete
print "<td class='listtxt' align='center'><a href='#' onClick=\"DeleteRow(" . $row{'refid'} . ")\"><img src='../../images/btnDelete.png' title='Delete' alt='Delete' hspace='2' border='0'></a></td>";
print "</tr>";
}
$dbh = null;
?>
</table></form>
</td>
</tr>
</table>
</td>
</tr>
</table>
</body>
</html>
|