Fetching category name using foreign key (category_id) in blade

class Product extends Model
{
    public function category()
    {
        return $this->belongsTo(Category::class);
    }
}

$product->category->name;

@phildawsome

Thanks for your reply. Now i am getting this error

FatalErrorException in Model.php line 827: Class 'category' not found

@adeel Import the Category class. Make sure your Category is a model too that links to the category_ids and stuff.

You may also want to retrieve products while eager loading the categories:

$products = Product::all()->load('category');

or

$products = Product::with('category')->get();

@adeel No need to import if in the same namespace but I was assuming you have a file called Category.php in the app folder with at least

<?php

namespace App;

use Illuminate\Database\Eloquent\Model;

class Category extends Model
{
    //
}

oh .. i was using this in model.

public function category() { return $this->belongsTo('category'); }

Your first solution worked. Thank You sooo much @phildawson :)

@adeel :) Ah yeah you need the ::class to resolve back to the string 'App\Category'

The tip from @Francismori7 is worth following to save on db query for each loop. I'd go with the latter 'with' unless there is a condition.

@adeel Make sure to use eager loading too, as I mentioned.

@Francismori7

Oh i didn't know about eager loading before, It also worked. Thank You @Francismori7 :)

@adeel Here is almost exactly what you are doing only with book and author

http://laravel.com/docs/5.1/eloquent-relationships#eager-loading

Thanks Guys :)