CHeckbox to update the database

Good Day

Yesterday I tried to ask a question but I think I failed to explained what is it that I clearly searching for. I want an uncheck/check all checkbox, that when clicked all the values in the selected checkboxes be stored into the database, when unchecked be removed. Currently I have the checkbox that i working only to check and uncheck but not doing anything to the database (SQL Server).

"text/javascript">
function toggleChecked(status)
{
$("#checkboxes input").each(function ()
{
$(this).prop("checked", status);
});
}
$(document).ready(function ()
{
// Changing state of CheckAll checkbox
$("#checkboxes").click(function ()
{
if ($("#checkboxes").length == $("#checkboxes input:checked").length)
{
$("#checkall").prop("checked", true);
}
else
{
$("#checkall").removeAttr("checked");
}
});
$("#checkall").click(function ()
{
var status = $("#checkall").prop('checked');
toggleChecked(status);
});
});
Check/Uncheck All
class="switch">
"checkbox" id="checkall">
class="slider round">
"checkboxes" style="height: 500px;position:relative;border:1px solid darkgray">
"div2" style="max-height:100%;overflow:auto;">
"suburbsDiv">

Add another function below toggleStatus

for that selected and another for unselected and send the data

want them selected and sent, then unselected and removed

Ok Attie when u are sending all the data then just iterate through all of them and send to the database or do u want them selected too .

Looking for something similar to what I saw in the blog; http://www.c-sharpcorner.com/UploadFile/145c93/update-database-on-checkbox-change-using-jquery-and-ajax/

But for check all.

Ok cool I will look at that. That is part of the requirements for when the select all is click, all checkboxes should be check, vise versa when unchecked

My Suggestion here thats Not a great way to send the data directly to the database on select all click

$('input[type=checkbox]:checked').each(function() {

// Do something interesting

});

You can use this snippet to Loop through and send the data

Ok, no there is no button click. Only checkboxes. When i click a checkbox it does what I want and when I unclick it also removes the value. Now the checkbox (uncheck/check all) is not doing anything in the database

All Right Atttie

f ($("#checkboxes").length == $("#checkboxes input:checked").length)

{

$("#checkall").prop("checked", true);

}

here u are setting all the values

is there any button click or u want to save the values on this selection Only ?

if there is any button click u need to add the Button click in that You need to Iterate through the CheckBoxes and send these values to the databas e

http://bytutorial.com/blogs/jquery/jquery-get-selected-checkboxes

This article explains it better

8 Replies

Know the answer? Post it — somebody with the same question will find it here.

Mangesh G8y ago
Accepted answer
Add another function below toggleStatus
for that selected and another for unselected and send the data
Attie8y ago
want them selected and sent, then unselected and removed
Mangesh G8y ago
Ok Attie when u are sending all the data then just iterate through all of them and send to the database or do u want them selected too .
Attie8y ago
Looking for something similar to what I saw in the blog; http://www.c-sharpcorner.com/UploadFile/145c93/update-database-on-checkbox-change-using-jquery-and-ajax/

But for check all.
Attie8y ago
Ok cool I will look at that. That is part of the requirements for when the select all is click, all checkboxes should be check, vise versa when unchecked
Mangesh G8y ago
Ok

My Suggestion here thats Not a great way to send the data directly to the database on select all click

$('input[type=checkbox]:checked').each(function() {
// Do something interesting
});

You can use this snippet to Loop through and send the data
Attie8y ago
Ok, no there is no button click. Only checkboxes. When i click a checkbox it does what I want and when I unclick it also removes the value. Now the checkbox (uncheck/check all) is not doing anything in the database
Mangesh G8y ago
All Right Atttie

f ($("#checkboxes").length == $("#checkboxes input:checked").length)
{

$("#checkall").prop("checked", true);

}
here u are setting all the values

is there any button click or u want to save the values on this selection Only ?

if there is any button click u need to add the Button click in that You need to Iterate through the CheckBoxes and send these values to the databas e

http://bytutorial.com/blogs/jquery/jquery-get-selected-checkboxes

This article explains it better