这是我的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行多个值插入数据库?
计算您的某些字段,并尝试使用for
该计数的循环进行迭代,并尝试使用loop的$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
}
本文收集自互联网,转载请注明来源。
如有侵权,请联系 [email protected] 删除。
我来说两句