Query builder laravel

Laravel not in query

DB::table(..)->select(..)->whereNotIn('book_price', [100,200])->get();

Laravel wher in

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

Wherein laravel

 DB::table('user')->whereIn('id', [100,200])->get();

Query builder laravel

use Illuminate\Database\Eloquent\Builder;

public function scopeFakePersons(Builder $query): Builder
{
  return $query->where('is_fake', 1);
}

DB::table('users')->get();

$users = DB::table('users')->get();

Source: stackoverflow.com

How to get data from a table in laravel

use Illuminate\Support\Facades\DB;

class UserController extends Controller
{
    public function index()
    {
        $users = DB::table('users')->select('id','name','email')->get();

        return view('some-view')->with('users', $users);
    }
}

Source: stackoverflow.com

Similar codes

0 vote327 views1 answer
Laravel vue error 500
PHP Laravel
1 vote225 views1 answer
Laravel validation on fields inside array in request
PHP Laravel
0 vote309 views1 answer
Laravel collection prepend
PHP Laravel
10 votes295 views2 answers
Create model in laravel command line
PHP Laravel
24 votes267 views4 answers
Where not null in laravel
PHP Laravel
0 vote316 views1 answer
Calculate average in eager loading laravel
PHP Laravel
2 votes301 views2 answers
Laravel run controller from command line
PHP Laravel
6 votes307 views2 answers
Laravel eloquent debug query
PHP Laravel
1 vote285 views1 answer
Get age with carbon in laravel
PHP Laravel
1 vote311 views1 answer
Parametre grouping laravel quert
PHP Laravel