query builder code example

Example 1: laravel not in query

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

Example 2: wherein laravel

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

Example 3: doctrine order by

<?php
// $qb instanceof QueryBuilder

$qb->select('u')
   ->from('User', 'u')
   ->where('u.id = ?1')
   ->orderBy('u.name', 'ASC');

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

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

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

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

Example 6: laravel find query

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