How to set value of checkbox when checked and unchecked using ajax or jquery

Question

I need to get the value of the checkboxes when checked and unchecked and save it in database. The value is 1 if checked and 0 if unchecked, respectively. I am currently using the snippet below and it show the result i want when i alert it. But the problem comes when saving in the database. It still gets the value I have set in my checkbox E.G: value='1'.

Here is my jQuery code:

$(document).ready(function() {
    $('input[type="checkbox"]').click(function() {
        var val = this.type == "checkbox" ? +this.checked : this.value ;            
    });
});

Here is my HTML checkbox:

<input type="checkbox" value="1" name="one_by_one" id="one_by_one" class="one_by_one">One

@j08691 I was using an html form in codeigniter. So when i press save button the data will be saved in the mysql database. — jjydummya
– jjydummya, Commented Oct 6, 2014 at 16:16
Probably something like $value = isset($_POST['one_by_one']) ? 1 : 0;. If you are using codeigniter than it might provide helper functions for accessing the data of a request. — Felix Kling
– Felix Kling, Commented Oct 6, 2014 at 16:19
@FelixKling Is there a way to set it on client side? Jquery perhaps? — jjydummya
– jjydummya, Commented Oct 6, 2014 at 16:23

Alex Char · Accepted Answer · 2014-10-06 16:16:25Z

5

Probably you want this:

$('input[type="checkbox"]').click(function () {
    $(this).prop("checked") ? $(this).val("1") : $(this).val("0")
});

<script src="https://ajax.googleapis.com/ajax/libs/jquery/2.1.1/jquery.min.js"></script>
<input type="checkbox" value="1" name="one_by_one" id="one_by_one" class="one_by_one">One

answered Oct 6, 2014 at 16:16

Alex Char

33.3k9 gold badges51 silver badges71 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

jjydummya Over a year ago

Thanks for your reply. Does this works for multiple checkboxes?

jjydummya Over a year ago

Hi. I've tried your code but the value being saved in database is still 1.

Wilf Over a year ago

Searched for the solution over the stack. And finalized here!!! Thanks a million.

Felix Kling · Accepted Answer · 2014-10-06 16:16:57Z

2

The value of a checkbox never changes (by itself). If the checkbox is not checked its value simply won't be sent to the server. So at the server side you should check whether one_by_one is included in the request and set the value accordingly (e.g. set 0 if it doesn't exist or the value of one_by_one if it does).

answered Oct 6, 2014 at 16:16

Felix Kling

820k181 gold badges1.1k silver badges1.2k bronze badges

2 Comments

jjydummya Over a year ago

Thanks for your reply. How can i set the value accordingly on php? Can you give me some snippet?

Felix Kling Over a year ago

Probably something like $value = isset($_POST['one_by_one']) ? 1 : 0;.

Collectives™ on Stack Overflow

How to set value of checkbox when checked and unchecked using ajax or jquery

2 Answers 2

3 Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related