
How to check record exist or not in relationship table
How to check record exist or not in relationship table
Good day, guys. In this post, we’ll look at how to solve the "How to check record exist or not in relationship table" programming puzzle.
You can check if records exist or not in the relationship table. You have to use the has() method with the name of relationship method to get the record (parent table) if records exist in the related table and it will return null if there are no records in it (child table).-
Check if user has created posts or not in laravel using has method
$userHasPosts = User::has('posts')->find(Auth::user()->id); dd($userHasPosts); //app\Models\User.php //Model path may be different as per your laravel version public function posts(){ return $this->hasMany(Post::class); }
Output :
Return user details from table if user has created any post
App\Models\User {#1556 ▼ #fillable: array:13 [▶] #hidden: array:2 [▶] #casts: array:1 [▶] #connection: "mysql" #table: "users" #primaryKey: "id" #keyType: "int" +incrementing: true #with: [] #withCount: [] +preventsLazyLoading: false #perPage: 15 +exists: true +wasRecentlyCreated: false #attributes: array:23 [▶] #original: array:23 [▶] #changes: [] #classCastCache: [] #dates: [] #dateFormat: null #appends: [] #dispatchesEvents: [] #observables: [] #relations: [] #touches: [] +timestamps: true #visible: [] #guarded: array:1 [▶] #rememberTokenName: "remember_token" }
If user has not created any postnull
This code snippet will return the record from the users table if there are post records (from the related post table) that belong to this particular user exists in the posts table else it will return null. To achieve this you have to create a users table with column id (primary key) and posts table with user_id (foreign key) in the database. You have to also create a hasMany relationship with name posts in the user model.
If you like what you are reading, please consider buying us a coffee ( or 2 ) as a token of appreciation.
Don't forget to share this article! Help us spread the word by clicking the share button below.
We appreciate your support and are committed to providing you valuable and informative content.
We are thankful for your never ending support.
Random Code Snippet Queries: Laravel
- How to make Copy or Duplicate table row in laravel
- How to get user information using hootlex/laravel-friendships package in laravel
- Route [password.request] not defined
- How to return a column with different name in Laravel
- How to create projects method with belongstomany relationship in user model
- Pass value from controller to model in laravel
- Laravel change date format
- Call to a member function update() on null
- Add a subselect based on relationship using withAggregate method
- Target class [admin] does not exist.
- Insert data with form validation using ajax in laravel
- Get last year created records in Laravel
- Get current URL on visit URL in Laravel
- Get last record from table in laravel
- Get id of last inserted record in laravel
- How to generate .env file for laravel?
- Laravel API response format
- Composer\Exception\NoSslException
- Insert dummy data in users table Laravel
- Add class to body in laravel view
- How to insert value to additional columns in pivot table in laravel
- Remove array keys and values if it does not exist in other array in Laravel
- Display first n record from collection in laravel view
- Link storage folder in laravel 8
- The Pusher library requires the PHP cURL module. Please ensure it is installed