Laravel开发：如何使用Eloquent ORM进行数据库查询？

composer require illuminate/database

'connections' => [

    'mysql' => [
        'driver' => 'mysql',
        'host' => env('DB_HOST', '127.0.0.1'),
        'port' => env('DB_PORT', '3306'),
        'database' => env('DB_DATABASE', 'forge'),
        'username' => env('DB_USERNAME', 'forge'),
        'password' => env('DB_PASSWORD', ''),
        'unix_socket' => env('DB_SOCKET', ''),
        'charset' => 'utf8mb4',
        'collation' => 'utf8mb4_unicode_ci',
        'prefix' => '',
        'strict' => true,
        'engine' => null,
    ],

],

DB_CONNECTION=mysql
DB_HOST=127.0.0.1
DB_PORT=3306
DB_DATABASE=laravel
DB_USERNAME=root
DB_PASSWORD=

php artisan make:model User

class User extends Model
{
    protected $table = 'my_users';
}

$users = User::all();

$user = User::find(1);

$users = User::where('name', 'John')->get();

$users = User::where('name', '=', 'John')->get();
$users = User::where('age', '>', 18)->get();
$users = User::whereIn('id', [1, 2, 3])->get();

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

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

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

$avg_age = User::avg('age');
$max_age = User::max('age');
$min_age = User::min('age');
$count = User::count();

$user = User::find(1);
$user->name = 'John';
$user->save();

User::where('active', 1)->update(['status' => 'inactive']);

$user = User::find(1);
$user->delete();

User::destroy([1, 2, 3]);