editquan.asp
Upload User: pengwei803
Upload Date: 2021-02-10
Package Size: 3311k
Code Size: 4k
Development Platform:

HTML/CSS

  1. <%
  2. qid=request.querystring("qid")
  3. set rsmm=server.CreateObject("adodb.recordset")
  4. sqlmm="select  * from  Quan where id="&qid&""
  5. rsmm.open sqlmm,conn,1,1
  6. if rsmm.eof then
  7. response.Write("<script>alert(""此圈不存在!!"");location.href=""Quan.asp"";</script>")
  8. end if
  9. %>
  10. <div align="center">
  11. <table border="0" width="733" height="335" bgcolor="#EFEFEF" cellpadding="0" cellspacing="1">
  12. <tr>
  13. <td height="38" width="733" bgcolor="#FFFFFF" colspan="2">
  14. <p align="center"><b>管 理 圈 子</b></td>
  15. </tr>
  16. <form method="POST" action="deal_user.asp?Action=equan&qid=<%=qid%> " name="thisform">
  17. <tr>
  18. <td height="40" width="185" bgcolor="#FFFFFF" align="right">圈子名称:</td>
  19. <td height="40" width="545" bgcolor="#FFFFFF">&nbsp;<input type="text" name="qname" size="42" value="<%=rsmm("name")%>"> 
  20. *</td>
  21. </tr>
  22. <tr>
  23. <td height="40" width="185" bgcolor="#FFFFFF" align="right">圈子类别:</td>
  24. <td height="40" width="545" bgcolor="#FFFFFF">&nbsp;<select name="leibie">
  25. <option value="<%=rsmm("lb")%>"><%=rsmm("lb")%></option>
  26.   <% set crs=server.createobject("adodb.recordset")
  27.   csql="select * from Quan_type where name<>'"&rsmm("lb")&"' order by id"
  28.   crs.open csql,conn,1,1
  29.   do while not crs.eof
  30.   %>
  31.       <option value="<%=crs("name")%>"><%=crs("name")%></option>
  32.   <% crs.movenext
  33.      loop
  34.  crs.close
  35.  set crs=nothing
  36.   %>
  37.       </select> (必选)</td>
  38. </tr>
  39. <tr>
  40. <td bgcolor="#FFFFFF" width="185" align="right" height="30">所属地区:</td>
  41. <td bgcolor="#FFFFFF" width="513">&nbsp;<%
  42. set rsclass=server.createobject("adodb.recordset")
  43. sqlclass = "select * from Gu_qu"
  44. rsclass.open sqlclass,conn,1,1
  45. %><SCRIPT language = "JavaScript">
  46. var onecount;
  47. onecount=0;
  48. subcat = new Array();
  49.         <%
  50.         count = 0
  51.         do while not rsclass.eof 
  52.         %>
  53. subcat[<%=count%>] = new Array("<%= trim(rsclass("class2"))%>","<%= trim(rsclass("class1"))%>","<%= trim(rsclass("id"))%>");
  54.         <%
  55.         count = count + 1
  56.         rsclass.movenext
  57.         loop
  58.         rsclass.close
  59.         %>
  60. onecount=<%=count%>;
  61. function changelocation(locationid)
  62.     {
  63.     document.thisform.class2.length = 0; 
  64.     var locationid=locationid;
  65.     var i;
  66.     for (i=0;i < onecount; i++)
  67.         {
  68.             if (subcat[i][1] == locationid)
  69.             { 
  70.                 document.thisform.class2.options[document.thisform.class2.length] = new Option(subcat[i][0], subcat[i][2]);
  71.             }        
  72.         }
  73.         
  74.     }    
  75. </SCRIPT><%
  76. sqlclass = "select * from Gu_shi"
  77. rsclass.open sqlclass,conn,1,1
  78. if rsclass.eof and rsclass.bof then
  79. response.write "请先添加分类。"
  80. response.end
  81. else
  82. %><SELECT name="class1" onChange="changelocation(document.thisform.class1.options[document.thisform.class1.selectedIndex].value)" size="1">
  83.  <OPTION selected value="">地级市</OPTION>
  84. <%do while not rsclass.eof
  85. %><OPTION value="<%=trim(rsclass("id"))%>"><%=trim(left(rsclass("class1"),5))%></OPTION>
  86. <%
  87. rsclass.movenext
  88. loop
  89. end if
  90. rsclass.close
  91. %></SELECT>
  92. <SELECT name="class2">
  93. <OPTION selected value="">区县</OPTION>
  94. </SELECT> 
  95.   <font color="red">*</font>
  96. </td>
  97. </tr>
  98. <tr>
  99. <td height="142" width="185" bgcolor="#FFFFFF" align="right">圈子简介:</td>
  100. <td height="142" width="545" bgcolor="#FFFFFF">&nbsp;<textarea rows="10" name="beizhu" cols="55"><%=rsmm("beizhu")%></textarea> 
  101. *</td>
  102. </tr>
  103. <tr>
  104. <td height="37" width="185" bgcolor="#FFFFFF" align="right">圈子创建人:</td>
  105. <td height="37" width="545" bgcolor="#FFFFFF">&nbsp;<input type="text" name="username" size="14" value="<%=username%>" readonly> 
  106. (不可修改)</td>
  107. </tr>
  108. <tr>
  109. <td height="37" width="185" bgcolor="#FFFFFF" align="right">圈子LOGO:</td>
  110. <td height="37" width="545" bgcolor="#FFFFFF">&nbsp;<input type="text" name="pic" size="45" readonly value="<%=rsmm("logo")%>"> 
  111. (图片要求:JPG/GIF &lt;500K)</td>
  112. </tr>
  113. <tr>
  114. <td height="35" width="185" bgcolor="#FFFFFF" align="right">上传:</td>
  115. <td height="35" width="545" bgcolor="#FFFFFF">&nbsp;<%if rshy("uservip")=1 then%><iframe frameborder=0 width=290 height=25 scrolling=no src="Upload.asp?action=AD_Pic"></iframe><%else%><br>&nbsp;<font color="#FF0000">非本站VIP会员不能上传图片</font><%end if%></td>
  116. </tr>
  117. <tr>
  118. <td height="40" width="730" bgcolor="#FFFFFF" align="right" colspan="2">
  119. <p align="center"><input type="submit" value="修改圈子" name="B1"></td>
  120. </tr></form>
  121. </table>
  122. </div>