addsp.asp

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

<!--#include file="conn.asp"--><!--#include file="admin_is.ini"-->
<%
if trim(request("ccc22"))="add" then %>
<%
set rs=server.createobject("adodb.recordset")
				sql="SELECT * from sp "
	rs.open sql,conn,1,3 
	 rs.addnew

rs("sname")=request("sname")
rs("dian")=request("dian")
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("slei")=1


rs.update
rs.close
Response.Write "<script Language=Javascript>alert('发布完毕');location.href = 'addsp.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">
                                      * 点击： 
                                      <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="dian">
                                    </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">
                                      * </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">
                                      * 所属分类： 
                                      <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：</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">
                                      * </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="img2">
                                      * </td>
                                  </tr>
                                  <tr> 
                                    <td width="26%">简介：</td>
                                    <td width="74%"> 
                                      <textarea name="jianjie" cols="50"></textarea>
                                      * </td>
                                  </tr>
                                  <tr> 
                                    <td width="26%" height="16">详细：</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>