laravel hasmany and belongsTo relationship

Database

1.user_role_id
company
address

2.users
id
name
email

3.user_role
id
role


UserController

use App\Models\Userdetails;

$resultadmin = Userdetails::with(['users', 'userrole'])->get()->toArray();


Userdetails Model

    public function users(){
        return $this->hasOne('App\Models\users', 'id', 'user_id');
    }
public function userrole(){
        return $this->hasOne('App\Models\Userrole', 'id', 'user_role_id');
    }


Users Model

    public function userdetails(){
        return $this->belongsTo('App\Models\Userdetails', 'id', 'user_id');
    }


Userrole Model

public function userdetails(){
        return $this->belongsTo('App\Models\Userdetails', 'id', 'user_role_id');
    }

More details

get auth user details
use Illuminate\Support\Facades\Auth;
$auth_Id = Auth::id();

whereNotIn
$resultUserDetails = Userdetails::with(['users', 'userrole'])->whereNotIn('user_id', [$auth_Id])->get()->toArray();

all data get
$resultUserDetails = Userdetails::with(['users', 'userrole'])->get()->toArray();

only result array
$userDetails = Userdetails::with(['users'])->where(array('user_id' => $id))->first()->toArray();

Popular posts from this blog

Ajax Toggle(on/off) on-click Update

Yii Framework In Update Time View Image In Form