addsp.asp

NT80购物系统1.0 系统说明： 1 界面美观大方

<!--#include file="conn.asp"-->
<%
if session("use")="" then

Response.Write "<script Language=Javascript>alert('请您先登陆');location.href = 'javascript:history.back()';</script>"

 
end if
%>

 <%
if trim(request("ccc22"))="add" then 
if request("scun1")="" or request("scun2")="" or request("jianjie")="" or request("jianjie2")=""then
Response.Write "<script Language=Javascript>alert('请您把必填内容填写完整');location.href = 'javascript:history.back()';</script>"
end if

set rs=server.createobject("adodb.recordset")
				sql="SELECT * from sp "
	rs.open sql,conn,1,3 
	 rs.addnew

rs("sname")=request("sname")

rs("ssid")=request("ssid")
rs("scun1")=request("scun1")
rs("scun2")=request("scun2")
rs("jianjie")=request("jianjie")
rs("jianjie2")=request("jianjie2")
rs("img")=request("img")
rs("img2")=request("img2")
rs("fabu")=request("fabu")



rs.update
rs.close
Response.Write "<script Language=Javascript>alert('发布完毕1等待审核');location.href = 'index.asp';</script>"
response.end
 end if
%>





<title></title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="style.css" rel="stylesheet" type="text/css">

<table width="80%" border="1" cellspacing="0" cellpadding="1" bordercolor="#336699" align="center">
  <tr> 
    <td> 
      <table width="100%" border="0" cellspacing="0" cellpadding="0">
        <tr> 
          <td background="../images/back_3.gif" rowspan="2"> 
            <table width="100%" border="0" cellspacing="0" cellpadding="0" class="12v">
              <tr> 
                <td class="12v" > 
                  <table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" id="AutoNumber3" height="96" width="100%">
                    <tr> 
                      <td> 
                        <table width="100%" border="0" align="center" cellpadding="1" cellspacing="1" bgcolor="#FFFFFF" height="128">
                          <tr> 
                            <td height="20" bgcolor="#FFFFFF"> 
                              <div align="center">添加商品</div>
                            </td>
                          </tr>
                          <tr> 
                            <td height="177" valign="top" bgcolor="#E8F1FF"> <br>
                              <form name="form1" method="post" action="addsp.asp?ccc22=add">
                                <table width="100%" border="0" cellspacing="0" cellpadding="0" height="175">
                                  <tr> 
                                    <td width="26%">商品：</td>
                                    <td width="74%"> 
                                      <input style="BACKGROUND-COLOR: #ffffff; BORDER-BOTTOM: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; FONT-SIZE: 9pt; HEIGHT: 19px;"type="text" name="sname">
                                      * <font color="#FF0000">(必填）</font></td>
                                  </tr>
                                  <tr> 
                                    <td width="26%">价格1：</td>
                                    <td width="74%"> 
                                      <input style="BACKGROUND-COLOR: #ffffff; BORDER-BOTTOM: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; FONT-SIZE: 9pt; HEIGHT: 19px;"type="text" name="scun1">
                                      *<font color="#FF0000">(必填）</font> 发布人： 
                                      <input style="BACKGROUND-COLOR: #ffffff; BORDER-BOTTOM: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; FONT-SIZE: 9pt; HEIGHT: 19px;"type="text" name="fabu" value="<%=request("name")%>">
                                    </td>
                                  </tr>
                                  <tr> 
                                    <td width="26%">价格2：</td>
                                    <td width="74%"> 
                                      <input style="BACKGROUND-COLOR: #ffffff; BORDER-BOTTOM: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; FONT-SIZE: 9pt; HEIGHT: 19px;"type="text" name="scun2">
                                      * <font color="#FF0000">(必填）</font>所属分类： 
                                      <select name="ssid">
                                        <%

	  set rs=server.createobject("adodb.recordset")
	  sql="SELECT * from href where lei=0 order by time desc"
	  
      rs.open sql,conn,1,3
	for x=1 to int(rs.recordcount)
%>
                                        <option value="<%=rs("lname")%>"><%=rs("lname")%></option>
                                        <% rs.movenext
  next %>
                                      </select>
                                    </td>
                                  </tr>
                                  <tr> 
                                    <td width="26%">图片1：<font color="#990000">没有可为空</font></td>
                                    <td width="74%"> 
                                      <input style="BACKGROUND-COLOR: #ffffff; BORDER-BOTTOM: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; FONT-SIZE: 9pt; HEIGHT: 19px;"type="text" name="img">
                                      图片1长比宽多，不能竖长形，否则显示不美观</td>
                                  </tr>
                                  <tr> 
                                    <td width="26%">图片2：<font color="#990000">没有可为空</font></td>
                                    <td width="74%"> 
                                      <input style="BACKGROUND-COLOR: #ffffff; BORDER-BOTTOM: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; FONT-SIZE: 9pt; HEIGHT: 19px;"type="text" name="img2">
                                      图片2无限制</td>
                                  </tr>
                                  <tr> 
                                    <td width="26%">简介：<font color="#FF0000">(必填）</font></td>
                                    <td width="74%"> 
                                      <textarea name="jianjie" cols="50">255字内</textarea>
                                      * </td>
                                  </tr>
                                  <tr> 
                                    <td width="26%" height="16">详细：<font color="#990000">(发布后请到管理中心）</font><font color="#FF0000">(必填）</font></td>
                                    <td width="74%" height="16"> 
                                      <textarea name="jianjie2" cols="50" rows="10"></textarea>
                                      * </td>
                                  </tr>
                                  <tr> 
                                    <td width="26%" height="16">&nbsp;</td>
                                    <td width="74%" height="16"> 
                                      <input type="submit" name="Submit" value="确定">
                                    </td>
                                  </tr>
                                </table>
                        </form>
                            </td>
                          </tr>
                          <tr>
                            <td height="106" valign="top" bgcolor="#E8F1FF">
                              <div align="right"> </div>
                            </td>
                          </tr>
                        </table>
                      </td>
                    </tr>
                  </table>
                </td>
              </tr>
            </table>
          </td>
        </tr>
      </table>
    </td>
  </tr>
</table>
<br>
</body>
</html>