Laravel? ??? ?? ?? ?? PHP ????? ? ???? ?? ??? ???? ???? ???? ????. ? ????? Laravel? ?? ??? ??? ???? ? ?? ???? ?? ??? ???? ??? ??? ???? ??? ?????.

Laravel ??? ?? ??
Laravel?? ?? ?? Eloquent ORM? ???? ?????. ORM? ?? ??? ??(Object Relational Mapping)??, ?? ?? ??????? ?? ?? ???? ??? ? ?? ???????? ?? ?? ????? ?? ??????.

??? Laravel ?? ??? ??? ????.

//?? ??? ????
$user = User::find(1);

//??? ?? ????
$users = User::all( );

//??? ???, ??? ???? ??? ?? ????
$users = User::where('age', '>', 18)->get();

//??? ????
$user-> ;name = 'new name';
$user->save();

//Delete data
$user->delete();

?? ?? Laravel ?? ??? ???? ???? CURD ??? ?? ??? ? ????. ????? ????? ???? ? ?? ?? ??? ?????.

????? ???? ?? ??

1. where()
   where() ??? ?? ???? ??? ??? ?????. ??? ??? ?? ?? ??? ???? ???? ??????. ?:

$users = User::where('age', '>', 18)->where('gender', 'male')->get();

where() method ???? ???? ? ?? ????? ?? ?? ????. ?:

$users = User::where('age', '>=', 18)->get();

2. orderBy( )
   orderBy() ???? ???? ?????. ?? ??, ???? ??? ???? ??? ? ????.

$users = User::orderBy('age')->get();

????? orderBy() ???? ?????? ?????. ?????? ????? DESC ????? ??? ? ????:

$users = User::orderBy('age', 'desc')->get();

?? orderBy() ???? ?? ?? ??? ???? ?? ?? ????? ?? ? ????:

$users = User::orderBy('age', 'desc')->orderBy('name')->get();

3. select( )
   select() ???? ??? ?? ???? ? ?????. ?:

$users = User::select('name', 'email')->get();

?? *? ???? ?? ?? ??? ?? ????.

$users = User::select (' *')->get();

4. take() ? Skip()
   take() ???? ???? ??? ?? ???? ? ????, Skip()? ??? ??? ?? ???? ? ?????. . ?? ??, ?? 10?? ???? ??? ? ????:

$users = User::take(10)->get();

???? ???? ?? Skip() ???? ??? ?? ????:

$users = ???: :skip(10)->take(10)->get();

5. whereIn() ? whereNotIn()
   whereIn(), whereNotIn() ???? ???? IN ? NOT IN? ??? ? ????. ????. ?? ??, 18? ??? ???? ???? ??? ?? ??? ? ????.

$users = User::whereIn('age', [16, 17, 18])->get();

6. whereNull( ) ? whereNotNull()
   whereNull() ???? ??? ?? ?? ?? ???? ???? ? ??, whereNotNull()? ?? ?? ?? ???? ???? ? ????. ?:

$users = User::whereNull('email')->get();

7. groupBy() ? have()
   groupBy() ???? ?? ??? ????? ? ?????. ( ) ???? ???? ??? ????? ? ?????. ?? ?? ???? ????? 20? ??? ?? ???? ???? ? ????.

$users = User::groupBy('gender')->having('age', '>' , 20 )->get();

??? ??

???? Laravel ?? ??? ? ?? ?? ???? ?????. ??? ?? ????? ????? ???? ?? ???? ?? ??? ? ??? ?? ????? ? ?? ?? ??? ???? ???. Laravel??? ?? ??? ???? ?? ??? ?? ?? ??? ? ????.

?? ?? ?? ???? 500??? ???? ???? ????? ??? ?? ??? ? ????.

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

        ->join('orders', 'users.id', '=', 'orders.user_id')
        ->select('users.id', 'users.name', 'users.email', DB::raw('SUM(orders.total) as total'))
        ->groupBy('users.id')
        ->having('total', '>', 500)
        ->get();

? ????? Join( ) ???? ???? ??? ???? ?? ???? ????, groupBy() ???? ???? ???? ?????, have() ???? ???? ?? ???? 500??? ???? ???? ??????.

Summary

Laravel??? Eloquent ORM? ???? ?? CURD ??? ?? ??? ? ????. ??? ?? ??? ???? ? ??? ??? ??? ? ????. ? ?? Laravel? ?? ??? ???? ? ??? ??? ????.

? ??? laravel ?? ??? ?? ?????. ??? ??? PHP ??? ????? ?? ?? ??? ?????!