Laravel with and where

Where with and and or in a laravel

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

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();

Laravel where

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

Source: laravel.com

Laravel where in

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

Laravel where and where

Table::where('Column', Value)->where('NewColumn', Value)->get();

Source: laracasts.com

Similar codes

0 vote186 views1 answer
How to select specific id in laravel using isset
PHP Laravel
0 vote130 views2 answers
Show query in laravel
PHP Laravel
47 votes196 views6 answers
How to run specific seeder in laravel
PHP Laravel
10 votes157 views2 answers
Array to string conversion in laravel controller
PHP Laravel
0 vote144 views1 answer
Job execute async laravel
PHP Laravel
1 vote131 views3 answers
Laravel eloquent to array key value
PHP Laravel
0 vote132 views1 answer
Laravel eloquent get current sequence value
PHP Laravel
15 votes144 views1 answer
Laravel composer install ignore
PHP Laravel
0 vote152 views2 answers
Request get query string laravel
PHP Laravel
0 vote152 views1 answer
Prevent xss attack in laravel
PHP Laravel