我正在嘗試使用 php 從動態(tài)創(chuàng)建的數(shù)據(jù)庫中添加刪除字段插入數(shù)據(jù)，但無法執(zhí)行。我只能從原始表單插入數(shù)據(jù)。我的表格看起來像這樣。請幫助我。我的數(shù)據(jù)看起來像這樣 <?phprequire_once "conn.php"; $ch_direction= $ch_direction_through==$reg_id="";if($_SERVER["REQUEST_METHOD"] == "POST"){ for ($i=0; $i < count($_POST['ch_direction']); $i++ ){ $ch_direction = trim($_POST["ch_direction"][$i]); $ch_direction_through = trim($_POST["ch_direction_through"][$i]); $reg_id= $_POST['reg_id'][$i]; $sql = "INSERT INTO bps_registration_charkilla (ch_direction, ch_direction_through,reg_id) VALUES (?, ?, ?)"; if($stmt = mysqli_prepare($conn, $sql)){ mysqli_stmt_bind_param($stmt, "sss",$ch_direction, $ch_direction_through, $reg_id); $reg_id=$reg_id; $ch_direction=$ch_direction; $ch_direction_through=$ch_direction_through; if(mysqli_stmt_execute($stmt)){ if(!empty($reg_id)){ $success = "Submitted form successfully sent"; header("location: registration_detail.php?success=$success&id=".$reg_id); exit(); } else { header("location: registration_detail.php"); exit(); } } else { echo "Something went wrong. Please try again later."; } } } mysqli_close($conn);}?>$(document).ready(function() { var max_fields = 15; //maximum input boxes allowed var wrapper = $(".input_fields_wrap"); //Fields wrapper var add_button = $(".add_field_button"); //Add button ID var x = 1; //initlal text box count $(add_button).click(function(e){ //on add input button clicf k e.preventDefault(); if(x < max_fields) { //max input box allowed x++; //text box increment } }); $(wrapper).on("click",".remove_field", function(e) { //user click on remove text e.preventDefault(); $(this).parent('div').remove(); x--; });});
2 回答
寶慕林4294392
TA貢獻2021條經(jīng)驗 獲得超8個贊
您在循環(huán)內(nèi)分配變量，但在循環(huán)后僅插入一次數(shù)據(jù)庫。將您的數(shù)據(jù)庫插入放入循環(huán)中，如下所示（為了更好地理解這個想法，我保持簡短）：
for ($i=0; $i < count($_POST['ch_direction']); $i++ ) { // Here you start each loop
$ch_direction = trim($_POST["ch_direction"][$i]);
$ch_direction_through = trim($_POST["ch_direction_through"][$i]);
$reg_id= $_POST['reg_id'][$i];
$sql = "INSERT INTO bps_registration_charkilla (ch_direction, ch_direction_through,reg_id) VALUES (?, ?, ?)";
...
if($stmt = mysqli_prepare($conn, $sql)) ... // Here you prepare the statement for the current element in the loop
...
if(mysqli_stmt_execute($stmt)) ... // Here you actually insert current loop element into the database
...
} // End of the loop
- 2 回答
- 0 關注
- 225 瀏覽
添加回答
舉報
0/150
提交
取消