editxinxi.asp

二手程序,可是实现会员的等级功能管理,会员可以有上船图片,给信息标题加颜色功能!

<!--#include file=conn.asp-->
<!--#include file=cookies.asp-->
<%
	dim sql
	dim rs
	dim id,ok,biaoti,leixing,jiage,diqu,memo,name,email,dianhua
    id=request("id")
function HTMLEncode(fString)
if not isnull(fString) then
    fString = replace(fString, ">", "&gt;")
    fString = replace(fString, "<", "&lt;")
    fString = Replace(fString, CHR(32), "&nbsp;")
    fString = Replace(fString, CHR(9), "&nbsp;")
    fString = Replace(fString, CHR(34), "&quot;")
    fString = Replace(fString, CHR(39), "&#39;")
    fString = Replace(fString, CHR(13), "")
    fString = Replace(fString, CHR(10) & CHR(10), "</P><P> ")
    fString = Replace(fString, CHR(10), "<BR> ")
    'fString=ChkBadWords(fString)
    HTMLEncode = fString
end if
end function
	set rs=server.createobject("adodb.recordset")
	sql="select * from [xinxi] where id="&cstr(id)
	rs.open sql,conn,1,3
    if request("ok")=1 then
    rs("biaoti")=request("biaoti")
    rs("leixing")=request("leixing")
    rs("jiage")=request("jiage")
    rs("diqu")=request("diqu")
    rs("memo")=request("memo")
    rs("name")=request("name")
    rs("email")=request("email")
    rs("dianhua")=request("dianhua")
    rs.update
    response.write "<font size=2>修改成功!</font><br>"
    response.end
    else
%>
<title>西安二手后台管理---信息修改</title>
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%">
  <tr>
    <td width="1%" valign="top"></td>
    <td width="99%">
  <table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111">
 <FORM name=theForm method=POST action=editxinxi.asp?ok=1&id=<%=request("id")%>>
    <tr>
                      <td bgColor="#008000" height="20" vAlign="bottom" style="border-style: solid; border-width: 1" width="517" colspan="2">
                      <p style="MARGIN-LEFT: 6px" align="center">
                  <font color="#FFFFFF"><span style="font-size: 9pt"><b>信息修改</b></span></font></td>
                    </tr>
    <tr>
                      <td bgColor="#f7f7f7" height="43" width="90" style="border-left-style: solid; border-left-width: 1; border-right-style: none; border-right-width: medium; border-top-style: solid; border-top-width: 1" align="center">
                      　</td>
                      <td bgColor="#f7f7f7" height="43" width="492" style="border-left-style: none; border-left-width: medium; border-right-style: solid; border-right-width: 1; border-top-style: solid; border-top-width: 1">
                      <p align="left">
                      &nbsp; </td>
                    </tr>
    <tr>
                      <td bgColor="#f7f7f7" height="25" width="90" style="border-left-style: solid; border-left-width: 1; border-right-style: none; border-right-width: medium" align="center">
                      <span style="FONT-SIZE: 12px">
                      标&nbsp;&nbsp;&nbsp; 题：</span></td>
                      <td bgColor="#f7f7f7" height="12" style="border-left-style: none; border-left-width: medium; border-right-style: solid; border-right-width: 1">
                      <span style="FONT-SIZE: 12px">
                      &nbsp;
                      <input name="biaoti" size="75" style="BACKGROUND-COLOR: #f9f9f9; COLOR: #384249; FONT-FAMILY: Verdana; FONT-SIZE: 11px; FONT-WEIGHT: bold" tabIndex="1" maxlength="50" value="<%=HTMLEncode(rs("biaoti"))%>"></span></td>
                    </tr>
    <tr>
                      <td bgColor="#f7f7f7" height="25" width="90" style="border-left-style: solid; border-left-width: 1; border-right-style: none; border-right-width: medium" align="center">
                      <span style="font-size: 12px">交易类型</span>:</td>
                      <td bgColor="#f7f7f7" height="12" style="border-left-style: none; border-left-width: medium; border-right-style: solid; border-right-width: 1">
                      &nbsp;<select name="leixing">
                      <option <%if leixing="1" then%>selected<%end if%> value="1">出售</option>
                      <option <%if leixing="2" then%>selected<%end if%> value="2">求购</option>
                      <option <%if leixing="3" then%>selected<%end if%> value="3">出租</option>
                      <option <%if leixing="4" then%>selected<%end if%> value="4">求租</option>
                      <option <%if leixing="5" then%>selected<%end if%> value="5">求职</option>
                      </select>&nbsp; </td>
                    </tr>
    <tr>
                      <td bgColor="#f7f7f7" height="12" width="90" style="border-left-style: solid; border-left-width: 1; border-right-style: none; border-right-width: medium" align="center">
                      <span style="font-size: 12px">价&nbsp;&nbsp;&nbsp; 格</span>:</td>
                      <td bgColor="#f7f7f7" height="25" style="border-left-style: none; border-left-width: medium; border-right-style: solid; border-right-width: 1">
                      &nbsp;<input type="text" name="jiage" size="12" maxlength="6" value="<%=rs("jiage")%>"><font color="#FF0000"><span style="font-size: 12px"> 
                      元（0表示面仪）</span></font></td>
                    </tr>
    <tr>
                      <td bgColor="#f7f7f7" height="25" width="90" style="border-left-style: solid; border-left-width: 1; border-right-style: none; border-right-width: medium" align="center">
                      <span style="font-size: 12px">交易地区</span>:</td>
                      <td bgColor="#f7f7f7" height="12" style="border-left-style: none; border-left-width: medium; border-right-style: solid; border-right-width: 1">
                      <p align="left">
                      &nbsp;<input type="text" name="diqu" size="21" maxlength="10" value="<%=rs("diqu")%>"></td>
                    </tr>
    <tr>
                      <td bgColor="#f7f7f7" height="239" width="90" style="border-left-style: solid; border-left-width: 1; border-right-style: none; border-right-width: medium" align="center">
                      <span style="FONT-SIZE: 12px">
                      内容：</span></td>
                      <td bgColor="#f7f7f7" height="239" style="border-left-style: none; border-left-width: medium; border-right-style: solid; border-right-width: 1">
                      <span style="FONT-SIZE: 12px">
                      &nbsp;
                      <textarea rows="18" name="memo" cols="64"><%=rs("memo")%></textarea></span></td>
                    </tr>
    <tr>
                      <td bgColor="#f7f7f7" height="40" width="90" style="border-left-style: solid; border-left-width: 1; border-right-style: none; border-right-width: medium" align="center">
                      <span style="font-size: 12px">联系人</span>：</td>
                      <td bgColor="#f7f7f7" height="40" style="border-left-style: none; border-left-width: medium; border-right-style: solid; border-right-width: 1">
                      <span style="font-size: 12px">&nbsp; </span>
                      <input type="text" name="name" size="23" maxlength="15" value="<%=rs("name")%>"></td>
                    </tr>
    <tr>
                      <td bgColor="#f7f7f7" height="20" width="90" style="border-left-style: solid; border-left-width: 1; border-right-style: none; border-right-width: medium" align="center">
                      <span style="font-size: 12px">email</span>：</td>
                      <td bgColor="#f7f7f7" height="25" style="border-left-style: none; border-left-width: medium; border-right-style: solid; border-right-width: 1">
                      <span style="font-size: 12px">&nbsp; </span>
                      <input type="text" name="email" size="23" maxlength="40" value="<%=rs("email")%>"></td>
                    </tr>
    <tr>
                      <td bgColor="#f7f7f7" height="25" width="90" style="border-left-style: solid; border-left-width: 1; border-right-style: none; border-right-width: medium" align="center">
                      <span style="font-size: 12px">联系电话</span>：</td>
                      <td bgColor="#f7f7f7" height="17" style="border-left-style: none; border-left-width: medium; border-right-style: solid; border-right-width: 1">
                      <span style="font-size: 12px">&nbsp; </span>
                      <input type="text" name="dianhua" size="23" maxlength="40" value="<%=rs("dianhua")%>"></td>
                    </tr>
    <tr>
                      <td bgColor="#f7f7f7" height="35" style="border-left-style: solid; border-left-width: 1; border-right-style: solid; border-right-width: 1; border-bottom-style: solid; border-bottom-width: 1" colspan="2">
                      <p align="center">
<button name="B1" type="submit">
                  <font color="#384249"><span style="font-size: 9pt"><b>信息修改</b></span></font></button></td>
                      </tr>
  </form>
  </table>
    </td>
  </tr>
</table>
<%
    end if
	rs.close
	conn.close
	set rs=nothing
	set conn=nothing
%>