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
|
<?php
include_once('../../check_login.php');
ini_set('display_errors',0);
$id = $_GET['refid'];
?>
<!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 = 'aerospace_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="aerospacetitletxt"> </td>
<td width="50" align="center" class="icontxt">
<a href="aerospace_form.php?type=<?=$type?>"><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="aerospace_sort_update" method="post" action="aerospace_sort_update.php" enctype="multipart/form-data">
<table width="800" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="10" class="listtitletxt"></td>
<td width="150" class="listtitletxt">年份</td>
<td class="listtitletxt">內容</td>
<td width="20" class="listtitletxt"></td>
<td width="20" class="listtitletxt"></td>
<td width="20" class="listtitletxt"></td>
</tr>
<?php
$sql = "SELECT * FROM aerospace where deleted = ? ORDER BY year ASC";
$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'> </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{'refid'} . "'></td>";
if ($row{'year'} <> '') {
print "<td class='listtxt' style='padding-left:5'>" . $row{'year'} . "</td>";
} else {
print "<td class='listtxt' style='padding-left:5'></td>";
}
if ($row{'intro_tc'} <> '') {
print "<td class='listtxt' style='padding-left:5'>" . $row{'intro_tc'} . "</td>";
} else {
print "<td class='listtxt' style='padding-left:5'></td>";
}
//Status
print "<td class='listtxt' align='center'>";
if ($row{'status'} == '1') // Enable
{
print "<a href='aerospace_status.php?refid=".$row{'refid'}."'>";
print "<img src='../../images/tick.png' title='Enable' alt='Enable' border='0' hspace='2'></a>";
} else // Disable
{
print "<a href='aerospace_status.php?refid=".$row{'refid'}."'>";
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='aerospace_form.php?refid=".$row['refid']."'\"><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=\"DeleteRow(" . $row{'refid'} . ")\"><img src='../../images/btnDelete.png' title='Delete' alt='Delete' hspace='2' border='0'></a></td>";
print "</tr>";
}
$dbh = null;
?>
</table><br>
<!--<input type="submit" value="更新排序">--></form>
</td>
</tr>
</table>
</td>
</tr>
</table>
</body>
</html>
|