Query builder

Laravel not in query

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

Wherein laravel

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

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

DB::select('SELECT * FROM users WHERE name = ?', array(Input::get('name')));

Source: stackoverflow.com

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

Laravel find query

return Destination::orderByDesc(
    Flight::select('arrived_at')
        ->whereColumn('destination_id', 'destinations.id')
        ->orderBy('arrived_at', 'desc')
        ->limit(1)
)->get();

Source: laravel.com

Similar codes

0 vote201 views1 answer
Fakher ul islam khan
PHP
9 votes199 views4 answers
Laravel soft delete example
PHP
0 vote246 views1 answer
Php print string as bytes
PHP
2 votes211 views5 answers
Laravel installation in windows
PHP
1 vote243 views2 answers
Laravel sail alias
PHP Laravel
0 vote228 views1 answer
Post request data not getting from guzzle laravel
PHP Laravel
0 vote221 views1 answer
Laravelda so`rovlarni cheklash
PHP
5 votes194 views5 answers
Install php version 7.3 ubuntu
PHP
19 votes203 views5 answers
Js var to php
PHP
0 vote198 views1 answer
Error repoerting in php
PHP