How to display checkbox, that binds dynamically using ajax and php

Question

I need to display checkbox that binds dynamically using ajax and php .

my code is

<?php

include 'dbconnect.php';
$result = mysqli_query($link, "SELECT * FROM city where district_id='$dist' ");

while($city_row=mysqli_fetch_array($result)){
    ?>

    <input type="checkbox" value="<?php echo $city_row['id']; ?>"/><?php echo $city_row['city_name']; ?>
<?php
}
}

?>

ajax script

$.ajax({

type: "POST",
cache: false,
url: "get_locality.php",
    data:{districts:hi },
success: function(response){
    alert(response);
    $('#city').html(response);

}
});

html div

<div class="checkbox" ><span id="city">

                            </span>

                        </div>

but it only displays the values . not displaying the checkboxes

$dist where is that defined?

Funk Forty Niner
– Funk Forty Niner

2018-04-10 11:49:14 +00:00
Commented Apr 10, 2018 at 11:49 — Funk Forty Niner
– Funk Forty Niner, Commented Apr 10, 2018 at 11:49
districts:hi where are those defined?

junkystu
– junkystu

2018-04-10 11:49:57 +00:00
Commented Apr 10, 2018 at 11:49 — junkystu
– junkystu, Commented Apr 10, 2018 at 11:49
Seems like I've fallen onto deaf ears.

Funk Forty Niner
– Funk Forty Niner

2018-04-10 11:56:12 +00:00
Commented Apr 10, 2018 at 11:56 — Funk Forty Niner
– Funk Forty Niner, Commented Apr 10, 2018 at 11:56

Jay Blanchard · Accepted Answer · 2018-04-10 11:57:26Z

-1

The issue is you print only the value of checkbox and not the checkbox html. So store all code inside one variable and print that variable.

<?php
include 'dbconnect.php';
$result = mysqli_query($link, "SELECT * FROM city where district_id='$dist' ");
$str = '';
while($city_row=mysqli_fetch_array($result)){
$str .= '<input type="checkbox" value="'.$city_row['id'].'"/>'.$city_row['city_name'];
}
echo $str;
?>

edited Apr 10, 2018 at 11:57

Jay Blanchard

34.5k17 gold badges82 silver badges130 bronze badges

answered Apr 10, 2018 at 11:51

Pragna

4701 gold badge3 silver badges18 bronze badges

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

3 Comments

Jay Blanchard Over a year ago

Why should the OP "use below code"? A good answer will always have an explanation of what was done and why it was done in such a manner, not only for the OP but for future visitors to SO.

Pragna Over a year ago

Yes @JayBlanchard , You are right. I add description of the issue. Thank you for correcting me :)

Takit Isy Over a year ago

Another solution with double quotes (more readable in my opinion), which avoid the multiple concatenations: $str .= "<input type='checkbox' value='{$city_row['id']}'/>{$city_row['city_name']}";

Collectives™ on Stack Overflow

How to display checkbox, that binds dynamically using ajax and php

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related