?? edit.asp
字號:
<!--#include file="conn.asp"-->
<!--#include file="session.asp"-->
<HTML><HEAD><title>客戶資料編輯息---SMS-GIS管理系統</title>
<META http-equiv=Content-Type content="text/html; charset=gb2312">
<LINK href="img/css.css" type=text/css rel=stylesheet>
<style type="text/css">
<!--
body {
margin-left: 0px;
margin-top: 0px;
margin-right: 0px;
margin-bottom: 0px;
background-color: #EEEEEE;
}
-->
</style>
<!--#include file="top.asp"-->
<table width="720" height="243" border="0" cellpadding="0" cellspacing="0" align=center>
<tr>
<td align="center" valign="top" bgcolor="#F9F9F9"><form name="form1" method="post" action="edit.asp">
<%if request.Form("sub")="sub" then
id=request.Form("id")
other_name=request.Form("other_name")
other_mobile=request.Form("other_mobile")
content=request.Form("content")
set rs=server.CreateObject("adodb.recordset")
sql="select * from person_sms where id="&id
rs.open sql,conn,3,3
rs("id")=id
rs("other_name")=other_name
rs("other_mobile")=other_mobile
rs("content")=content
rs.update
rs.close
set rs=nothing
conn.close
set conn=nothing
response.write "<SCRIPT language=JavaScript>alert('編輯成功！');"
response.write "this.location.href='admin.asp';</SCRIPT>"
response.End()
end if
%>
<%
id=cint(request.QueryString("id"))
if id<>"" then
set rs2=server.CreateObject("adodb.recordset")
sql2="select * from person_sms where id="&id
rs2.open sql2,conn,1,1
%>
<table width="325" height="219" border="0" cellpadding="0" cellspacing="1" bgcolor="#666666" align=center>
<tr align="center">
<td colspan="2" height="45" style="background-color: #D4D0C8">
<font color="#0066CC" style="font-size: 9pt"><b>編 輯 短 信</b></font></td>
</tr>
<tr bgcolor="#FFFFFF">
<td width="99" align="center" height="30"><span style="font-size: 9pt">序 號:</span></td>
<td width="223"><span style="font-size: 9pt"><input type="hidden" name="id" value="<%=rs2("id")%>">
</span><span style="font-size: 9pt"> <%=rs2("id")%></span></td>
</tr>
<tr bgcolor="#FFFFFF">
<td width="99" align="center" bgcolor="#CCCCCC" height="30">
<span style="font-size: 9pt">來 電 姓 名:</span></td>
<td width="223" bgcolor="#CCCCCC">
<span style="font-size: 9pt">
<input name="other_name" type="text" size="20" value="<%=rs2("other_name")%>"></span></td>
</tr>
<tr bgcolor="#FFFFFF">
<td width="99" align="center" height="30"><span style="font-size: 9pt">來 電 號 碼:</span></td>
<td width="223">
<span style="font-size: 9pt">
<input name="other_mobile" type="text" size="20" value="<%=rs2("other_mobile")%>"></span></td>
</tr>
<tr bgcolor="#FFFFFF">
<td width="99" align="center" bgcolor="#CCCCCC" height="30">
<span style="font-size: 9pt">來 電 內 容:</span></td>
<td width="223" bgcolor="#CCCCCC">
<span style="font-size: 9pt">
<input name="content" type="text" size="20" value="<%=rs2("content")%>"></span></td>
</tr>
<tr align="center">
<td colspan="2" bgcolor="#F7F7F7" height="40">
<span style="font-size: 9pt">
<input type="submit" name="Submit" value="確定修改">
<input type="reset" name="Submit" value="返回原始值">
<input type="hidden" name="sub" value="sub">
</span>
</td>
</tr>
</table>
<table border="0" width="780" id="table1" cellspacing="0" cellpadding="0">
<tr>
<td height="50" style="background-color: #F7F7F7">
<p align="center"><span style="font-size: 10pt">‖ <a href='javascript:history.back()'><font color="#FF3300">返回</font></a> ‖<font color="#0000FF">
<b> </b></font><b><a href="session_out.asp"><font color="#FF3300">退出系統</font></a>
</b><font color="#0000FF"> </font>‖</span></td>
</tr>
</table>
</form><%end if%></td>
</tr>
</table>
</center>
</body>
</html> ?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -