How to join and get data from two tables in laravel?

@adan 

In Laravel, you can join two tables and retrieve data using the Eloquent ORM. Here is an example of how to joining two tables and retrieving data:

1. Define the relationship between the two tables in your models. For example, if you have a users table and a posts table, you can define a relationship in the User model:

1
2
3
4
5
6
7

class User extends Model
{
    public function posts()
    {
        return $this->hasMany(Post::class);
    }
}

1. Use the ->join() method in your query to join the two tables. For example, to join the users table with the posts table:

1
2
3

$users = User::select('users.*', 'posts.title as post_title')
    ->join('posts', 'users.id', '=', 'posts.user_id')
    ->get();

1. Retrieve data from the joined tables in your code. For example, you can loop through the users and access their posts:

1
2
3
4

foreach ($users as $user) {
    echo 'User Name: ' . $user->name . '<br />';
    echo 'Post Title: ' . $user->post_title . '<br />';
}

By following these steps, you can join two tables and retrieve data in Laravel.