Add CheckBox Checked values in DataBase Jquery

Question

How to save Checkbox Checked values in Database

Below is my code

<input type="text"  value="" name="Productname" />

<input type="checkbox" name="Product" value="0.5">
<input type="checkbox" name="Product" value="0.07">
<input type="checkbox" name="Product" value="0.5">
<input type="checkbox" name="Product" value="0.63">
<input type="checkbox" name="Product" value="0.63">
<input type="checkbox" name="Product" value="0.5">

 <input type="submit" id="btn1" value="Add" class="btn btn-primary" />

Here on submit click I want to save Checked values under One Productname and want to send as an object to controller

Farzad Farazi A. · Accepted Answer · 2018-07-07 12:07:42Z

1

At first set id for each checkbox. When click on #btn1, read all checkboxes and if checked, store checkbox's id in selected[] array. Then send it by jquery ajax to target page.

    $("#btn1").click(function () {

            var selected = new Array();
            var i = 0;
            $(':checkbox').each(function () {
                var checked_status = this.checked;
                if (checked_status == true) {
                    selected[i] = $(this).attr("id");
                    i++;
                }
            });


            $.ajax({
                url: "Ajax.aspx", //Target page address
                type: "GET",
                async: true,
                cache: false,

                data: { s: selected },

                success: function (text) {
                    alert("successfully:" + text);
                    $("input:checkbox").each(function () {
                        if ($(this).attr("checked")) {
                            $(this).prop('checked', false);
                        }
                    });
                },
                error: function (xhr, status, error) {
                    alert("Error: " + status + error);                    
                }
            });
});

edited Jul 7, 2018 at 12:07

answered Jul 7, 2018 at 11:38

Farzad Farazi A.

261 silver badge6 bronze badges

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

1 Comment

Pankash Mann Over a year ago

Thanks for providing me answer but instead of id of checkbox I used val to get value of checkbox ,and when i console the list i get the selected value but last value is "on". What it can be ?

Pramod · Accepted Answer · 2018-07-07 11:35:54Z

Try below code for get all checkbox value.

<form  method="POST">
<input type="text"  value="" name="Productname" />

<input type="checkbox" name="Product" value="0.5" id="myCheck">
<input type="checkbox" name="Product" value="0.07">
<input type="checkbox" name="Product" value="0.5">
<input type="checkbox" name="Product" value="0.63">
<input type="checkbox" name="Product" value="0.63">
<input type="checkbox" name="Product" value="0.5">

 <input type="button" id="btn1" value="Add" class="btn btn-primary" onclick="myFunction(this.form)"/>
 </form>

<script>
function myFunction(frm) {
var values = "";

    for (var i = 0; i < frm.Product.length; i++)
    {

        if (frm.Product[i].checked)
        {

                values = values+frm.Product[i].value + ",";

        }
    }
    alert(values);
}
</script>

Collectives™ on Stack Overflow

Add CheckBox Checked values in DataBase Jquery

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related