如何在3个相关表之间创建条件

Question

Beginer with sql, I'm working on laravel and want to change the values of a table that the user who is connected is linked
I have 3 tables:
User(id) foreign key in Exams(user_id)
and
Exams(id) foreign key in Verification(exam_id)
How to change the verifications of only the user connected ? he doing it by himself so I think we wil need

 Auth::user()
    DB::table('verifications')->where([
    ['confirmation', 'non'],
    ['modifier', 'oui'],
    ])->update(['confirmation' => "oui"]);

Answer 1

If you aren't using laravel relationships then use Joins.

DB::table('verifications')
    ->leftJoin('exams', 'verification.exam_id', '=', 'exams.id')
    ->leftJoin('users', 'exams.user_id', '=', 'user.id')
    ->where([
        ['verifications.confirmation', 'non'],
        ['verifications.modifier', 'oui'],
        ['users.id', Auth::user()->id]
    ])
    ->update(['verificationsconfirmation' => "oui"]);