Laravel Many to many self referencing table only works one way

by

Instead of creating two records use a new function.

public function friends()
{
  return $this->belongsToMany('User', 'friend_user', 'user_id', 'friend_id');
}

// Same table, self referencing, but change the key order
public function theFriends()
{
  return $this->belongsToMany('User', 'friend_user', 'friend_id', 'user_id');
}

//You can then call opposite record(s) using:
foreach( Auth::user()->theFriends as $theFriends )

I used this approach in my project so I can have better separation for organizing the results.

More Related Contents:

  1. Get Specific Columns Using “With()” Function in Laravel Eloquent
  2. Laravel Check If Related Model Exists
  3. Add a custom attribute to a Laravel / Eloquent model on load?
  4. How to alias a table in Laravel Eloquent queries (or using Query Builder)?
  5. Get the Query Executed in Laravel 3/4
  6. Laravel Eloquent: How to order results of related models?
  7. Laravel 4: how to “order by” using Eloquent ORM [duplicate]
  8. How to set a default attribute value for a Laravel / Eloquent model?
  9. How to Make Laravel Eloquent “IN” Query?
  10. Laravel Eloquent – Attach vs Sync
  11. How to create a subquery using Laravel Eloquent?
  12. Update without touching timestamps (Laravel)
  13. Eloquent model mass update
  14. Laravel Eloquent sort by relation table column
  15. How can I query raw via Eloquent?
  16. Find or Create with Eloquent
  17. Automatically deleting related rows in Laravel (Eloquent ORM)
  18. How to create multilingual translated routes in Laravel
  19. How can I convert many statement mysql to laravel eloquent?
  20. How to use SHA1 encryption instead of BCrypt in Laravel 4?
  21. Eloquent ORM Code Hinting in PhpStorm
  22. Laravel Mail::send() sending to multiple to or bcc addresses
  23. How do I redirect after download in Laravel?
  24. Could not open input file: artisan
  25. Laravel Escaping All HTML in Blade Template
  26. Change name of Laravel’s created_at and updated_at
  27. Eloquent many-to-many-to-many – how to load distant relation easily
  28. A __construct on an Eloquent Laravel Model
  29. How Can I Remove “public/index.php” in the Laravel Url generated? [duplicate]
  30. Laravel quick start guide route not working

Leave a Comment