Laravel - 使用Join Statement更新表中的所有列

Question

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

Answer 1

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