vendredi 13 mars 2020

connect two tables and get rows in laravel

I have tables:

roles:

id name

role_user:

role_id user_id company_id user_type

I want company_id shows all his role names.

roles->id is role_user->role_id.

my code:

        $role = DB::table('role_user')->select('role_id')->where('company_id', $cp)->get();
        foreach ($role as $key) {
            $role = $key;
        }

        $roles = Role::where('id', $role->role_id)->get();

This code shows only one role name but must show 3. if I dd($role) before foreach then it gives array of 3 role_id



via Chebli Mohamed

Aucun commentaire:

Enregistrer un commentaire