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

48 votes311 views6 answers
Join in laravel
PHP
0 vote297 views1 answer
Php ajax registration form validation
PHP
0 vote317 views1 answer
Laravel move file from local to s3
PHP
0 vote394 views1 answer
Laravel development serve doesn't stop
PHP Laravel
1 vote317 views2 answers
Run powershell script in background
PHP
0 vote413 views1 answer
Wordpress get page number
PHP Wordpress
22 votes335 views6 answers
Laravel where like
PHP
0 vote308 views2 answers
Set_magic_quotes_runtime php 7
PHP
0 vote302 views1 answer
Magento 2 get collection
PHP
0 vote295 views1 answer
Main.php
PHP