php - 如何使用 php 和 mysql 将创建的行值上的多个 jquery 插入到数据库中？

Question

这是我的 html 代码:

                    <tr>
                        <td><input class="case" type="checkbox"/></td>
                        <td><input type="text" data-type="productCode" name="itemNo[]" id="itemNo_1" class="form-control autocomplete_txt" autocomplete="off"></td>
                        <td><input type="text" data-type="productName" name="itemName[]" id="itemName_1" class="form-control autocomplete_txt" autocomplete="off"></td>
                        <td><input type="number" name="price[]" id="price_1" class="form-control changesNo" autocomplete="off" onkeypress="return IsNumeric(event);" ondrop="return false;" onpaste="return false;"></td>
                        <td><input type="number" name="quantity[]" id="quantity_1" class="form-control changesNo" autocomplete="off" onkeypress="return IsNumeric(event);" ondrop="return false;" onpaste="return false;"></td>
                        <td><input type="number" name="total[]" id="total_1" class="form-control totalLinePrice" autocomplete="off" onkeypress="return IsNumeric(event);" ondrop="return false;" onpaste="return false;"></td>
                    </tr>
                </tbody>
            </table>
        </div>
    </div>
    <div class='row'>
        <div class='col-xs-12 col-sm-3 col-md-3 col-lg-3'>
            <button class="btn btn-danger delete" type="button">- Delete</button>
            <button class="btn btn-success addmore" type="button">+ Add More</button>
        </div>

PHP 代码:

if(isset($_POST['form1'])) { 
  $statement = $db->prepare("INSERT INTO table_products (itemNo,itemName,price,quantity,total) VALUES (?,?,?,?,?)");
  $statement->execute(array($_POST['itemNo'],$_POST['itemName'],$_POST['price'],$_‌​POST['quantity']); 
  $success_message = " inserted successfully."; } catch(Exception $e) { $error_message = $e->getMessage(); } 
} 

这是我的 jquery 代码，用于创建添加更多字段:

var i=$('table tr').length;$(".addmore").on('click',function(){
html = '<tr>';
html += '<td><input class="case" type="checkbox"/></td>';
html += '<td><input type="text" data-type="productCode" name="itemNo[]" id="itemNo_'+i+'" class="form-control autocomplete_txt" autocomplete="off"></td>';
html += '<td><input type="text" data-type="productName" name="itemName[]" id="itemName_'+i+'" class="form-control autocomplete_txt" autocomplete="off"></td>';
html += '<td><input type="text" name="price[]" id="price_'+i+'" class="form-control changesNo" autocomplete="off" onkeypress="return IsNumeric(event);" ondrop="return false;" onpaste="return false;"></td>';
html += '<td><input type="text" name="quantity[]" id="quantity_'+i+'" class="form-control changesNo" autocomplete="off" onkeypress="return IsNumeric(event);" ondrop="return false;" onpaste="return false;"></td>';
html += '<td><input type="text" name="total[]" id="total_'+i+'" class="form-control totalLinePrice" autocomplete="off" onkeypress="return IsNumeric(event);" ondrop="return false;" onpaste="return false;"></td>';
html += '</tr>';
$('table').append(html);
i++;
});

如何使用 php 插入数据库这 2 或 3 行多个值？

Answer 1

计算一些字段并尝试使用 for 进行迭代循环该计数并尝试使用 $i 存储其值for 的变量循环:

for($i=0;$i<count($_POST['itemNo']);$i++)
{
    $data['itemNo']       = $_POST['itemNo'][$i];
    $data['itemName']     = $_POST['itemName'][$i];
    $data['price']        = $_POST['price'][$i];
    $data['quantity']     = $_POST['quantity'][$i];
    $data['total']        = $_POST['total'][$i];
    //your insert query here
}