How to check a checkbox based on DB query result in Laravel?

Question

I have the following query that brings selected values from the DB (i.e. preferences that were entered by user through around 20 checkboxes):

$brng_selected = DB::table('Cprefs')
    ->where('user_id', $u_id)
    ->get();
return view('prefCat', ['b_sel' => $brng_selected]);

In the following example the user selected a preference with an id of 11 which refers to "sports" (in qatype field):

array(1) {
    [
        0
    ]=> object(stdClass)#368 (6) {
        [
            "id"
        ]=> int(47) [
            "created_at"
        ]=> string(19) "2019-09-27 12:29:59" [
            "updated_at"
        ]=> string(19) "2019-09-27 12:29:59" [
            "user_id"
        ]=> int(12) [
            "qatype"
        ]=> int(11) [
            "type"
        ]=> int(1)
    }
}

Now I need to configure the sports checkbox below to be checked based on the above. How can this be done?

<input type="checkbox" name="catpref[]" value=11 > Sports<br>

<input type="checkbox" name="catpref[]" value=1> Politics<br>

And you get selected value from DB and want it checked if ID exists,right — Yasin Patel
– Yasin Patel, Commented Sep 27, 2019 at 12:56

Yasin Patel · Accepted Answer · 2019-09-27 12:58:48Z

1

Get the column which you need to compare as below

$brng_selected = DB::table('Cprefs')
    ->select('qatype') // column name which you need
    ->where('user_id', $u_id)
    ->get()->toArray(); // it will return as array

return view('prefCat', ['b_sel' => $brng_selected]);

In your view change as below :

<input type="checkbox" name="catpref[]" value=11 {{ (in_array(11,$brng_selected)?"checked":'') }} > Sports<br>

answered Sep 27, 2019 at 12:58

Yasin Patel

5,7818 gold badges37 silver badges57 bronze badges

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

Comments

Salim Djerbouh · Accepted Answer · 2019-09-27 12:54:15Z

1

Something like this?

@if ($ba_sel->qa_type == 11)
    <input type="checkbox" name="catpref[]" value="11" checked>Sports<br>
@else
    <input type="checkbox" name="catpref[]" value="11">Sports<br>
@endif

edited Sep 27, 2019 at 12:54

Salim Djerbouh

11.1k6 gold badges35 silver badges65 bronze badges

answered Sep 27, 2019 at 12:41

Nico Mitov

193 bronze badges

4 Comments

Salim Djerbouh Over a year ago

Yes but checked instead of selected

Nico Mitov Over a year ago

Are your checkboxes generated dynamicaly?

Abdallah Sakre Over a year ago

Undefined variable: item. I changed it to $b_sel , but gave me error : Undefined index: qatype

Nico Mitov Over a year ago

$item was just for the example, in your case, it must be $b_sel[0]['qatype']. Now on to the question, if the checkboxes are static, I do not see another way of doing this.

Collectives™ on Stack Overflow

How to check a checkbox based on DB query result in Laravel?

2 Answers 2

Comments

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related