Laravel where

Laravel update from query

$affected = DB::table('users')
              ->where('id', 1)
              ->update(['votes' => 1]);

Source: laravel.com

Laravel wher in

$users = DB::table('users')
                    ->whereIn('id', [1, 2, 3])
                    ->get();

Laravel join

$latestPosts = DB::table('posts')
                   ->select('user_id', DB::raw('MAX(created_at) as last_post_created_at'))
                   ->where('is_published', true)
                   ->groupBy('user_id');

$users = DB::table('users')
        ->joinSub($latestPosts, 'latest_posts', function ($join) {
            $join->on('users.id', '=', 'latest_posts.user_id');
        })->get();

Source: laravel.com

Laravel where

$users = DB::table('users')
                ->whereMonth('created_at', '12')
                ->get();

Source: laravel.com

Laravel with and where

$projects = Project::whereHas('projectOffers', function ($offer) {
            $offer->where('teacher_id', "Ahmed");
            $offer->where('status_id', "Accepted");
        })->where('status_id', "inprogress")->get();

Where clause in laravel

        $users = DB::table('user')->select('id', 'name', 'email','api_token','created_at')->where('email' , $email)->get();
        return response()->json($users);

Similar codes

1 vote178 views1 answer
Get current month record in laravel
PHP Laravel
9 votes180 views5 answers
Laravel updateOrInsert
PHP Laravel
44 votes175 views6 answers
How to create controller in laravel
PHP Laravel
46 votes197 views3 answers
How to check laravel version in cmd
PHP Laravel
0 vote199 views1 answer
Laravel collection prepend
PHP Laravel
0 vote205 views1 answer
Laravel add package without updating
PHP Laravel
0 vote232 views2 answers
Laravel composite unique key
PHP Laravel
0 vote170 views1 answer
Laravel faker boolean
PHP Laravel
0 vote166 views1 answer
Laravel migrate error default character 199 boot
PHP Laravel
3 votes161 views2 answers
Custom 404 page in laravel
PHP Laravel