I need to update all column in my fields for now i have the Join statement and im fetching the data but i cannot update all the columns
here is my join table name movies
and i need to update all aircraft_id
depending on what value i input
here is my Controller
$getairId = DB::table('aircrafts')
->join('movies','movies.aircraft_id','=','aircrafts.aircraft_id')
->select('movies.*')
->update('aircraft_id.*')
->where('aircrafts.aircraft_id','=', $airid)
->get();
nothing is being updated.
EXPECTED RESULT
So assume that this is my page
and when i submit i should get this Actual Result / Output
I assume that suppose you want to replace the aircraft id $airid = 1 with 3
$getairId = DB::table('aircrafts')
->join('movies','movies.aircraft_id','=','aircrafts.aircraft_id')
->where('aircrafts.aircraft_id','=', $airid)
->update(array("aircrafts.aircraft_id"=>3));
In the last update statement, you can pass your variable name which you want to update and come from your frontend form.
Hope,This code will work for you