Check checkbox if MYSQL column value true

Question

I have a todo list app. It has a column called completed which has true or false values. I want the checkbox to be checked if completed is true. I came up with the following:

echo "<label>".$row["name"]."</label>
      <input onload='choose(".$row["completed"].")' class='sssss' value='".$row['id']."' type='checkbox'/>";

And

<script src='js/jquery.js'></script>
<script>
function choose(a) {
  $(this).attr('checked', a);
}
</script>

But it isn't working. Please help

Edit

I believe that the js code is only using the first column value for all checkboxes

aynber · Accepted Answer · 2016-02-19 13:41:10Z

2

You can use set the check with PHP:

echo "<label>".$row["name"]."</label>
  <input class='sssss' value='".$row['id']."' type='checkbox' ". ($row['completed'] == 'true') ? 'checked' : ''." />";

The ternary $row['completed'] == 'true' ? 'checked' : '' will echo checked if it's true, and nothing if it's not.

edited Feb 19, 2016 at 13:41

answered Feb 19, 2016 at 13:29

aynber

23.2k9 gold badges57 silver badges69 bronze badges

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

3 Comments

Palash Sharma Over a year ago

Thanks for the reply. But my column has either true or false as the value (false is the default value that can't be checked)

aynber Over a year ago

That's what this does. empty checks to see if the variable exists and if it is equal to 0, empty text ('') or false. So !empty is 1) Does it exist (yes) 2) does it contain a positive value (yes). So it will echo 'checked' if the value is true. And I'm editing the answer to use the correct index (oops).

Palash Sharma Over a year ago

No I mean the column is VARCHAR

Yogesh Shakya · Accepted Answer · 2016-02-19 13:32:29Z

0

Use this:

echo "<label>".$row["name"]."</label>
<input ".($row["completed"]) ? 'checked' : ''." class='sssss' value='".$row['id']."' type='checkbox'/>";

answered Feb 19, 2016 at 13:32

Yogesh Shakya

3553 silver badges15 bronze badges

Comments

Palash Sharma · Accepted Answer · 2016-02-19 13:49:57Z

0

I figured out a different way:

if ($row['completed'] == 'true'){
    echo "<input class='sssss' value='".$row['id']."' type='checkbox' disabled checked/>";
}else {
    echo "<input class='sssss' value='".$row['id']."' type='checkbox' disabled />";
}

answered Feb 19, 2016 at 13:49

Palash Sharma

6781 gold badge10 silver badges18 bronze badges

Collectives™ on Stack Overflow

Check checkbox if MYSQL column value true

3 Answers 3

3 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

3 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related