I have 2 tables and I need to join those tables.
I need to
gal.id = galleries.id
user_id = auth::id()
Galleries: id, name
Share: gal_id, user_id
To achieve this, you have Relationship in Eloquent ORM. The official website states :
Of course, your database tables are probably related to one another. For example, a blog post may have many comments, or an order could be related to the user who placed it. Eloquent makes managing and working with these relationships easy. Laravel supports many types of relationships:
You can read all about eloquent relationship over here
If you do not want to use relationship, following is an example on how to join two tables :
DB::table('users')->select('users.id','users.name','profiles.photo')->join('profiles','profiles.id','=','users.id')->where(['something' => 'something', 'otherThing' => 'otherThing'])->get();
The above query will join two tables namely
profiles on the basis of user.id = profile.id with two different conditions, you may or may not use
where clause, that totally depends on what you are trying to achieve.