i have a problem to show my products that have a specific category, this is my tables migration and models: Products migration:
Schema::create('products', function (Blueprint $table) {
$table->increments('id');
$table->string('name', 255);
$table->string('slug');
$table->text('description');
$table->string('extract', 300);
$table->decimal('price', 5, 2);
$table->string('image', 300);
$table->boolean('visible');
$table->integer('user_id')->unsigned();
$table->foreign('user_id')
->references('id')->on('users')
->onDelete('cascade');
$table->integer('category_id')->unsigned();
// relations
$table->foreign('category_id')
->references('id')
->on('categories')
->onDelete('cascade');
$table->timestamps();
model product
<?php
namespace dixard;
use Illuminate\Database\Eloquent\Model;
use dixard\User;
use dixard\Category;
use dixard\OrderItem;
use dixard\Color;
class Product extends Model
{
protected $table = 'products';
protected $fillable =
[
'name',
'slug',
'description',
'extract',
'image',
'visible',
'price',
'category_id',
'user_id'
];
public function user() {
return $this->belongsTo('dixard\User');
}
public function category() {
return $this->belongsTo('dixard\Category');
}
public function OrderItem() {
return $this->belongsTo('dixard\OrderItem');
}
public function Color() {
return $this->belongsTo('dixard\Color');
}
}
Category migrations
Schema::create('categories', function (Blueprint $table) {
$table->increments('id');
$table->string('name', 255)->unique();
$table->string('slug');
$table->text('description');
$table->string('color', 30);
//$table->timestamps();
});
Model category
use dixard\Product;
class Category extends Model
{
protected $table = 'categories';
protected $fillable = [
'name',
'slug',
'description',
'color',
];
public $timestamps = false;
public function products() {
return $this->hasMany('dixard\Product');
}
}
I'm trying to show all products that have category_id = 1, this category id=1 is my t-shirt category. My controller:
use dixard\Product;
use dixard\Category;
class TshirtController extends Controller
{
public function men_tshirt()
{
$category = Category::where('name', '=', 't-shirt')->orderBy('id', 'desc')->first();
$product_men = Product::where('category_id','=', $category->id)->orderBy('id', 'desc');
dd($product_man) OR
return view('store.shop.men',compact('product_men'));
// It doesnt work, doesnt show me nothing.
}
via Chebli Mohamed
Aucun commentaire:
Enregistrer un commentaire