循环问题

楼上的高手再看看，就是默认的是两组数据，点“+”可能增加若干组，然后那段php代码可能要用循环。 <html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" /><title>database</title><style>a{TEXT-DECORATION:none}</style>
<style type="text/css">

</style>
</head>
<SCRIPT>
var sm = 2;
function   addRow(){
  var   row   =   document.getElementById("ModelRow");
  var   ib    =   document.getElementById("insertBefore");
  sm++;
  var   tr    =   document.createElement("tr");
  var   td    =   document.createElement("td");
  td.align="center"
  td.width="25%"
  var   sel   =   document.createElement("<select name='a" + sm+ "' style='width: 100%'>");
  sel.options.add(new Option("All","all"));
  sel.options.add(new Option("ID","id"));
  sel.options.add(new Option("name","name"));
  sel.options.add(new Option("address","address"));
  td.appendChild(sel);
  tr.appendChild(td);
  td    =   document.createElement("td");
  td.align = "center"
  td.width = "55%"
  var input1 = document.createElement("<input type='text' size='70%' name='b" + sm + "' />");
  td.appendChild(input1);
  tr.appendChild(td);
  td    =   document.createElement("td");
  td.align = "center"
  td.width = "20%"
  var input2 = document.createElement("<input type='radio' value='and' checked name='c" + sm + "' />");
  td.appendChild(input2);
  var t1 = document.createTextNode("and   ");
  td.appendChild(t1);
  var input3 = document.createElement("<input type='radio' value='or' name='c" + sm + "' />");
  td.appendChild(input3);
  var t2 = document.createTextNode("or");
  td.appendChild(t2);
  var br1 = document.createElement("br");
  td.appendChild(br1);
  var br2 = document.createElement("br");
  td.appendChild(br2);
  var br3 = document.createElement("br");
  td.appendChild(br3);
  var br4 = document.createElement("br");
  td.appendChild(br4);
  tr.appendChild(td);
  row.parentNode.insertBefore(tr,ib);
  var tbl = document.getElementById("tb");
  if(document.all) tbl.outerHTML = tbl.outerHTML;
}
function   deleteRow(){
  var   ib     =   document.getElementById("InsertBefore");
  var   row    =   ib.previousSibling;
  if(   row.id   ==   "ModelRow"   )
  {
  alert('can not do');
  return;
  }
  ib.parentNode.removeChild(row);
}
</SCRIPT> <body text="#000000" link="#0000ff" vlink="#000080" alink="#FF0000">
<table width="1008" border="0" align="center" cellspacing="0" bgcolor="#99FF00">
  <tr><td>
<table width="1000" height="600" border="0" align="center" cellspacing="0" bgcolor="#ffffff" id="3">
  <tr>
    <td>

      <?php
          $idsearch = @$_GET['a1']; $idstring = trim(@$_GET['a2']);
          $seqsearch = @$_GET['b1']; $seqstring = trim(@$_GET['b2']);$seqao = @$_GET['b3'];

          if ( $idstring != "" or $seqstring !="")
          {
               $conn =mysql_connect('localhost','root','') or die("connect err:".mysql_error());
               mysql_query("use yuangong");
                  if ($idsearch =='all' or $seqsearch == 'all'){
                        if ($idsearch =='all'){$allfields1 = "(id like \"%$idstring%\" or name like \"%$idstring%\" or address like \"%$idstring%\")";}
                        else{$allfields1 = "$idsearch like \"%$idstring%\"";}                        if ($seqsearch =='all'){$allfields2 = "(id like \"%$seqstring%\" or name like \"%$seqstring%\" or address like \"%$seqstring%\")";}
                        else{$allfields2 = "$seqsearch like \"%$seqstring%\"";}


                       // Build SQL Query when at least one all exists
                       $usql = "select worker where $allfields1 $seqao $allfields2"; }

                       // Build SQL Query when no "all" exists
                 else{ $usql = "select worker where $idsearch like \"%$idstring%\" $seqao $seqsearch like \"%$seqstring%\"";}
                 $results = mysql_query("$usql");
                 $numrows = mysql_num_rows($results);
                 $sql_limit = (isset($_GET['limit'])) ? $_GET['limit'] : 0; //get the initial or previous record number
                 $limit_val = 10;  // number of records per page
                 $pagedsql="$usql order by id limit $sql_limit,$limit_val";
                 $pagedresult = mysql_query($pagedsql);?>
    <?php } else{?>      <div   align="center">　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　
      <input   type="button"   name="Submit"   value=" + "   onclick="addRow()">
      <input   type="button"   name="Submit3"   value=" - "   onclick="deleteRow()">
      <br>
      </div>
      <form action="test.php" target="_blank" method="get">
        <table width="958" id="tb">
          <tr> <th width="25%">Select search field </th>
                 <th width="55%">Input your string for searching</th>
                   <th width="20%">Options</th>
            </tr>

          <tr><td align = "center"width="25%"><select name="a1" style="width: 100%">
                                                      <option value = "all">All</option>
                                                      <option value = "id">ID</option>
                                                      <option value = "name">name</option>
                                                      <option value = "address">address</option></select></td>
               <td align = "center" width="55%"><input type="text" size="70%"  name="b1" /> </td>                             </tr>

          <tr id="ModelRow"><td align="center" width="25%"><select name="a2" style="width: 100%">
                                                      <option value = "all">All</option>
                                                      <option value = "id">ID</option>
                                                      <option value = "name">name</option>
                                                      <option value = "address">address</option></select></td>
                <td align = "center" width="55%"><input type="text" size="70%"  name="b2" /> </td>
                <td align = "center" width="20%">
                  <input type="radio" name="c2" value ="and" checked />and    
                  <input type="radio" name="c2" value ="or" />or <br><br><br><br></td>
            </tr>

          <tr id="InsertBefore"><td align = "center"width="25%">
                  <input type="reset" name="reset" value ="Reset" />  
                  <input type="submit" name="submit" value ="Search" /></td>
            </tr>
          </table>
          </form>
          <?php } ?> </td>
    </tr>
</table>
</td></tr></table>
</body>
</html>

解决方案 »