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

33 votes161 views6 answers
Create migration command in laravel
PHP Laravel
8 votes128 views1 answer
Laravel get variable from url
PHP Laravel
0 vote158 views1 answer
Import facade URL laravel
PHP Laravel
7 votes171 views6 answers
Set session in laravel
PHP Laravel
0 vote159 views1 answer
Laravel vue browser cache auto clear
PHP Laravel
0 vote147 views1 answer
Laravel check model column was changed
PHP Laravel
10 votes153 views4 answers
Laravel create
PHP Laravel
0 vote178 views1 answer
Validate rule if row exist laravel
PHP Laravel
0 vote154 views2 answers
Maatwebsite/excel package 5.2 laravel
PHP Laravel
1 vote149 views2 answers
Force https redirection laravel
PHP Laravel