I have multiple check boxes 32 to be exact.
<input type="checkbox" class="custom-control-input" id="m1"> -> <input type="checkbox" class="custom-control-input" id="m32">
On my Javascript I am checking each check box if it is checked or not the I will assign a value 1 for checked and 0 for unchecked.
//I got 32 of these
if (document.getElementById("m1").checked){
m1 = '1';
}
else{
m1 = '0';
}
Then I am sending the data using Ajax.
$.ajax({
url: 'submit-user-details.php',
method: 'POST',
dataType: 'TEXT',
data: {firstname : firstname, lastname : lastname, middlename : middlename, usercd : usercd, password : password, usergrp : usergrp, userstatus : userstatus, branch : branch, m1 : m1, m2 : m2, m3 : m3, m4 : m4, m5 : m5, m6 : m6, m7 : m7, m8 : m8, m9 : m9, m10 : m10, m11 : m11, m12 : m12, m13 : m13, m14 : m14, m15 : m15, m16 : m16, m17 : m17, m18 : m18, m19 : m19, m20 : m20, m21 : m21, m22 : m22, m23 : m23, m24 : m24, m25 : m25, m26 : m26, m27 : m27, m28 : m28, m29 : m29, m30 : m30, m31 : m31, m32 : m32},
success: function(response) {
$('#confirmModal').modal('hide');
});
Then in my PHP, each value have their own Insert Query (Note: please ignore my query I know that this is not secured but I am currently using an old version of XAMPP there is no PDO support for Oracle).
//I got 32 of these
$modulerightsql = oci_parse($conn, "INSERT INTO ASUSERMODULERIGHTS(USERCD, SWITCH, MODULEID) VALUES('". $usercd ."', '". $m32 ."', '32')");
oci_execute($modulerightsql);
Is there a better way to save the value of my check boxes better?
Aucun commentaire:
Enregistrer un commentaire