• How to determine which checkboxes are checked in postback (sqlstr="delete spprod where id in ("&request("sid")&")")


    http://www.5d.cn/bbs/archivecontent.asp?id=864666
    <!--#include file="../Admin/conn_sql/conn_sql.asp"-->
    <%if request("del2")="删除" and request("sid")<>"" then
    sqlstr="delete  spprod where id in ("&request("sid")&")"
    conn.execute sqlstr
    Response.Redirect Request.ServerVariables("HTTP_REFERER")
    %>
    <%else%>
    <%
    dim curpage
    if request.querystring("curpage")="" or request.querystring("curpage")=0 then
    curpage=1
    else
    curpage=cint(request.querystring("curpage"))
    end if
    str="select * from spprod where spid='"&request("id")&"' order by id desc"
    set rs0=server.createobject("adodb.recordset")
    rs0.open str,conn,1,2
    %>
    <html>
    <head>
    <meta http-equiv="Content-Type" content="text/html; charset=gb2312">
    <meta name="GENERATOR" content="Microsoft FrontPage 4.0">
    <meta name="ProgId" content="FrontPage.Editor.Document">
    <title>商铺展示</title>
    <Link rel='stylesheet' href="../Main.Css">
    <script language="javascript">
    <!--
    function CheckAll(form)
      {
      for (var i=0;i<form.elements.length;i++)
        {
        var e = form.elements[i];
        if (e.name != 'chkall')
           e.checked = form.chkall.checked;
        }
      }
    //-->
    </script>
    </head>
    <script ID="clientEventHandlersJS" LANGUAGE="javascript">
    <!--
    function btnAdd_&#111nclick(){
    window.navigate("addprod.asp?id=<%=request("id")%>");
    }


    //-->
    </script>
    <body topmargin="0" leftmargin="0">
    <table width="98%" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#009900">
      <tr>
        <td colspan="2" bgcolor="#FFFFFF"><div align="center">商铺管理</div></td>
      </tr>
      <tr bgcolor="#FFFFFF">
        <td width="30%" height="18"><div align="center"><a href="show6.asp?id=<%=request("id")%>">商铺各项基本资料管理</a></div></td>
        <td width="70%" rowspan="3"><%if rs0.eof then%> <div align="center">暂无产品 -><a href="addprod.asp?id=<%=request("id")%>">马上发布</a><-</div>
          <%else
    rs0.pagesize=15
    dim totalpage
    totalpage=rs0.pagecount
    rs0.absolutepage=curpage
    rs0.cachesize=rs0.pagesize%> <form name="form1" method="post" action="show6-1.asp?id=<%=request("id")%>">
            <table width="98%" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#009900">
              <% do while not rs0.eof %>
              <tr>
                <td width="22%" height="22" bgcolor="#FFFFFF"><div align="center">
                    <input type="checkbox" name="sid" value="<%=rs0("id")%>">
                  </div></td>
                <td width="78%" bgcolor="#FFFFFF"><div align="center"><%=rs0("sp_prod")%></div></td>
              </tr>
              <% rs0.movenext
    loop
    %>
              <tr bgcolor="#FFFFFF">
                <td height="29" colspan="2"><div align="center"></div>
                  <div align="center">
                    <input name="del2" type="submit" id="del2" value="删除">
                     
                    <input type="button" name="add" value="增加" class="whois_box" " language=javascript onClick="return btnAdd_onclick()">
                  </div></td>
              </tr>
              <tr bgcolor="#FFFFFF">
                <td height="4" colspan="2"><div align="center">
                    <table width="98%" border="0">
                      <tr>
                        <td width="29%"><div align="center">
                            <input type="checkbox" name="chkall" value="on" onclick="CheckAll(this.form)" >
                            选中所有产品</div></td>
                        <td width="71%"> </td>
                      </tr>
                    </table>
                  </div></td>
              </tr>
              <tr bgcolor="#FFFFFF">
                <td height="5" colspan="2"><div align="right"><a href=show6-1.asp?curpage=<%=curpage-1%>&id=<%=request("id")%>>上一页</a> <a href=show6-1.asp?curpage=<%=curpage+1%>&id=<%=request("id")%>>下一页</a> </div></td>
              </tr>
            </table>
          </form>
          <%end if%></td>
      </tr>
      <tr bgcolor="#FFFFFF">
        <td height="332"><div align="center">-><a href="show6-1.asp?id=<%=request("id")%>">商铺商品管理</a></div></td>
      </tr>
      <tr bgcolor="#FFFFFF">
        <td height="18"><div align="center"><a href="all_shop2.asp">返回商铺首页</a></div></td>
      </tr>
    </table>
    </body>
    </html>
    <%set rs0=nothing
    conn.close
    %>
    <%end if%>
  • 相关阅读:
    ivew-admin 导入excel
    ivew Upload 上传时附带的额外参数
    工厂方法模式
    简单工厂模式
    webpack (1)
    商品格子
    合同签名
    展示图片数组
    使用egg.js和egg-sequelize连接mysql
    egg 连接mysql 在mysql 插入数据
  • 原文地址:https://www.cnblogs.com/cy163/p/244682.html
Copyright © 2020-2023  润新知