Laravel 쿼리빌더

1 개요[ | ]

Laravel Query Builder
라라벨 쿼리빌더

라라벨 DB 저장방법 중 하나
DB 쿼리 관리에 편리한 인터페이스 제공
PDO 파라미터 바인딩을 통하여 SQL 인젝션 공격 방어

2 where 사용하기[ | ]

where을 사용하기 위해서는 컬럼명, 연산자, 값을 입력해 줘야함.

users 테이블에서 votes 컬럼이 100의 값을 가지는 사용자 쿼리

PHP

Copy

$users = DB::table('users')->where('votes', '=', 100)->get(); //

3 예시[ | ]

라라벨 쿼리빌더	SQL
PHP Copy $users = DB::table('users')->get();	sql Copy SELECT * FROM users;
PHP Copy $user = DB::table('users')->where('name', 'John')->first();	sql Copy SELECT * FROM users WHERE name='John' LIMIT 1;
PHP Copy $users = DB::table('users')->where('votes', 100)->get(); PHP Copy $users = DB::table('users')->where('votes', '=', 100)->get();	sql Copy SELECT * FROM users WHERE votes=100;
PHP Copy $users = DB::table('users')->where('votes', '>=', 100)->get();	sql Copy SELECT * FROM users WHERE votes >= 100;
PHP Copy $users = DB::table('users')->where('votes', '<>', 100)->get();	sql Copy SELECT * FROM users WHERE votes <> 100;
PHP Copy $users = DB::table('users')->where('name', 'like', 'T%')->get();	sql Copy SELECT * FROM users WHERE name LIKE 'T%';
PHP Copy $users = DB::table('users')->where([ ['status', '=', '1'], ['subscribed', '<>', '1'], ])->get();	sql Copy SELECT * FROM users WHERE status='1' AND subscribed<>'1';
PHP Copy $users = DB::table('users')->where('votes', '>', 100)->orWhere('name', 'John')->get();	sql Copy SELECT * FROM users WHERE votes>100 OR name='John';
PHP Copy $email = DB::table('users')->where('name', 'John')->value('email');	sql Copy SELECT email FROM users WHERE name='John';
PHP Copy $users = DB::table('users')->orderBy('name', 'desc')->get();	sql Copy SELECT * FROM users ORDER BY name DESC;
PHP Copy $users = DB::table('users')->take(5)->get();	sql Copy SELECT * FROM users LIMIT 5;
PHP Copy DB::table('users')->where('votes', '>', 100)->delete();	sql Copy DELETE FROM users WHERE votes > 100;

4 같이 보기[ | ]

5 참고[ | ]

https://laravel.com/docs/master/queries