⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 sqstarmod.asp

📁 社区天地图文系统(核心:尘缘雅境图文系统) 版本: 1.0 本系统是ASP+ACCESS环境下开发成功
💻 ASP
字号:
<!--#include file=conn.asp -->

<%
dim id
id=trim(request("id"))
set rst=server.createobject("adodb.recordset")
sql="select * from sqstar where id="& id
rst.open sql,conn,1,1
%>
<html>

<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<meta name="GENERATOR" content="Microsoft FrontPage 6.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<title>修改社区之星信息</title>
<link rel="stylesheet" href="1.css">
</head>

<body>

<div align="center">
  <center>
<table border="0" width="500" cellspacing="0" cellpadding="0">
    <tr>
      <td width="100%">
        <form method="POST" action="sqstarmod1.ASP">
        <input type="hidden" value=<%=rst("id")%> name="id">
          <table border="1" width="100%" bordercolorlight="#000000" cellspacing="0" cellpadding="5" bordercolordark="#FFFFFF">
            <tr>
              <td width="100%" colspan="2">
                <p align="center">修改社区之星信息</td>
            </tr>
            <tr>
              <td width="17%" align="center">生日:</td>
              <td width="44%" align="left">
				<select size="1" name="birthyear">
        <option selected value="<%=rst("birthyear")%>"> <%=rst("birthyear")%> </option>
       
        <option>1980</option>
        <option>1981</option>
        <option>1982</option>
        <option>1983</option>
        <option>1984</option>
        <option>1985</option>
        <option>1986</option>
        <option>1987</option>
        <option>1988</option>
        <option>1989</option>
        <option>1990</option>
        <option>1991</option>
        <option>1992</option>
        <option>1993</option>
        <option>1994</option>
        <option>1995</option>
        <option>1996</option>
        <option>1997</option>
        <option>1998</option>
        <option>1999</option>
        <option>2000</option>
        <option>2001</option>
        <option>2002</option>
      </select><font size="2">年</font><select size="1" name="birthmonth">
        <option value="<%=rst("birthmonth")%>"> <%=rst("birthmonth")%> </option>
        <option>1</option>
        <option>2</option>
        <option>3</option>
        <option>4</option>
        <option>5</option>
        <option>6</option>
        <option>7</option>
        <option>8</option>
        <option>9</option>
        <option>10</option>
        <option>11</option>
        <option>12</option>
      </select><font size="2">月</font><select size="1" name="birthday">
        <option selected value="<%=rst("birthday")%>"> <%=rst("birthday")%> </option>
        <option>1</option>
        <option>2</option>
        <option>3</option>
        <option>4</option>
        <option>5</option>
        <option>6</option>
        <option>7</option>
        <option>8</option>
        <option>9</option>
        <option>10</option>
        <option>11</option>
        <option>12</option>
        <option>13</option>
        <option>14</option>
        <option>15</option>
        <option>16</option>
        <option>17</option>
        <option>18</option>
        <option>19</option>
        <option>20</option>
        <option>21</option>
        <option>22</option>
        <option>23</option>
        <option>24</option>
        <option>25</option>
        <option>26</option>
        <option>27</option>
        <option>28</option>
        <option>29</option>
        <option>30</option>
        <option>31</option>
      </select> 日</td>
            </tr>
			<tr>
              <td width="17%" align="center">姓名:</td>
              <td width="44%" align="left">
				<input type="text" name="fullname" size="20" value="<%=rst("fullname")%>"></td>
            </tr>
			<tr>
              <td width="17%" align="center">性别:</td>
              <td width="44%" align="left">
				<select name="sex" id="usersex" size="1">
        <option value="1">男</option>
        <option value="2">女</option>
        <option selected><%=rst("sex")%></option>
      </select></td>
            </tr>
			<tr>
              <td width="17%" align="center">所在楼:</td>
              <td width="44%" align="left">
				<select tabindex=8 size=1                           
        name=lou class="smallselsect">
                <option value="西9,10号楼">西9,10号楼</option>
                <option selected value="<%=rst("lou")%>"><%=rst("lou")%>
				</option>
                <option value="西11,12号楼">西11,12号楼</option>
                <option value="西14号楼">西14号楼</option>
                <option value="东2号楼">东2号楼</option>
                <option value="东3号楼">东3号楼</option>
                <option value="东4号楼">东4号楼</option>
                <option value="东5号楼">东5号楼</option>
                <option value="东8号楼">东8号楼</option>
                <option value="东9号楼">东9号楼</option>
                <option value="东10号楼">东10号楼</option>
                <option value="东11号楼">东11号楼</option>
                <option value="东12号楼">东12号楼</option>
                <option value="东15号楼">东15号楼</option>
                <option value="东16号楼">东16号楼</option>
                <option value="东18号楼">东18号楼</option>
                <option value="东19号楼">东19号楼</option>
                <option value="东20号楼">东20号楼</option>
              </select></td>
            </tr>
			<tr>
              <td width="17%" align="center">联系电话:</td>
              <td width="44%" align="left">
				<input type="text" name="tel" size="20" value="<%=rst("tel")%>"></td>
            </tr>
			<tr>
              <td width="17%" align="center">电子邮件:</td>
              <td width="44%" align="left">
				<input type="text" name="email" size="20" value="<%=rst("email")%>"></td>
            </tr>
			<tr>
    <td width="39%">
    <p align="center">个人照片:</td>
    <td width="60%"><iframe name="ad" frameborder=0 width=100% height=20 scrolling=no src=uploadface.asp></iframe>
	<input name="photo" type="text" size="30" class="smallInput" style="font-family: 宋体; font-size: 9pt" title="个人照片。您可以上传自己的照片,也可以直接填写您的网上照片的地址。" value="<%=rst("photo")%>">
</td>
  </tr>
			<tr>
              <td width="17%" align="right" valign="top">
				<p align="center">个人信言:</td>
              <td width="44%" align="left">
				<textarea rows="3" name="content" cols="30"><%=rst("content")%></textarea></td>
            </tr>
            <tr>
              <td width="100%" colspan="2">
                <p align="center"><input type="submit" value="提交" name="B1"><input type="reset" value="全部重写" name="B2"></td>
            </tr>
          </table>
        </form>
      </td>
    </tr>
  </table>
  </center>
</div>

</body>  <%		
rst.close
set rst=nothing

%>

</html>

⌨️ 快捷键说明

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