Dynamic checkboxes with the help of PHP

Question

I'm checking the database and if a particular string is matched, the respective checkbox gets checked but the error is whenever a string is matched, I'm getting two checkboxes checked, one unchecked and another checked.

Here is my code:

<?php
     $result = mysqli_query($sql,"SELECT * FROM grsi "); 
     while($row = mysqli_fetch_array($result))
     {
         $focus=explode(",",$row['spr']);
?>
<input type="checkbox" value=<?php echo $row['spr']; if(in_array("Cricket",$focus)) { ?> checked="checked" <?php } ?> name="focus[]" />Cricket
<?php
     }
  exit();
?>

my output a unchecked checkbox followed by cricket and a checked checkbox followed by cricket — user3225075
– user3225075, Commented Dec 5, 2014 at 8:04
what u_mulder means i guess is the example contents of $row['spr'] — Kevin
– Kevin, Commented Dec 5, 2014 at 8:05
i am having just one row in my database which contains Cricket in spr column — user3225075
– user3225075, Commented Dec 5, 2014 at 8:06

Tristup · Accepted Answer · 2014-12-05 08:08:10Z

2

<input type="checkbox" value="<?php echo $row['spr']; ?>" <?php if(in_array("Cricket",$focus)) { ?> checked="checked" <?php } ?> name="focus[]" />Cricket

I hope this will work properly. Please let me know if it didnt work.

answered Dec 5, 2014 at 8:08

Tristup

3,6381 gold badge16 silver badges26 bronze badges

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

7 Comments

user3225075 Over a year ago

i tried your answer but still the same issue one unchecked and another checked checkbox

Tristup Over a year ago

Please check the Result Array may have duplicate entry too.

Tristup Over a year ago

GOT IT , mysqli_fetch_assoc($result)

Tristup Over a year ago

Actually mysqli_fetch_array will return bot associative and index result array so if the result row no is 1 it will return 2. 1 for associative and another for indexed element. This is the actual issue with you.

Rhumborl Over a year ago

but he's just checking $row['spr'], not for ($x in $row)..., tho i agree mysqli_fetch_assoc is probably more efficient

|

Amit Kumar Sahu · Accepted Answer · 2014-12-05 08:11:54Z

1

 <?php
 $result = mysqli_query($sql,"SELECT * FROM grsi "); 
 while($row = mysqli_fetch_array($result))
 {
 $focus=explode(",",$row['spr']);
  if(in_array("Cricket",$focus)) {
 ?>
<input type="checkbox" value=<?php echo $row['spr'];  ?> checked="checked"  name="focus[]" />Cricket

<?php
}else{
?>
  <input type="checkbox" value=<?php echo $row['spr'];  ?> name="focus[]" />Checkbox name
<?php
}
}
exit();

?>

answered Dec 5, 2014 at 8:11

Amit Kumar Sahu

4956 silver badges16 bronze badges

4 Comments

user3225075 Over a year ago

still the same issue :-(

Amit Kumar Sahu Over a year ago

May i know string in your database

user3225075 Over a year ago

my string in spr is Cricket

Amit Kumar Sahu Over a year ago

So no need to exploding the string "$focus=explode(",",$row['spr']); if(in_array("Cricket",$focus))" instead of these try only "if($row['spr']=='Cricket')"

jroi_web · Accepted Answer · 2014-12-05 08:18:24Z

1

Your input checkbox is inside your while loop which means if there are 2 rows from the database, there will be 2 input boxes.

And based on you SQL statement, you are selecting all records(there is no WHERE statement). So if there are 10 rows in your table, there will be 10 input box. Make sure you will only select the row that you need.

answered Dec 5, 2014 at 8:18

jroi_web

1,98422 silver badges23 bronze badges

1 Comment

user3225075 Over a year ago

on your suggestion, i tried adding another product in database and on executing above code i got 4 checkboxes 2 unchecked and 2 checked

Collectives™ on Stack Overflow

Dynamic checkboxes with the help of PHP

3 Answers 3

7 Comments

4 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

7 Comments

4 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related