Add Checked in Checkbox if same value in database

Question

I try to add checked in my checkbox, if a value in checkbox is same with the value from database:

My database : Column = fees_month[] Value = '$row[month]'

My Default checkbox :
echo "<th >"."<input type='checkbox' name='fees_month[]' value= '$row[month]' checked='isChecked('$row[month]',$fees_month)' >". $row['month']."</th>";

$q = mysqli_query($conn,"SELECT * FROM fees WHERE registration_number='$qry[registration_number]'");

while ($info = mysqli_fetch_array($q)) {
    $fees_month = explode(", ", $info['fees_month']);
}

function isChecked($val, $arr) {
    if (in_array($val, $arr)) {
        echo 'checked';
    }
}

$q = mysqli_query($conn,"SELECT fees_month FROM fees WHERE registration_number='$qry[registration_number]'"); while($info = mysqli_fetch_array($q)) { $fees_month = explode(",", $info['fees_month']); function isChecked($val, $arr) { if(in_array($val,$arr)) { echo 'checked'; } } } echo "<th >"."<input type='checkbox' name='fees_month[]' value= '$row[month]' checked='isChecked($val,$arr);'>". $row['month']."</th>"; — Ankit Bhatanagar
– Ankit Bhatanagar, Commented Aug 16, 2015 at 3:11

Danila Ganchar · Accepted Answer · 2015-08-16 08:44:57Z

1

$selected = array();
$pdo = new PDO('mysql:host=localhost;dbname=your_db', 'user', 'password');

$query = $pdo->prepare('
    SELECT fees_month 
      FROM fees 
     WHERE registration_number = :registration_number
');

$query->bindParam('registration_number', $qry[registration_number]);

while ($row = $query->fetch()) {
    $selected[] = $row['fees_month'];
}

$checked = in_array($active, $selected) ? 'checked="checked"' : '';
echo '<input type="checkbox" name="fees_month[]" ' . $checked . ' value="' . $active . '"/>';

// example for testing
$active = 1;
$selected = array(1, 10, 20);
$checked = in_array($active, $selected) ? 'checked="checked"' : '';

echo '<input type="checkbox" name="fees_month[]" ' . $checked . ' value="' . $active . '"/>';

edited Aug 16, 2015 at 8:44

answered Aug 15, 2015 at 22:15

Danila Ganchar

11.5k13 gold badges69 silver badges102 bronze badges

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

1 Comment

Ankit Bhatanagar Over a year ago

Its not working, printing only 'checked' several times without space.

heiglandreas · Accepted Answer · 2015-08-15 21:57:30Z

0

isChecked is not a variable so variable substitution doesn't work here.

You'll have to do something like the following:

'" . isChecked(<params>) . "'

instead.

answered Aug 15, 2015 at 21:57

heiglandreas

3,8611 gold badge21 silver badges23 bronze badges

1 Comment

heiglandreas Over a year ago

Use the code @danila-ganchar provided. It's my solution without the need for you to do something for yourself.

gegham-ayvazyan · Accepted Answer · 2015-08-15 21:58:32Z

0

Html checkbox sends value "on" on submitting if checked. If you are directly saving the submitted value, than you should check if the value is on.

For example variable $checkbox stores the value that you retrieved from database, you can use something like this :

<?php $isChecked = $checkbox == 'on' ? 'checked="checked"' : '';
echo "<input type='checkbox' $isChecked>";
?>

answered Aug 15, 2015 at 21:58

gegham-ayvazyan

412 silver badges12 bronze badges

1 Comment

gegham-ayvazyan Over a year ago

Can you supply more information ? How are you saving the info (if it is checked) ?

Collectives™ on Stack Overflow

Add Checked in Checkbox if same value in database

3 Answers 3

1 Comment

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related