Laravel::Raw & Fluent Query Builder มาดูการย่อคำสั่ง Sql ให้เหลือบรรทัดเดียวในสไตน์ ของ Laravel

$users = DB::query('select * from users');

$users = DB::query('select * from users where name = ?', array('test'));

$success = DB::query('insert into users values (?, ?)', $bindings);

$affected = DB::query('update users set name = ?', $bindings);

$affected = DB::query('delete from users where id = ?', array(1));

$user = DB::first('select * from users where id = 1');

$email = DB::only('select email from users where id = 1');

$query = DB::table('users');

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

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

$user = DB::table('users')->find($id);

$email = DB::table('users')->where('id', '=', 1)->only('email');

$user = DB::table('users')->get(array('id', 'email as user_email'));

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

return DB::table('users')
    ->where('id', '=', 1)
    ->or_where('email', '=', '[email protected]')
    ->first();

return DB::table('users')
    ->where('id', '>', 1)
    ->or_where('name', 'LIKE', '%Taylor%')
    ->first();

DB::table('users')->where_in('id', array(1, 2, 3))->get();

DB::table('users')->where_not_in('id', array(1, 2, 3))->get();

DB::table('users')
    ->where('email', '=', '[email protected]')
    ->or_where_in('id', array(1, 2, 3))
    ->get();

DB::table('users')
    ->where('email', '=', '[email protected]')
    ->or_where_not_in('id', array(1, 2, 3))
    ->get(); 

return DB::table('users')->where_null('updated_at')->get();

return DB::table('users')->where_not_null('updated_at')->get();

return DB::table('users')
    ->where('email', '=', '[email protected]')
    ->or_where_null('updated_at')
    ->get();

return DB::table('users')
    ->where('email', '=', '[email protected]')
    ->or_where_not_null('updated_at')
    ->get();

$users = DB::table('users')
    ->where('id', '=', 1)
    ->or_where(function($query)
    {
        $query->where('age', '>', 25);
        $query->where('votes', '>', 100);
    })
    ->get();

SELECT * FROM "users" WHERE "id" = ? OR ("age" > ? AND "votes" > ?)

$user = DB::table('users')->where_email('[email protected]')->first();

$user = DB::table('users')->where_email_and_password('[email protected]', 'secret')

$user = DB::table('users')->where_id_or_name(1, 'Fred');

DB::table('users')
    ->join('phone', 'users.id', '=', 'phone.user_id')
    ->get(array('users.email', 'phone.number'));
จะใช้ left join ก็เหมือนกันเลยครับ
DB::table('users')
    ->left_join('phone', 'users.id', '=', 'phone.user_id')
    ->get(array('users.email', 'phone.number'));

DB::table('users')
    ->join('phone', function($join)
    {
        $join->on('users.id', '=', 'phone.user_id');
        $join->or_on('users.id', '=', 'phone.contact_id');
    })
    ->get(array('users.email', 'phone.number'));

return DB::table('users')->order_by('email', 'desc')->get();

return DB::table('users')
    ->order_by('email', 'desc')
    ->order_by('name', 'asc')
    ->get();

return DB::table('users')->take(10)->get();

return DB::table('users')->skip(10)->get();

$min = DB::table('users')->min('age');
$max = DB::table('users')->max('weight');
$avg = DB::table('users')->avg('salary');
$sum = DB::table('users')->sum('votes');
$count = DB::table('users')->count();

$count = DB::table('users')->where('id', '>', 10)->count();

DB::table('users')->update(array('updated_at' => DB::raw('NOW()')));

DB::table('users')->update(array('votes' => DB::raw('votes + 1')));

DB::table('users')->increment('votes');
DB::table('users')->decrement('votes');

DB::table('users')->insert(array('email' => '[email protected]'));

$id = DB::table('users')->insert_get_id(array('email' => '[email protected]'));

$affected = DB::table('users')->update(array('email' => '[email protected]'));
จะแก้ไข้หลายแถวก็ใช้ where เลยครับ
$affected = DB::table('users')
    ->where('id', '=', 1)
    ->update(array('email' => '[email protected]'));

$affected = DB::table('users')->where('id', '=', 1)->delete();

$affected = DB::table('users')->delete(1);