/db/admin/product_add.asp

https://github.com/semious/dynacomcorp · ASP · 205 lines · 201 code · 4 blank · 0 comment · 8 complexity · 683a1d01251fbb7328c43299d5d61d1e MD5 · raw file

  1. <!--#include file="IsAdmin.asp" -->
  2. <!--#include file="conn.asp" -->
  3. <html>
  4. <head>
  5. <title>Add New Product</title>
  6. <link rel="stylesheet" href="css/style.css">
  7. <meta http-equiv="Content-Type" content="text/html;charset=gb2312">
  8. <script type="text/javascript" language="javascript">
  9. function selPic(_obj){
  10. document.getElementById("pic_a").href=_obj.src;
  11. document.getElementById("pic_src").src=_obj.src;
  12. document.getElementById("pic_src").alt=_obj.alt;
  13. }
  14. function validate(){
  15. alert();
  16. return false;
  17. }
  18. </script>
  19. </head>
  20. <body>
  21. <form method="post" action="product_add2.asp" >
  22. <table cellspacing="0" bordercolor="#000000" cellpadding="2" style="margin:30px 0 0 0;" border="1" align="center" width="90%">
  23. <thead>
  24. <th colspan="4" bgcolor="#FFFFCC" style="border:1px #000000 solid">
  25. Add New Product
  26. </th>
  27. </thead>
  28. <tbody>
  29. <tr>
  30. <td width="20%"></td>
  31. <td width="30%"></td>
  32. <td width="30%"></td>
  33. <td width="20%"></td>
  34. </tr>
  35. <tr height="60">
  36. <td style="border:1px #000000 solid;">part_num:<br/>
  37. <input type="text" name="name" id="name" size="15">
  38. </td>
  39. <td colspan="3" style="border:1px #000000 solid;">
  40. description:<br/>
  41. <input type="text" name="des" id="des" size="60"><br />
  42. short description:<br/>
  43. <input type="text" name="s_des" id="s_des" size="60">
  44. </td>
  45. </tr>
  46. <tr>
  47. <td style="border:1px #000000 solid;">
  48. <p>
  49. picture1<br />
  50. <input type="text" name="pic1" id="pic1" size="15">
  51. </p>
  52. <p>
  53. picture2(opt.)<br />
  54. <input type="text" name="pic2" id="pic2" size="15">
  55. </p>
  56. <p>
  57. picture3(opt.)<br />
  58. <input type="text" name="pic3" id="pic3" size="15">
  59. </p>
  60. </td>
  61. <td colspan="2" style="border:1px #000000 solid;">
  62. picture
  63. </td>
  64. <td style="border:1px #000000 solid;">
  65. <p>
  66. picture4(opt.)<br />
  67. <input type="text" name="pic4" id="pic4" size="15">
  68. </p>
  69. <p>
  70. picture5(opt.)<br />
  71. <input type="text" name="pic5" id="pic5" size="15">
  72. </p>
  73. <p>
  74. picture6(opt.)<br />
  75. <input type="text" name="pic6" id="pic6" size="15">
  76. </p>
  77. </td>
  78. </tr>
  79. <tr>
  80. <td colspan="4" style="border:1px #000000 solid;">
  81. Introduce:<br />
  82. <textarea rows="10" id="intro" cols="60" name="intro"></textarea>
  83. </td>
  84. </tr>
  85. <tr>
  86. <td style="border:1px #000000 solid;">
  87. Pkg. Qty:
  88. <input type="text" name="pq" id="pq" size="5">
  89. </td>
  90. <td style="border:1px #000000 solid;">
  91. Video:<input type="text" name="video" id="video" size="15">
  92. </td>
  93. <td style="border:1px #000000 solid;" colspan="2">
  94. Specification:
  95. <input type="text" name="pdf" id="pdf" size="15" />
  96. </td>
  97. </tr>
  98. <tr>
  99. <td style="border:1px #000000 solid;">Avaiable Color:</td>
  100. <td colspan="3" style="border:1px #000000 solid;">
  101. <input type="checkbox" name="bk" id="bk" value="BK">BK|
  102. <input type="checkbox" name="wh" id="wh" value="WH">WH|
  103. <input type="checkbox" name="pr" id="pr" value="PR">PR|
  104. <input type="checkbox" name="bl" id="bl" value="BL">BL|
  105. <input type="checkbox" name="al" id="al" value="AL">AL|
  106. <input type="checkbox" name="gn" id="gn" value="GN">GN|
  107. <input type="checkbox" name="gy" id="gy" value="GY">GY|
  108. <input type="checkbox" name="iv" id="iv" value="IV">IV|
  109. <input type="checkbox" name="orange" id="or" value="OR">OR|
  110. <input type="checkbox" name="rd" id="rd" value="RD">RD|
  111. <input type="checkbox" name="yl" id="yl" value="YL">YL
  112. </td>
  113. </tr>
  114. <tr>
  115. <td colspan="2" style="border:1px #000000 solid;">
  116. related menu1(opt.):
  117. <%
  118. dim rs
  119. dim ary
  120. dim ary1
  121. dim i
  122. dim j
  123. set rs=server.createobject("adodb.recordset")
  124. rs.open "select * from cat where rank = '2'",conn
  125. if not rs.eof then
  126. %>
  127. <select disabled="disabled" name="menu1" style="width:150px;"><%
  128. while not rs.eof
  129. %><option value="<%=trim(cstr(rs("id")))%>"><%=rs("name")%></option><%
  130. rs.movenext
  131. wend
  132. %><option value=" " selected="selected"> </option></select><%
  133. end if
  134. rs.close
  135. %>
  136. <br />
  137. related menu2(opt.):
  138. <%
  139. rs.open "select * from cat where rank = '2'",conn
  140. if not rs.eof then
  141. %>
  142. <select disabled="disabled" name="menu2" style="width:150px;"><%
  143. while not rs.eof
  144. %><option value="<%=trim(cstr(rs("id")))%>"><%=rs("name")%></option><%
  145. rs.movenext
  146. wend
  147. %><option value=" " selected="selected"> </option></select>
  148. <%
  149. end if
  150. rs.close
  151. %>
  152. </td>
  153. <td colspan="2" style="border:1px #000 solid;">
  154. related product1(opt.):
  155. <%
  156. rs.open "select * from product order by name",conn
  157. if not rs.eof then
  158. %>
  159. <select name="menu3" style="width:150px;"><%
  160. while not rs.eof
  161. %><option value="<%=trim(cstr(rs("id")))%>"><%=rs("name")%></option><%
  162. rs.movenext
  163. wend
  164. %><option value=" " selected="selected"> </option></select>
  165. <%
  166. end if
  167. rs.close
  168. %>
  169. <br />
  170. related product2(opt.):
  171. <%
  172. rs.open "select * from product order by name",conn
  173. if not rs.eof then
  174. %>
  175. <select name="menu4" style="width:150px;">
  176. <%
  177. while not rs.eof
  178. %>
  179. <option value="<%=trim(cstr(rs("id")))%>"><%=rs("name")%></option>
  180. <%
  181. rs.movenext
  182. wend
  183. %>
  184. <option value=" " selected="selected"> </option>
  185. </select>
  186. <%
  187. end if
  188. rs.close
  189. %>
  190. </td>
  191. </tr>
  192. <tr height="60">
  193. <td colspan="4" style="border:1px #000000 solid;">
  194. <input type="submit" value="submit" />
  195. </td>
  196. </tr>
  197. </tbody>
  198. </table>
  199. </form>
  200. </body>
  201. </html>