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
|
<?php require_once("check_login.php"); ?>
<!DOCTYPE HTML>
<html>
<head>
<?php require_once("html_head.php"); ?>
<script type="text/javascript">
function DeleteRecord(slideid) {
if (confirm("你確定要刪除?")) {
window.location.href = 'slideshow_delete.php?slideid=' + slideid;
}
}
</script>
</head>
<body>
<table width="1000" 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 width="800" align="left" valign="top">
<table width="800" border="0" cellpadding="0" cellspacing="0">
<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="slideshow_addform.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 (isset($_GET["msg"])) echo $_GET['msg']; ?></td>
</tr>
<tr>
<td align="left" valign="middle">
<table width="800" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="10" class="listtitletxt"></td>
<td width="40" class="listtitletxt">排序</td>
<td width="100" class="listtitletxt">連結</td>
<td width="300" class="listtitletxt">圖片</td>
<td width="100" class="listtitletxt">最近更新</td>
<td width="20" class="listtitletxt"></td>
<td width="20" class="listtitletxt"></td>
<td width="20" class="listtitletxt"></td>
</tr>
<form name="slideshow_sort_update" method="post" action="slideshow_sort_update.php" enctype="multipart/form-data">
<?php
$sql = "SELECT * FROM slideshow where deleted = ? ORDER BY sort ASC, slideid DESC ";
$parameters = array(0);
$row_array = bind_pdo($sql, $parameters, "selectall");
foreach ($row_array as $row) {
print "<tr>";
print "<td class='listtxt' style='padding-left:5'> </td>";
print "<td class='listtxt' valign='middle' align='left'><input class='sortinput' type='text' name='idarraynumber[]' value='" . $row{'sort'} . "' size='2' /><input type='hidden' name='idarray[]' value='" . $row{'slideid'} . "'></td>";
if ($row{'slidelink_tc'} <> '') {
print "<td class='listtxt' style='padding-left:5'>" . $row{'slidelink_tc'} . "</td>";
} else {
print "<td class='listtxt' style='padding-left:5'></td>";
}
$width = "width='300'";
if ($row{'slideimg_tc'} <> '') {
print "<td class='listtxt' style='padding-left:5'><img src='../images/slideshow/" . $row{'slideimg_tc'} . "' " . $width . " border='0'></td>";
} else {
print "<td class='listtxt' style='padding-left:5'></td>";
}
print "<td class='listtxt' style='padding-left:5'>" . $row{"lastupdate"} . "</td>";
//Status
print "<td class='listtxt' align='center'>";
if ($row{'status'} == '1') // Enable
{
print "<a href='slideshow_status.php?slideid=" . $row{'slideid'} . "'>";
print "<img src='images/tick.png' title='Enable' alt='Enable' border='0' hspace='2'></a>";
} else // Disable
{
print "<a href='slideshow_status.php?slideid=" . $row{'slideid'} . "'>";
print "<img src='images/cross.png' title='Disable' alt='Disable' border='0' hspace='2'></a>";
}
print "</td>";
// Modify
print "<td class='listtxt' align='center'><a href='#' onClick=\"window.location='slideshow_modifyform.php?slideid=" . $row{'slideid'} . "'\"><img src='images/btnModify.png' title='Modify' alt='Modify' hspace='2' border='0'></a></td>";
// Delete
print "<td class='listtxt' align='center'><a href='#' onClick=\"DeleteRecord(" . $row{'slideid'} . ")\"><img src='images/btnDelete.png' title='Delete' alt='Delete' hspace='2' border='0'></a></td>";
print "</tr>";
}
?>
</table>
<input type="submit" value="更新排序"></form>
</td>
</tr>
</table>
</td>
</tr>
</table>
</body>
</html>
|