How to populate checkbox from ajax

Question

I have form containing checkboxes,i want to populate their data from database through ajax, I want to make the available products checked as the value in the database ,also if the data in the database is rather than "Cacao, Coconuts, Bananas" i have to put it in the textbox of others checkbox "ex: Apple" i did that for the textbox but i couldn't for checkbox, how can this be done?

Html code

<div class="row">
<div class="col-sm-4">
    <label class="Modallabel">Available Products:</label>
</div>
<div class="col-sm-8">
    <label id="Pro_chkbox" class="checkbox-inline"><input name="check_list[]" type="checkbox" value="Cacao">Cacao</label>
    <label id="Pro_chkbox" class="checkbox-inline"><input name="check_list[]" type="checkbox" value="Coconuts">Coconuts</label>
    <label id="Pro_chkbox" class="checkbox-inline"><input name="check_list[]" type="checkbox" value="Bananas">Bananas</label><br>
    <label id="Pro_chkbox" class="checkbox-inline"><input name="check_list[]" type="checkbox" id="optcheck" value="Others">Others</label>
     <input type="text" id="Other_pro" name="otherproduct" disabled><br>
    <label id="Note">(Separate Products with commas)</label>
</div>

Ajax

$.ajax({
    type:"POST",
    url:"EditFarmerData.php",
    dataType: 'json',
    data:{'EditFarmerID': EditFarmerID},
    success: function (data) 
        {
            $("#EditFarmerFName").val(data.FarmerFirstName) ;

        }
})

PHP Code

$EditFarmerID = $_POST['EditFarmerID'];

    $sql="SELECT * FROM Farmers where Farmer_ID='".$EditFarmerID."'";

    foreach ($conn->query($sql) as $row)
        {
            $FarmerFirstName=$row['first_name_'];
            $FarmerAvailableProducts = $row['Available_Products'];
        }
    $json = array(
        "FarmerFirstName" => $FarmerFirstName,
        "FarmerAvailableProducts " => $FarmerAvailableProducts 
        $categories = '';
            $cats = explode(",", $FarmerAvailableProducts);
            foreach($cats as $cat) {
                $cat = trim($cat);
                $categories .= "<category>" . $cat . "</category>\n";
            }
    );
    echo json_encode($json);

How it looks like your json data?

Ataur Rahman Munna
– Ataur Rahman Munna

2017-09-20 09:03:58 +00:00
Commented Sep 20, 2017 at 9:03 — Ataur Rahman Munna
– Ataur Rahman Munna, Commented Sep 20, 2017 at 9:03
your checkbox id should be unique

Arun Kumaresh
– Arun Kumaresh

2017-09-20 09:06:44 +00:00
Commented Sep 20, 2017 at 9:06 — Arun Kumaresh
– Arun Kumaresh, Commented Sep 20, 2017 at 9:06
here you can check stackoverflow.com/questions/10930048/…

Ahmed Ginani
– Ahmed Ginani

2017-09-20 09:11:58 +00:00
Commented Sep 20, 2017 at 9:11 — Ahmed Ginani
– Ahmed Ginani, Commented Sep 20, 2017 at 9:11

Ataur Rahman Munna · Accepted Answer · 2017-09-20 09:14:43Z

2

You can use Attribute Equals Selector [name="value"] to get the checkboxes with particular value.

 $("input[type=checkbox][value=Bananas]").prop("checked",true);

In your case, you have to check response and you can go with loop and change value=bananas with your variable

edited Sep 20, 2017 at 9:14

Ataur Rahman Munna

3,9151 gold badge25 silver badges35 bronze badges

answered Sep 20, 2017 at 9:08

Ahmed Ginani

6,6452 gold badges17 silver badges33 bronze badges

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

Comments

Syed Amir Hussain · Accepted Answer · 2017-09-20 09:10:53Z

0

Use the below code:

success: function (data) 
{
    ...
    ....
    $('input[value="'+data.FarmerFirstName+'"]').prop('checked', 'checked');
    ....
    ....
}

Hope this will help

answered Sep 20, 2017 at 9:10

Syed Amir Hussain

629 bronze badges

Collectives™ on Stack Overflow

How to populate checkbox from ajax

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related