I am currently working on storing data from a form to a pivot table called asset_user.
User Model:
public function assets()
{
return $this->belongsToMany(Asset::class)->withPivot(['amount']);
}
Asset Model:
public function users()
{
return $this->belongsToMany(User::class)->withPivot(['amount']);
}
Migration for asset_user:
public function up()
{
Schema::create('asset_user', function (Blueprint $table) {
$table->foreignId('asset_id')->unsigned()->index();
$table->foreignId('user_id')->unsigned()->index();
$table->foreign('user_id')->references('id')->on('users')->onDelete('cascade');
$table->foreign('asset_id')->references('id')->on('assets');
$table->primary(['user_id', 'asset_id']);
$table->decimal('amount');
$table->timestamps();
});
}
My POST form structure:
<div id="form" class="form">
<form action="{{ route('home.store') }}" method="POST" novalidate>
@csrf
<label for="asset_id">Add Asset</label>
<select class="form-control" id="asset_id" name="asset_id">
@foreach($assets as $asset)
<option value="{{$asset->id}}">{{$asset->symbol}} {{$asset->name}}</option>
@endforeach
</select>
</div>
@error('asset_id')
<div style="color:red;">{{ $message }}</div>
@enderror
</div>
<div class="form-group mb-4">
<label for="amount">Amount</label>
<input type="number" class="form-control" id="amount" name="amount" value=''></input>
@error('amount')
<div style="color:red;">{{ $message }}</div>
@enderror
</div>
<input type="hidden" name="user_id" value="{{ Auth::user()->id }}">
<button type="submit" class="btn btn-dark">Save</button>
</form>
</div>
Controller Logic:
public function store(Request $request){
$validAsset= $this->validate($request,[
'amount' => 'required|numeric',
'asset_id' => 'required',
'user_id' => 'required'
]);
$user = User::findOrFail(1);
$user->assets()->attach($validAsset, [
'amount'=> $validAsset['amount'],
'asset_id'=> $validAsset['asset_id'],
'user_id' => $validAsset['user_id']
]);
The error message I encountered:
SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '5-3' for key 'PRIMARY
insert into `asset_user` (`amount`, `asset_id`, `user_id`) values (7, 3, 5), (7, 3, 5), (7, 3, 5)
I am puzzled by why it is trying to store all three values in all three columns. Any insights would be appreciated!