为每个序列化Id和PHP

Question

Hello i need some jQuery help by giving serial ids to input text like qty0 , rate1 , amt2 i++ so on document load or by giving addnew row button

This is my html code

<tr class="item-row1">
   <td><input id="qty1" name="qty1" type="text"></td>
   <td>
      <select id="selectitem1">
         <option value="">Select One...</option>    
         <option value="17">Apple</option>
         <option value="18">Orange</option>
         <option value="9">Banana</option>     
      </select>
   </td>
   <td><input id="desc1" name="desc1" type="text"></td>
   <td><input id="rate1" name="rate1" type="text"></td>
   <td><input id="amt1"  name="amt1"  type="text"></td>
</tr>

<tr class="item-row2">
   <td><input id="qty2" name="qty2" type="text"></td>
   <td>
       <select id="selectitem">
          <option value="">Select One...</option>    
          <option value="17">Apple</option>
          <option value="18">Orange</option>
          <option value="9">Banana</option>     
       </select>
   </td>
   <td><input id="desc2" name="desc2" type="text"></td>
   <td><input id="rate2" name="rate2" type="text"></td>
   <td><input id="amt2"  name="amt2" type="text"></td>
</tr>

and so on..!

Please help me with creating a php code right now i am using this code

$id1 = $_POST['id1'];
$qty1 = $_POST['qty1'];
$qty2 = $_POST['qty2'];
$rate1 = $_POST['rate1'];
$rate2 = $_POST['rate2'];
sql_query =" INSERT INTO products (id,qty,rate,amt) WHERE id = $id VALUES ($id,$qty,$rate,$amt);

I want to create a loop code and i don't know how will i get all possible values from page and post into MySQL WHERE id = $id + number

Answer 1

for each of the incrementing names, like desc1, desc2, rate1, rate2, etc, you can write them as desc[], selectItem[], etc. This array snytax will show up in PHP as $_POST['selectItem'] and it will be an array. Then you can just loop over one of these and make all the INSERTS, i.e.

 for($i = 0, $l = count($_POST['selectItem']); $i < $l; $i++)){
   sql_query ="INSERT INTO products (id,qty,rate,amt) WHERE id = $id VALUES ('" . $_POST['selectItem'][$i] . "','" . $_POST['qty'][$i] . "', '" . $_POST['rate'][$i] . "', '" . $_POST['amt'][$i] . "')";
    //execute query
 }