Populate Checkbox from Database Query

Question

I'm trying to check a check box, if the value for that field is 1 in the database.

I have:

<?php 

$selectedSPK=$_POST['SPKSelect'];
$assigned = $_POST['Sales_Exec'];
$date = $_POST['DateSelect'];

if ($selectedSPK) {
    $Priorityquery = "SELECT  Priority FROM Data WHERE SPKCustNo  = '$selectedSPK' ";
    $Priorityresult = mysql_query($Priorityquery);
    $row = mysql_fetch_array($Priorityresult);
    $checked = $Priorityresult['Priority'];
}
?>
<input name="PriorityCheckBox" type="checkbox" value="1" 
<?php if ($checked == 1) echo ' checked'; ?> />

but not getting any joy, any ideas?

you aren't using the result data...

Bhuvan Rikka
– Bhuvan Rikka

2012-10-03 11:52:25 +00:00
Commented Oct 3, 2012 at 11:52 — Bhuvan Rikka
– Bhuvan Rikka, Commented Oct 3, 2012 at 11:52

Chris · Accepted Answer · 2012-10-03 11:48:49Z

1

Try this:

You were not using the row returned by the query...

<?php 
    $selectedSPK=$_POST['SPKSelect'];
    $assigned = $_POST['Sales_Exec'];
    $date = $_POST['DateSelect'];
    if ($selectedSPK)
    {
        $Priorityquery = "SELECT  Priority FROM Data WHERE SPKCustNo  = '$selectedSPK' ";
        $Priorityresult = mysql_query($Priorityquery);
        $row = mysql_fetch_array($Priorityresult);
        //$checked = $Priorityresult['Priority']; // <------ this is where you went wrong...
        $checked = $row['Priority']; // <------ this will fix where u went wrong!
    }
    ?>
    <input name="PriorityCheckBox" type="checkbox" value="1" <?php if ($checked == 1){echo ' checked'; }?>

answered Oct 3, 2012 at 11:48

Chris

5,6151 gold badge28 silver badges31 bronze badges

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

2 Comments

Chris Spalton Over a year ago

Awesome, thanks a lot Chris, new to this so it's tricky to get this stuff right, worked like a charm though, much appreciated, and thanks for showing me where I went wrong.

Chris Over a year ago

No worries, we all started somewhere :)

kabuto178 · Accepted Answer · 2012-10-03 11:51:10Z

1

You should use

<?php if ($checked == 1){echo "checked='checked'"; }

and also

$checked = $Priorityresult['Priority'];

to

 $checked = $row['Priority'];

answered Oct 3, 2012 at 11:51

kabuto178

3,1774 gold badges46 silver badges67 bronze badges

Comments

Djomla · Accepted Answer · 2012-10-03 11:52:46Z

1

I think you have one mistake... Try this

<input name="PriorityCheckBox" type="checkbox" value="1" <?php if ($row['Priority'] == 1) echo ' checked'; ?> />

answered Oct 3, 2012 at 11:52

Djomla

6262 gold badges8 silver badges18 bronze badges

Comments

Sibu · Accepted Answer · 2012-10-03 11:48:03Z

0

Try it this way

<input name="PriorityCheckBox" type="checkbox" value="1" <?php if ($checked == 1) echo "checked='checked'"; ?> />

answered Oct 3, 2012 at 11:48

Sibu

4,6272 gold badges30 silver badges38 bronze badges

Comments

Yogesh Suthar · Accepted Answer · 2012-10-03 11:48:10Z

0

change

<?php if ($checked == 1) echo ' checked'; ?>

to

<?php if ($checked == 1) echo ' checked="checked"'; ?>

and $checked = $Priorityresult['Priority']; to $checked = $row['Priority'];

answered Oct 3, 2012 at 11:48

Yogesh Suthar

30.5k18 gold badges75 silver badges100 bronze badges

Comments

Vishal Suthar · Accepted Answer · 2012-10-03 11:49:29Z

0

It should be checked="checked"

<?php if ($checked == 1) echo "checked='checked'"; ?>

answered Oct 3, 2012 at 11:49

Vishal Suthar

17.2k4 gold badges64 silver badges109 bronze badges

Collectives™ on Stack Overflow

Populate Checkbox from Database Query

6 Answers 6

2 Comments

Comments

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

6 Answers 6

2 Comments

Comments

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related