将<td>元素存储到数据库中

Question

I have a dynamically created table. Means the header is fixed and the row data will append dynamically after certain ajax call. My question is how to save quantity value with product_id (which is the <tr> id) in database?

 <tr> 
   <th></th>                   
   <th>Product Name</th>
   <th>Unit Price</th>
   <th>Quantity</th>                   
   <th>Total </th>
 </tr>

// This part will append after ajax call i have used autocomplete search

 <tr id="+ui.item.id+">   // product_id
    <td><i class='flaticon-delete-1 delete-row' onclick='deleteRow(this)'></i></td>
     <td>"+ui.item.value+"</td>
     <td>"+ui.item.unit_price+"</td>
     <td><input type='text' class='quantity' value='1'></td> //quantity
     <td class='total'>"+ui.item.unit_price+"</td>
  </tr>

Answer 1

Store the quantity and product in array:

     <td><input type='text' name="id[]" class='productclass' value='+ui.item.id+'></td>
     <td><input type='text' name="quantity[]" class='quantity' value='1'></td>

if you don't want to show the product id, you can hide:

<input type='hidden' name="id[]" class='productclass' value="+ui.item.id+">

On the server side:

//Check input data
if(in_array("",$_POST['id'], true)){
//Empty id
}else{
  $countid = count($_POST['id']);
  for($j=0;$j<$countid;$j++){
      $id = $_POST['id'][$j];
      $quantity = $_POST['quantity'][$j];
      //code for saving into the database
  }
}