Laravel Eager Loading – Load only specific columns

by

Make use of the select() method:

public function car() {
    return $this->hasOne('Car', 'id')->select(['owner_id', 'emailid', 'name']);
}

Note: Remember to add the columns assigned to the foreign key matching both tables. For instance, in my example, I assumed a Owner has a Car, meaning that the columns assigned to the foreign key would be something like owners.id = cars.owner_id, so I had to add owner_id to the list of selected columns;

More Related Contents:

  1. Laravel requires the Mcrypt PHP extension
  2. Laravel view not found exception
  3. Laravel orderBy on a relationship
  4. Download files in laravel using Response::download
  5. How to create multilingual translated routes in Laravel
  6. How to use SHA1 encryption instead of BCrypt in Laravel 4?
  7. How to alias a table in Laravel Eloquent queries (or using Query Builder)?
  8. Access query string values from Laravel
  9. MVC (Laravel) where to add logic
  10. Laravel Mail::send() sending to multiple to or bcc addresses
  11. How do I redirect after download in Laravel?
  12. Could not open input file: artisan
  13. How Follow the Don’t Repeat Yourself Principle When Consuming My Own Laravel API?
  14. laravel TokenMismatchException in ajax request
  15. Laravel named route for resource controller
  16. Laravel Escaping All HTML in Blade Template
  17. Laravel: Validation unique on update
  18. file_put_contents(meta/services.json): failed to open stream: Permission denied
  19. PHP Composer update “cannot allocate memory” error (using Laravel 4)
  20. Laravel Eloquent – Attach vs Sync
  21. Update without touching timestamps (Laravel)
  22. Change name of Laravel’s created_at and updated_at
  23. How can I install mcrypt under PHP7? Laravel needs it
  24. How can I query raw via Eloquent?
  25. Using namespaces in Laravel 4
  26. Laravel catch Eloquent “Unique” field error
  27. Laravel extend Form class
  28. How Can I Remove “public/index.php” in the Laravel Url generated? [duplicate]
  29. Laravel quick start guide route not working
  30. Can’t make Laravel 4 to work on localhost

Leave a Comment