Select Value from DB Array inside check box input

Question

Hello I am using various check boxes with different values and than storing the vales inside DataBase as all the checkboxes values are store inside Array

<input type="checkbox" value="Gym" id="details_10" name="utilities[]">
<input  type="checkbox" value="Spa" id="details_11" name="utilities[]">

and than store in the database like: Gym, Spa.

Later I am making MySQL query inside edit form where I will be able to edit those and other parameters. For the other inputs I am using:

<?php if($row['data'] == 'Sample Data'){echo 'selected="selected"';}?>

In this case I would like to use something like the following:

<input  type="checkbox" value="Gym" id="details_10" name="utilities[]"<?php if($row['utilities'] == 'Gym'){echo 'checked"';}?>>

Any help to achieve this result will be very welcome.

Akshay · Accepted Answer · 2015-08-05 16:02:23Z

1

I've always used this in these cases.

<?php
if($row['utilities'] == 'Gym')
{
    ?>
    <input  type="checkbox" value="Gym" id="details_10" name="utilities[]" checked="checked">
    <?php
}
else
{
    ?>
    <input  type="checkbox" value="Gym" id="details_10" name="utilities[]">
    <?php
}
?>

answered Aug 5, 2015 at 16:02

Akshay

2,2393 gold badges17 silver badges35 bronze badges

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

4 Comments

John Siniger Over a year ago

The problem is that utilities is an array something like that: Gym, Spa, ... It is not a single value. So the problem is how to say if some of the values in this array is Gym than yes echo checked="checked"

Akshay Over a year ago

Do a var_dump of your array and post here/

John Siniger Over a year ago

2 Parqueos, Area de niños

John Siniger Over a year ago

okay I made it work like this : (strpos($row['utilities_spanish'],'Area de niños') !== false) thanks for your help !

Collectives™ on Stack Overflow

Select Value from DB Array inside check box input

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related