admin_config_register.asp

WAP网上购物系统源程序,,有兴趣的朋友,一起研究一下..交流经眼

<!--#include file=INC/skin.asp-->
<%
Dim const_txl_HomeUrl
const_txl_HomeUrl = ""
%>
<!--#include file=admin_login_check.asp-->
<%
Call opendatabase
txl_SiteHead const_txlname&"- 管理员"
if Request.Form("tj")="yes" then
	call saveregisterconfig
else
	call showregisterconfig
end if
Call CloseDatabase
web_end
Response.End()
sub showregisterconfig
opendatabase
dim rs
set rs=conn.execute ("select * from config where id=1")
dim question1,question2,answer1,answer2
if not rs.eof then
	question1=Trim(rs("question1"))
	question2=Trim(rs("question2"))
	answer1=Trim(rs("answer1"))
	answer2=Trim(rs("answer2"))
else
	question1=""
	question2=""
	answer1=""
	answer2=""
end if
rs.close
set rs=nothing
%>
<form name="form1" method="post" action="admin_config_register.asp">
  <table width="481" border="0" align="center" cellpadding="2" cellspacing="2">
    <tr> 
      <td colspan="5"> Wap影音注册需要设置两个问题以便系统能区分影音成员和影音好友：</td>
    </tr>
    <tr> 
      <td width="42">　</td>
      <td width="91">　</td>
      <td width="227">　</td>
      <td width="120">　</td>
      <td width="1">&nbsp;</td>
    </tr>
    <tr> 
      <td>　</td>
      <td valign="top">问题一：</td>
      <td><input name="question1" type="text"  size="40" maxlength="100" value=<%=question1%>></td>
      <td>　</td>
      <td>　</td>
    </tr>
    <tr> 
      <td>　</td>
      <td valign="top">答案：</td>
      <td><input name="answer1" type="text"  size="40" maxlength="100" value=<%=answer1%>></td>
      <td>　</td>
      <td>　</td>
    </tr>
    <tr> 
      <td>　</td>
      <td>　</td>
      <td>　</td>
      <td>　</td>
      <td>　</td>
    </tr>
    <tr> 
      <td>　</td>
      <td valign="top">问题二：</td>
      <td><input name="question2" type="text" size="40" maxlength="100" value=<%=question2%>></td>
      <td>　</td>
      <td>　</td>
    </tr>
    <tr> 
      <td>　</td>
      <td valign="top">答案：</td>
      <td><input name="answer2" type="text"  size="40" maxlength="100" value=<%=answer2%>></td>
      <td>　</td>
      <td>　</td>
    </tr>
    <tr> 
      <td>　</td>
      <td>　</td>
      <td>　</td>
      <td>　</td>
      <td>　</td>
    </tr>
    <tr> 
      <td>　</td>
      <td>　</td>
      <td><input name="tj" type="hidden" id="tj" value="yes">
        <input type="submit" name="Submit" value="提交"></td>
      <td>　</td>
      <td>　</td>
    </tr>
  </table>
</form>
<%
end sub
function saveregisterconfig
	opendatabase
	Dim rs,question1,answer1,question2,answer2
	question1=Trim(Request.form("question1"))
	question2=Trim(Request.form("question2"))
	answer1=Trim(Request.form("answer1"))
	answer2=Trim(Request.form("answer2"))
	if question1="" or question2="" or answer1="" or answer2="" then
		Response.Write "<ul><li><font color=red>请将信息填写完整!</font></li></ul>"
		Response.write "<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<input type=button value='返回修改' onclick='javascript:window.history.back();'>"
		Exit function
	end if
	set rs=server.CreateObject("Adodb.Recordset")
	rs.open "select * from config where id=1",conn,1,3
	if rs.eof then	'没有设置提示问题和答案
		rs.addnew()
	end if
	rs("id")=1
	rs("question1")=question1
	rs("answer1")=answer1
	rs("question2")=question2
	rs("answer2")=answer2
	rs.update()
	rs.close
	set rs=nothing
	Response.Write("<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<font color=red><ul><li>恭喜您,对该功能的设置已经成功！</font><br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<li>页面将在5秒之后返回!</ul>")
	Response.Write"<meta http-equiv='refresh' content='5;URL=admin_config_register.asp'>"
end function
%>