我有一個(gè) html 表，每行都有一個(gè)動態(tài)創(chuàng)建的復(fù)選框。復(fù)選框的選中狀態(tài)是根據(jù)數(shù)據(jù)庫中的值設(shè)置的。當(dāng)在 html 表中選中復(fù)選框時(shí)，我需要捕捉更改并設(shè)置值，以便如果選中該框，則 value=1 else value=0。值被傳遞給更新查詢。我不確定如何用我當(dāng)前的代碼來完成這個(gè)。HTML：<?php $sqlGetEmployees = "select e.employeeID, e.lastName, e.firstName, l.number, p.name, e.gradeCertLevel, e.serviceYears, e.step, e.certified from employee e join location l on l.locationID = e.locationID join position p on p.positionID = e.positionID"; $stmtGetEmployees = mysqli_prepare($db,$sqlGetEmployees); mysqli_stmt_execute($stmtGetEmployees); mysqli_stmt_bind_result($stmtGetEmployees, $id, $lastName, $firstName, $number, $name, $gradeCertLevel, $serviceYears, $salaryStep, $certified); $count = 1; while(mysqli_stmt_fetch($stmtGetEmployees)) { $checkedCertified = ($certified == '1') ? 'checked="checked"':'';?> <tr> <!-- other table data --> <td> <div id='certified_<?php echo $id; ?>'> <input contentEditable='true' class='edit' type='checkbox' id='certified' <?php echo $checkedCertified; ?> /> </div> </td> </tr><?php $count ++; } mysqli_stmt_close($stmtGetEmployees);?> 腳本： // Add Class $('.edit').click(function(){ $(this).addClass('editMode'); }); // Save data $(".edit").focusout(function(){ $(this).removeClass("editMode"); var id = this.id; var split_id = id.split("_"); var field_name = split_id[0]; var edit_id = split_id[1]; var value = $(this).text(); $.ajax({ url: 'update.php', type: 'post', data: { field:field_name, value:value, id:edit_id }, success:function(response){ console.log('Save successfully'); } }); });
1 回答
紫衣仙女
TA貢獻(xiàn)1839條經(jīng)驗(yàn) 獲得超15個(gè)贊
對于動態(tài)創(chuàng)建的元素，事件的處理方式如下：
$(document).on('click', '.edit', function(e) {
//e.preventDefault();
var checkedStatus = 0;
if ($(this).is(':checked')) {
$(this).addClass('editMode');
checkedStatus = 1;
} else {
checkedStatus = 0;
$(this).removeClass("editMode");
}
var id = this.id;
var split_id = id.split("_");
var field_name = split_id[0];
var edit_id = split_id[1];
var value = $(this).text();
$.ajax({
url: 'update.php',
type: 'post',
data: { field:field_name, value:value, id:edit_id, checked: checkedStatus },
success:function(response){
console.log('Save successfully');
}
});
});
要將所有內(nèi)容放入單個(gè)事件處理程序中，您可以將所有內(nèi)容放入 .click 或 .focusout 中，具體取決于您要實(shí)現(xiàn)的目標(biāo)。
- 1 回答
- 0 關(guān)注
- 196 瀏覽
添加回答
舉報(bào)
0/150
提交
取消