Odtnhj

I can't find the way to populate checkboxes with data from database. I've got roles table(id and role name), users table(id, name, surname, etc.) and a pivot table(user_id, role_id). How do I populate them that it shows if user is admin/user or both?

Thank you.

controller

 $total_row = $data->count();
 $output = "";
 if ($total_row > 0) 
 foreach ($data as $row) 
 $roleNames = '';
 foreach (Role::all() as $roles1) 
 $roleNames .= $roles1->role != null ? $roles1->role.' '.'<input type="checkbox" class="checkbox" id="checkboxId">'.' ' : '';
 // if ($roles1 = id(1)) 
 // return '<input type="checkbox" class="checkbox" id="checkboxId" checked>';
 // 
 

 $output .= '
 <tr>
 <td>'.$row->surname.'</td>
 <td>'.$row->name.'</td>
 <td>'.$row->phone.'</td>
 <td>'.$roleNames.'</td>
 <td><button type="button" id="rowId" class="remove-button btn btn-danger" data-id="'.$row->id.'">
 <div class="close">x</div>
 </button></td>
 </tr>
 ';
 
 else 
 $output = '
 <tr>
 <td align="center" colspan="5">Nema podataka</td>
 </tr>
 ';
 
 return array(
 'table_data' => $output,
 'total_data' => $total_row,
 );

Better to use View.

In your case you can try something like this:

$roles = Role::all();

foreach ($data as $row) 
 $roleNames = '';

 $rowRoles = $row->roles->pluck('id');

 foreach($roles as $role)
 $roleNames .= '<input type="checkbox" name="roles" value="' . $role->id . '" ' . (in_array($role->id, $rowRoles) ? 'checked' : '') . '/> ' . $role->name;
 

You need to have belongsToMany relation "roles" in your User model.

public function roles()

 return $this->belongsToMany('AppRole', 'pivot_table_name');