{"flag":true,"single":true,"pageTitle":"Relationships in laravel","post":{"id":14,"user_id":"1","slug":"relationships-in-laravel-slvk","title":"Relationships in laravel","body":"

Get data from multiple tables <\/p>\r\n

we have two tables profiles<\/strong><\/p>\r\n\r\n\r\n\r\n
id<\/span><\/th>\r\nuser_id<\/span><\/th>\r\nphone<\/span><\/th>\r\naddress<\/span><\/th>\r\ncreated_at<\/span><\/th>\r\nupdated_at<\/span><\/th>\r\n<\/tr>\r\n<\/thead>\r\n<\/table>\r\n

And users<\/strong><\/p>\r\n

\r\n
 <\/div>\r\n
 <\/div>\r\n
 <\/div>\r\n
 <\/div>\r\n
 <\/div>\r\n
 <\/div>\r\n
 <\/div>\r\n
 <\/div>\r\n<\/div>\r\n\r\n\r\n\r\n
 <\/th>\r\nid<\/a><\/span><\/th>\r\nname<\/a><\/span><\/th>\r\nemail<\/a><\/span><\/th>\r\nemail_verified_at<\/a><\/span><\/th>\r\npassword<\/a><\/span><\/th>\r\nremember_token<\/a><\/span><\/th>\r\ncreated_at<\/a><\/span><\/th>\r\nupdated_at<\/a><\/span><\/th>\r\n<\/tr>\r\n<\/thead>\r\n<\/table>\r\n

Add a new function in model app\\Models\\User.php<\/strong><\/p>\r\n

SYNTAX: <\/strong><\/p>\r\n

return $this->hasOne(Phone::class, 'foreign_key', 'local_key');\r\n\/\/FOREIGN KEY MEANS key of Phone model,<\/code><\/pre>\r\n
public function profile(){\r\n\treturn $this->hasOne(profile::class); \/\/each user has only one profile OR\r\n       \/\/ return $this->hasOne(profile::class, 'user_id'); \/\/forigen key specify\r\n      \/\/return $this->hasOne(profile::class, 'user_id', 'phone'); \/\/multiple foregin keys\r\n}<\/code><\/pre>\r\n
In HomeController.php <\/strong>add below code and add use App\\Models\\User;<\/strong><\/p>\r\n
public function getRelationship(){\r\n\t$data = User::with('profile')->get(); \/\/profile function in user model\r\n\treturn $data;\r\n}<\/code><\/pre>\r\n
profile is method in User Model<\/p>\r\n
Web.php<\/strong><\/p>\r\n
Route::get('getRelationship', [App\\Http\\Controllers\\HomeController::class, 'getRelationship'])->name('getRelationship');<\/code><\/pre>\r\n
Visit URL http:\/\/127.0.0.1:8000\/getRelationship<\/strong> you will get<\/p>\r\n
[\r\n  {\r\n    \"id\": 1,\r\n    \"name\": \"Rizwan\",\r\n    \"email\": \"rizwan@gmail.com\",\r\n    \"email_verified_at\": \"2022-01-15T21:42:35.000000Z\",\r\n    \"created_at\": \"2022-01-15T21:10:18.000000Z\",\r\n    \"updated_at\": \"2022-01-15T21:45:23.000000Z\",\r\n    \"profile\": {\r\n      \"id\": 1,\r\n      \"user_id\": 1,\r\n      \"phone\": \"923461234567\",\r\n      \"address\": \"kmw\",\r\n      \"created_at\": null,\r\n      \"updated_at\": null\r\n    }\r\n  },\r\n  {\r\n    \"id\": 2,\r\n    \"name\": \"muhammad yaser\",\r\n    \"email\": \"filereal@live.com\",\r\n    \"email_verified_at\": \"2022-01-15T23:29:27.000000Z\",\r\n    \"created_at\": \"2022-01-15T23:29:09.000000Z\",\r\n    \"updated_at\": \"2022-01-15T23:29:27.000000Z\",\r\n    \"profile\": null\r\n  }\r\n]<\/code><\/pre>\r\n
INVERSE RELATION:<\/strong><\/p>\r\n
INVERSE RELATIONSHIP >> IN Profile<\/strong> MODEL USE <\/p>\r\n
public function user()\r\n    {\r\n        return $this->belongsTo(User::class);\r\n    }<\/code><\/pre>\r\n
Then you can get profile with user details<\/p>\r\n
$data = Profile::with('user')->get(); \/\/profile function in user model<\/code><\/pre>\r\n
user is method in profile model, <\/p>\r\n
___________________________<\/p>\r\n
You can also get records by profiles<\/strong> relationship<\/p>\r\n
profile.php model<\/strong><\/p>\r\n
public function user(){\r\n\t\treturn $this->belongsTo(user::class); \/\/each user has only one profile\r\n\t}<\/code><\/pre>\r\n
Controller.php <\/strong>with use App\\Models\\Profile;<\/strong><\/p>\r\n
public function getRelationship(){\r\n\t\t$data = Profile::with('user')->get(); \/\/profile function in user model\r\n\t\treturn $data;\r\n\t}<\/code><\/pre>\r\n
Similarly You can make one to many<\/strong> relationships<\/p>\r\n
For details visit Eloquent: Relationships - Laravel - The PHP Framework For Web Artisans<\/a><\/p>\r\n
______________________________________<\/p>\r\n
A user has many phones, Get all phone numbers of a user that have id 1<\/strong><\/p>\r\n
public function phone()\r\n    {\r\n        return $this->hasMany(PhoneNumber::class);\r\n    }<\/code><\/pre>\r\n
and then call in User controller<\/strong><\/p>\r\n
$user = \\App\\Models\\User::find(1)->phone->toArray();<\/code><\/pre>\r\n
For pagination <\/p>\r\n
ONE TO MANY<\/strong><\/p>\r\n
class Post extends Model\r\n{\r\n    public function comments()\r\n    {\r\n        return $this->hasMany(Comment::class);\r\n    }\r\n}<\/code><\/pre>\r\n
then call it<\/p>\r\n
$comments = Post::find(1)->comments;<\/code><\/pre>\r\n
ONE TO MANY INVERSE<\/strong><\/p>\r\n
class Comment extends Model\r\n{\r\n    public function post()\r\n    {\r\n        return $this->belongsTo(Post::class);\r\n    }\r\n}<\/code><\/pre>\r\n
Then in controller<\/p>\r\n
$comment = Comment::find(1);\r\nreturn $comment->post->title;<\/code><\/pre>\r\n
 <\/p>\r\n
 <\/p>\r\n
Relationships:<\/strong><\/p>\r\n
ONE TO ONE:<\/strong><\/p>\r\n
$this->hasOne(Phone::class,); \/\/a user have one phone<\/code><\/pre>\r\n
One To Many<\/strong><\/p>\r\n
$this->hasMany(Comment::class); \/\/ A post contain many comments<\/code><\/pre>\r\n
Will get one post and its all comments but comments will pagination of 5 per page<\/p>\r\n
$post_details= \\App\\Models\\Post::with(['Comment' => function ($query) {\r\n                $query->paginate(5);\r\n            }])\r\n            ->take(1)\r\n            ->first();<\/code><\/pre>\r\n
Has One Of Many<\/strong><\/p>\r\n
$this->hasOne(Order::class)->latestOfMany(); \/\/latest order\r\n$this->hasOne(Order::class)->oldestOfMany(); \/\/old order\r\n$this->hasOne(Order::class)->ofMany('price', 'max'); \/\/expensive order<\/code><\/pre>\r\n
Has one through: <\/strong>hasOneThrough<\/strong><\/p>\r\n
3 models , ie car, owner and mechanic <\/strong><\/p>\r\n
mechanics:<\/strong> id,name<\/p>\r\n
cars<\/strong>: <\/strong>id,model,mechanic_id<\/p>\r\n
owners: <\/strong>id, name, car_id<\/p>\r\n
class Mechanic extends Model\r\n{\r\n    public function carOwner()\r\n    { \/\/ Get the car's owner. using card in between mechanic and owner\r\n        return $this->hasOneThrough(Owner::class, Car::class);\r\n    }\r\n}<\/code><\/pre>\r\n
Has Many Through: <\/strong>hasManyThrough<\/strong><\/p>\r\n
projects: <\/strong>id, name<\/p>\r\n
environments: <\/strong>id, project_id, name<\/p>\r\n
deployments:<\/strong> id, environment_id, commit_hash<\/p>\r\n
class Project extends Model\r\n{\r\n     \/\/ Get all of the deployments for the project.\r\n    public function deployments()\r\n    {\r\n        return $this->hasManyThrough(Deployment::class, Environment::class);\r\n    }\r\n}<\/code><\/pre>\r\n
Many to Many: ?<\/strong><\/p>\r\n
 <\/p>","category_id":"2","is_private":"0","created_at":"2023-03-14T04:19:24.000000Z","updated_at":"2023-07-24T07:32:24.000000Z","category":{"id":2,"user_id":"1","name":"Laravel Core","slug":"laravel-nhyt","parent_id":"1","created_at":"2023-03-14T03:58:27.000000Z","updated_at":"2023-03-20T11:30:50.000000Z"},"user":{"id":1,"name":"R GONDAL","email":"rizikmw@gmail.com","email_verified_at":null,"two_factor_confirmed_at":null,"current_team_id":"1","profile_photo_path":null,"created_at":"2023-03-12T10:49:33.000000Z","updated_at":"2025-01-10T12:59:00.000000Z","profile_photo_url":"https:\/\/ui-avatars.com\/api\/?name=R+G&color=7F9CF5&background=EBF4FF"}},"pageDesc":"Get data from multiple tables  we have two tables profiles    id user_id phone address created_at updated_at    And users      - Relationships in laravel (Updated: July 24, 2023) - Read more about Relationships in laravel at my programming site [SITE]","categories":[]}