Checkbox not checked based on database PHP

Question

I am trying to display a checked checkbox if the store has been assigned a value in the database, i have the following but am not sure why it is not working, it is currently not checking any checkboxes even though they have values assigned.

$stores = array();
    $stmt = DB::query(Database::SELECT, 'SELECT `id`, `store`, `store_name`, `branch_name` FROM `mystores` WHERE `site` = :site ORDER BY `store_name` ASC, `branch_name` ASC');
    $stmt->param(':site', $this->permissions['site'][0]);
    try {
        $result = $stmt->execute()->as_array();
        if (count($result) >= 1) {
            foreach ($result as $row) {
                $checked = in_array($row['store'], $assigns) ? 'checked="checked"' : '';
                $stores[] = '<label><input type="checkbox" name="stores['.$row['store'].']" value="'.$row['store'].'"'.$checked.' />'.$row['store'].' - '.$row['store_name'].' - '.$row['branch_name'].'</label>';
            }
        }
    } catch (Exception $e) {
        FB::error($e);
    }

Did you check the contents of $row['store'] and $assigns? — TimWolla
– TimWolla, Commented Mar 18, 2014 at 17:02

Farnabaz · Accepted Answer · 2014-03-18 17:04:38Z

1

I think you miss a space here .'"'.$checked.' and it should be .'" '.$checked.'

answered Mar 18, 2014 at 17:04

Farnabaz

4,0662 gold badges25 silver badges42 bronze badges

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

1 Comment

Farnabaz Over a year ago

other things is fine (ideone.com/N6WFM3), check $assigns array and query

Community · Accepted Answer · 2017-05-23 11:49:21Z

0

I banged my head against that in_array conditional (writing it at least three different ways) and various table-joined mysqli_querys for two days before I gave up on either approach working. No matter what I did I could not get the code to check checkboxes automatically according to values in the array.

In the end I devised my own solution with jQuery and it works like a charm.

Check it out here if you are interested: https://stackoverflow.com/a/26433841/1896348

edited May 23, 2017 at 11:49

CommunityBot

11 silver badge

answered Oct 17, 2014 at 22:00

code-sushi

7193 gold badges7 silver badges23 bronze badges

Collectives™ on Stack Overflow

Checkbox not checked based on database PHP

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related