getting the value of an extra pivot table column laravel

by

When using Many to Many relationships with Eloquent, the resulting model automatically gets a pivot attribute assigned. Through that attribute you’re able to access pivot table columns.
Although by default there are only the keys in the pivot object. To get your columns in there too, you need to specify them when defining the relationship:

return $this->belongsToMany('Role')->withPivot('foo', 'bar');

Official Docs

If you need more help the task of configuring the relationships with Eloquent, let me know.

Edit

To query the price do this

$model->problems()->where('phone_problem', $problem->id)->first()->pivot->price

More Related Contents:

  1. How do I store a custom user selected CSS template style (like wordpress visual editor)? [closed]
  2. Laravel – only a zero is saved to the database
  3. Laravel one to many relation with a one to one relation
  4. How to use multiple databases in Laravel
  5. Laravel 5 PDOException Could Not Find Driver
  6. Laravel migration: unique key is too long, even if specified
  7. Laravel: PDOException: could not find driver
  8. Laravel Eloquent select all rows with max created_at
  9. Laravel: connect to databases dynamically
  10. How to join three table by laravel eloquent model
  11. Laravel OrderBy relationship count
  12. Laravel 5.2 – Use a String as a Custom Primary Key for Eloquent Table becomes 0
  13. How to bind parameters to a raw DB query in Laravel that’s used on a model?
  14. SQLSTATE[HY000] [2002] A connection attempt failed.. – When attempting to connect from Local to remote server
  15. Laravel 5.4 field doesn’t have a default value
  16. Laravel Migration table already exists, but I want to add new not the older
  17. Laravel $q->where() between dates
  18. belongsToMany relationship in Laravel across multiple databases
  19. How Can I Set the Default Value of a Timestamp Column to the Current Timestamp with Laravel Migrations?
  20. Laravel nested relationships
  21. Laravel Cannot delete or update a parent row: a foreign key constraint fails
  22. Base table or view not found: 1146 Table Laravel 5
  23. How to get MySql 8 to run with laravel? [duplicate]
  24. Create a Insert… Select statement in Laravel
  25. PHP Laravel: No connection could be made because the target machine actively refused it
  26. Query on a many-to-many relationship using Doctrine with Symfony2
  27. How to create a database-driven multi-level navigation menu using Laravel
  28. Eloquent groupBy make “SQLSTATE[42000]” with valid SQL query in Laravel 5.3
  29. Check if laravel model got saved or query got executed
  30. find in set in laravel ? example

Leave a Comment