Laravel how to tie two tables

Laravel: link two tables with an example showing how to use Eloquent relationships.

Tie two tables in Laravel

Tying two tables in Laravel is a common task. It involves establishing a relationship between them, which allows you to query and retrieve data from both tables. This is done with the help of Eloquent ORM, the object-relational mapping layer of Laravel.

Laravel provides various ways to set up relationships between tables. The most commonly used ones are belongsTo, hasOne, hasMany, belongsToMany and morphToMany. Let's take a look at an example of using hasMany.

Let's say we have two tables: users and posts. The users table stores information about the app's users, such as their name, email address and so on. The posts table stores information about the posts that users create, such as the title and content of the post. We want to be able to retrieve all the posts that a user has created. In order to do this, we need to set up a relationship between the users and posts tables.

//in the User model
public function posts(){
    return $this->hasMany('AppPost');
}

//in the Post model
public function user(){
    return $this->belongsTo('AppUser');
}

Now that we have set up the relationship in our models, we can use Eloquent to query the database. For example, to get all the posts created by a user with an id of 1, we can do the following:

$user = AppUser::find(1);
$posts = $user->posts;

This will return all the posts created by the user with an id of 1. Similarly, we can query the other way around. To get the user that created a post with an id of 1, we can do the following:

$post = AppPost::find(1);
$user = $post->user;

This will return the user that created the post with an id of 1. As you can see, tying two tables in Laravel is quite easy and straightforward. By setting up relationships between your models, you can easily query and retrieve related data from multiple tables.