How to make Multiple PHP checkbox set to checked based on database result?

Question

I wanna edit an info of a checkbox in a page but when I clicked the edit link I want the already selected multiple checkbox from the database to be set as checked. But the result I get from my code is that only the last selected checkbox is set as checked(ticked) instead of all the selected checkbox.

Here's my code:

<td><input type = "checkbox" name = "checkbox[]" value = "Badminton" <?php if($interest == 'Badminton') echo "checked = 'checked'"; ?>/>Badminton</td>
<td><input type = "checkbox" name = "checkbox[]" value = "Baseball" <?php if($interest == 'Baseball') echo "checked = 'checked'"; ?>/>Baseball</td>
<td><input type = "checkbox" name = "checkbox[]" value = "Basketball" <?php if($interest == 'Basketball') echo "checked = 'checked'"; ?>/>Basketball</td>
<td><input type = "checkbox" name = "checkbox[]" value = "Cricket" <?php if($interest == 'Cricket') echo "checked = 'checked'"; ?>/>Cricket</td>
<td><input type = "checkbox" name = "checkbox[]" value = "Football" <?php if($interest == 'Football') echo "checked = 'checked'"; ?>/>Football</td>

and heres my sql code:

$sql = "SELECT * FROM interest where username = '$username'";
$result = $conn->query($sql);
if($result->num_rows > 0)
{
    while($row = $result->fetch_assoc())
    {
        $interest = $row['interest_name'];
    }
}

you need to make the creation of the <tds happen within the while loop, so that you can use the current value of $interest at each iteration of the loop. — ADyson
– ADyson, Commented Feb 27, 2019 at 12:14
What wrong you are doing is that every time you are overriding the $interest. You need to implement some logic to save all values in an array and then in your PHP code put check accordingly whether the value exists or not. Edit: See the answer of @devpro — Jayesh Dhandha
– Jayesh Dhandha, Commented Feb 27, 2019 at 12:20
@ADyson I don't think that makes any difference(I have checked after your help). — Sang Tonsing
– Sang Tonsing, Commented Feb 27, 2019 at 12:21
Clearly, I'm the exception, not the rule, but I just don't answer questions that begin 'I wanna' — Strawberry
– Strawberry, Commented Feb 27, 2019 at 12:22

pr1nc3 · Accepted Answer · 2019-02-27 12:22:55Z

4

First of all your if you want to use all the values coming from your query you need to store them in an array something like:

while($row = $result->fetch_assoc())
{
    $interest[] = $row['interest_name'];
}

Now when it comes to your html you can go like:

<td><input type = "checkbox" name = "checkbox[]" value = "Football" <?php if(in_array('Football',$interest)) echo "checked = 'checked'"; ?>/>Football</td>

Just the first example, you should do it in all of them.

answered Feb 27, 2019 at 12:22

pr1nc3

8,3763 gold badges27 silver badges40 bronze badges

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

1 Comment

Sang Tonsing Over a year ago

can you help me for the next step @pr1nc3 on how to update that updated checkbox in database

devpro · Accepted Answer · 2019-02-27 12:29:14Z

3

You can store your values in to an array then you can use in_array() to check:

<?php
$interest = array(); // initializing  
while($row = $result->fetch_assoc())
{
    $interest[] = $row['interest_name']; // store in an array
}
?>

HTML:

<td>
     <input type = "checkbox" name = "checkbox[]" value = "Badminton" <?=(in_array('Badminton',$interest) ? 'checked="checked"' : '')?> />Badminton
</td>

Side Note: Change other checkbox as same above with different values which you have.

edited Feb 27, 2019 at 12:29

answered Feb 27, 2019 at 12:19

devpro

16.1k3 gold badges29 silver badges39 bronze badges

9 Comments

devpro Over a year ago

@SangTonsing: print_r($interest) check what r u getting in this and share

Sang Tonsing Over a year ago

I have tried but still none is selected. Anyway @pr1nc3 gave the right one. But really appreciate for your [email protected] You

devpro Over a year ago

both code same actually i was using 'checked=""' which was not working in your code so you need to change 'checked=""' with 'checked="checked"' if want to use ternary operator @SangTonsing

Sang Tonsing Over a year ago

Yeah good to know that too, Thank you so much for your help @devpro

Sang Tonsing Over a year ago

can you help me for the next step on how to update the value of that updated checkbox in a database @devpro

|

Collectives™ on Stack Overflow

How to make Multiple PHP checkbox set to checked based on database result?

2 Answers 2

1 Comment

9 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

9 Comments

Your Answer

Sign up or log in

Post as a guest

Related