store foreign key as zero instead of it's value

I have a table that all the values are foreign keys ,when I store these values it save it as zero not the value that I chose ,

public function create()
{
$type=type::query()->pluck('type');
$color=color::query()->pluck('colore');
$region=region::query()->pluck('country');
$size=size::query()->pluck('size');
$brand=brand::query()->pluck('company');
//$price=new_product::query()->pluck('price');
return view('sale',compact('type','color','region','size','brand'));
}

public function store(Request $request)
{

new_product::create($request->all());
return redirect()->route('sale.index');
}


the model:

class new_product extends Model
{
protected $table = 'enter_new_product';
protected $fillable = ['type_id', 'color_id', 'region_id', 'size_id', 'brand_id','price'];

public function type()
{
return $this->hasMany(type::class);
}

public function size()
{
return $this->hasMany(size::class);
}

public function color()
{
return $this->hasMany(color::class);
}

public function region()
{
return $this->hasMany(region::class);
}

public function brand()
{
return $this->hasMany(brand::class);
}
}


the sale view

{!! Form::open(['route' => 'sale.store', 'method' => 'post','files'=>true]) !!}

<div class="form-group">
{!! Form::label('type_id', 'اسم الصنف') !!}
{!!Form::select('type_id',$type ,null, ['class'=>'form-control','placeholder'=>'ادخل اسم الصنف '])!!}
</div>

<div class="form-group">
{!! Form::label('color_id', 'اللون') !!}
{!!Form::select('color_id', $color,null,['class'=>'form-control','placeholder'=>'ادخل اللون '])!!}
</div>
{!! Form::submit('اضافة',array('class'=>'btn btn-primary btn-lg'))!!}
{!!Form::close()!!}


it's a part of the view not all but the region,size and brand are the same as the color and type>

dd($request->all());

dd((new new_product($request->all()))->getAttributes());

0

1 Answer
1

It would be nice to know how your request is looking (dd($request->all()) as a comment mentioned before, however I see one problem already, which probably would not help your main problem: The product has the foreign key so it does not have many of the regions and brands and the other stuff. The product hasOne of these relations.

dd($request->all()

hasOne

$request->all()

$product = new Product::create(['type_id' = $request['type_id'], ...]); $product->save();

save()

Product

NewProduct

sale

NewProduct

my_queen

enter_new_product

enter_new_product_ibfk_1

type_id

type

id

enter_new_product

type_id

color_id

region_id

brand_id

price

updated_at

created_at

0

NULL

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.