Level 65
$book <-> $books?
Oct 15, 2014
38
Level 51
Undefined Property/Non-object on Relationship of 2 tables
Hi All,
I have a authors & books table With two models like so:
class Authors extends \Eloquent {
protected $guarded = ['id'];
public $table = 'authors';
public $timestamps = false;
public function book()
{
return $this->hasMany('Books', "author", "last_name");
}
}
class Books extends \Eloquent {
protected $guarded = ['id'];
public $timestamps = false;
public function author()
{
return $this->hasOne('Authors');
}
}
My controller then looks like:
public function authorBooks($name)
{
$books = Authors::where('last_name', '=', $name)->get();
$num = 1;
$pages = Pages::where('status', '=' , $num)->get();
$categories = Categories::where('parent_id','=', 0)->get();
return View::make('site.authorbooks', compact('pages', 'categories', 'books'));
}
Route
Route::get('/authors/{name}','FrontController@authorBooks');
Then inside my view i call
{{ $book->book->first()->title }}
Shows
Trying to get property of non-object (View: /home/vagrant/code/bookstore/app/views/site/authorbooks.blade.php)
Can anyone help as to where I'm going wrong here?
Level 51
@bashy I don't follow
Level 65
In your views, you say you use "book->" {{ $book->book->first()->title }} yet you push through "books" compact('pages', 'categories', 'books')
Level 51
Yeah changed that now to $items to differencite the two, but stil get the same error
Level 51
Getting Undefined property: Illuminate\Database\Eloquent\Collection::$books now
Level 65
See what you get with
return $books;
In controller before return View::make()
Level 51
Returns:
[{"id":6,"last_name":"Bates","first_name":"H. E."}] which is correct for this particular record
Level 51
Would it be because the B in bates doesn't match exactly, for example in the url is all lowercase and then in the authors table it has a capital B
Level 10
your books variable returns a collection of authors, are you looping through it in the view? you are trying to access the "book" hasMany relation from a collection
Level 51
Looping though like so:
@foreach($books as $book)
<h4>{{ $book->books->first()->title }}</h4>
@endforeach
Level 10
your hasMany relation is called book not books
Level 51
its now called books, still not working either.
Level 10
Try dd($book->books) inside the loop to see if the relation is working
Level 51
dd($book->books) returns
object(Illuminate\Database\Eloquent\Collection)[359]
protected 'items' =>
array (size=0)
empty
Level 65
Is there a relation set? Like, in the actual database
Level 10
if your collection is empty, and the first() method return null then trying to access title from null will throw
Level 51
The database(s) are as follows:
Authors Table -- id -- first_name -- last_name
Books Table -- id -- author // This should match the last_name in authors table -- book -- category
Level 51
@arabsight everything in both tables as data in them
Level 51
??
Level 10
dd($book->books) returns: protected 'items' => array (size=0) empty there's no related books. try eager loading:
$books = Authors::with('books')->where('last_name', '=', $name)->get();
return $books;
the returned collection should have a books property with each author
Level 51
that returns
"[{"id":6,"last_name":"Bates","first_name":"H. E.","books":[]}]"
Level 51
As you can see from this - http://cl.ly/image/3e2447113L03 there's two books related to that author. Author named "bates"
Level 65
Are you relating your tables via a string for the author?
Level 51
Passing it like so: <a href="/authors/{{ strtolower($author->last_name) }}">
Which in turn shows as : books.app/authors/bates which then points to the route
Level 65
Yes but in the table? Do you relate the name or the ID from the authors table?
Level 51
the name has the id's dont match up.
Level 10
your fields doesn't match. author: "bates (h.e)" != last_name:"Bates"
Level 51
i have edited the db to show bates but still no working
Level 65
Shouldn't use a dynamic string to relate your relationships, why not use the id field or author_id into Authors table?
Level 51
becasuse the id in the authors table doesn't match the books table
Please or to participate in this conversation.