您需要使用Ajax来正确地执行PHP和SQL查询。
要使用Ajax,您需要创建另一个PHP脚本并根据您的情况创建函数,应该是这样的。
$row = $_POST['row'];
$html = "<tr id='row" .$row ."'><td>";
$html .= "<input type='text' name='name[]' placeholder='Enter your Name' class='form-control name_list' /><td>";
$html .= "<input type='text' name='prenom[]' placeholder='Enter your prenom' class='form-control name_list' /></td>";
$html .= "</td><td><input type='text' name='cin[]' placeholder='Enter your cin' class='form-control name_list' /></td>";
$html .= "<td><input type='number' name='cnss[]' placeholder='Enter your cnss' class='form-control name_list' /></td>";
$html .= "<td><input type='email' name='email[]' placeholder='Enter your email' class='form-control name_list' /></td>";
$html .= "<td><select name='theme[]' class='form-control select_list'>";
WHILE($tab=mysqli_fetch_assoc($exe)){
$html .= "<option>{$tab['libelle']}</option>";
}
$html .= "</select></td><td><button type='button' name='remove' id='row$row' class='btn btn-danger btn_remove'>X</button></td></tr>";
echo json_encode(array("success"=>$html));
在您需要在HTML脚本或Java脚本上创建Ajax函数之后,它应该是这样的。
$(document).ready(function(){
var i=1;
$('#add').click(function(){
i++;
$.ajax({
url:"newCreatedScript.php",
type: "POST",
data: {row:i},
success:function(data){
var $response = $.parseJSON(data);
$('#dynamic_field').append(data.success);
}
});
});
$(document).on('click', '.btn_remove', function(){
var button_id = $(this).attr("id");
$('#row'+button_id+'').remove();
});
});