Databases
StackOverflow2013
Postsdbo
POLaravel 4 Eloquent: multiple relationship methods referencing the same model?
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POLaravel 4 Eloquent: multiple relationship methods referencing the same model?
    primarykey
    data
    text
    <p>I have DB tables as follows:</p> <pre><code>images: id name url etc places: id image_id name url etc image_place: image_id place_id </code></pre> <p>Places and images have a many-to-many relationship, but each place is also assigned a single image, which is used as the thumbnail in lists. So a place may "belong to" an image in a one-to-many relationship. Therefore I tried this in Laravel 4:</p> <p>models/Place.php:</p> <pre><code>public function image() { return $this-&gt;belongsTo('Image'); } public function images() { return $this-&gt;belongsToMany('Image'); } </code></pre> <p>But when I try to access $place->image, I get an error: "call to unknown method getResults()." </p> <p>I've done some experimenting and found these workarounds:</p> <ol> <li><p>If I remove the images() method, $place->image works as expected. I don't use images() currently, so this is my solution for now, but certainly I would like to have both available.</p></li> <li><p>If I replace the image() function with: return Image::where('id', $this->image_id)->first(); then I can access the object via $place->image(). But I can't do eager loading, which is important since I use the thumbnails in long lists of results. Plus I don't like having to use the method() syntax for just this one property.</p></li> </ol> <p>I also tried renaming the methods, e.g. image() and photos(), but it made no difference.</p> <p>Is accessing the same model with different types of relationships not possible in Laravel, or am I missing something?</p>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. This table or related slice is empty.
    1. USHolly
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POLaravel 4 Eloquent: multiple relationship methods referencing the same model?
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POLaravel 4 Eloquent: multiple relationship methods referencing the same model?
      1. This table or related slice is empty.
      1. VTUpMod
    1. COYour `images()` should be `hasMany`, you have it as `belongsToMany`.
      singulars
      1. POLaravel 4 Eloquent: multiple relationship methods referencing the same model?
      1. USSajan Parikh
    2. COI think a Place "has one" Image here, not the opposite.
      singulars
      1. POLaravel 4 Eloquent: multiple relationship methods referencing the same model?
      1. USmatpop
    3. COSajan: See my comment to your answer. @matpop, I don't think so, because: 1. "hasOne" is only used in one-to-one relationships in the docs. 2. image() is currently working as expected with belongsTo. 3. It's parallel to the example in the docs under One to Many (http://four.laravel.com/docs/eloquent#relationships): just as a post has many comments, an image may have many (= be the thumbnail for many) places. In the example, the comments table has a post_id column and belongsTo a Post, and my places table has an image_id column and belongsTo an Image.
      singulars
      1. POLaravel 4 Eloquent: multiple relationship methods referencing the same model?
      1. USHolly
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload