updateeng.asp

来自「ASP+SQL Server动态网站开发从基础到实践教程」· ASP 代码 · 共 82 行

ASP
82 行
字号 
<%

'set cookie...
if Request.Form("polli") = "" then
	Response.Redirect ("poll.asp")
end if

cook = request.cookies("poll")

'Voted before ?
If cook = "" Then
	response.cookies("poll").Expires = date + 30
	response.cookies("poll") = "polli"
End If

%>

<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1250">
<meta name="GENERATOR" content="Microsoft FrontPage 6.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<link rel="stylesheet" href="stili.css" type="text/css">
<title>Poll - update database</title>
</head>

<body>
<%
'no cookie.. vote granted...
if cook = "" then
%>

<%  
	'create connection
	set conn = server.CreateObject ("ADODB.Connection")
	conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & server.MapPath ("fpdb/engglas.mdb")
	'query to open data for input...
	sql = "SELECT * FROM vote where answer = '" & Request.form("polli") & "'"
	set rs = server.CreateObject ("ADODB.Recordset")
	rs.Open sql, conn, 3, 3	
%>

<%  
	'add one vote...
	a = rs.Fields("novote")
	a = int(a) + int(1)
	rs.Fields("novote") = a
	'update database..
	rs.Update
%>


<%	'close connection and recordset...
	rs.Close
	set rs = nothing
	conn.Close
	set conn = nothing
%>

<%
'after update redirect to vote results...
Response.Redirect("vote.asp?sql=" & (Request.QueryString("title")))
%>

<%
else
%>
<table width="200" border="1" cellspacing="0" align="center" style="border-collapse: collapse" cellpadding="10" bordercolor="#000000">
	<tr> 
	<td bgcolor="#ADD8E6" align="center"><span class="nortxtv10">
	<font color="#FF0000"><b>&#20320;</b></font><font color="red"><b>&#24050;&#32463;&#25237;&#31080;&#25104;&#21151;!</b>
	</font><p></p>
	&#35874;&#35874;!<p></p><a href="javascript:history.go(-1)">&#36820;&#22238;</a></span></td>
	</tr>
</table>
<%
end if
%>

</body>
</html>

updateeng.asp - 源码说明

本页面展示了「ASP+SQL Server动态网站开发从基础到实践教程」中的 updateeng.asp 源码文件，采用 ASP 编程语言编写，共 82 行代码。您可以在线阅读完整代码内容，也可以返回资源详情页下载完整源码包进行本地学习和开发。

虫虫下载站收录了大量与Server相关的技术资源，包括源代码、技术文档、电路图等，是电子工程师和嵌入式开发者的专业学习平台。

⌨️ 快捷键说明

复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?