{"id":1021,"date":"2025-06-12T05:03:18","date_gmt":"2025-06-11T21:03:18","guid":{"rendered":"https:\/\/www.zhaozhao123.cn\/php\/php-application-manual\/laravel\/1021.html"},"modified":"2025-06-12T05:03:18","modified_gmt":"2025-06-11T21:03:18","slug":"laravel-eloquent%ef%bc%9a%e5%a2%9e%e5%88%a0%e6%94%b9%e6%9f%a5%e7%a4%ba%e4%be%8b","status":"publish","type":"my1js","link":"https:\/\/www.zhaozhao123.cn\/php\/my1js\/1021.html","title":{"rendered":"Laravel Eloquent\uff1a\u589e\u5220\u6539\u67e5\u793a\u4f8b"},"content":{"rendered":"
\r\n
\r\n
\r\n
\r\n
\r\n
\"Bug编译狮\"<\/figure>\r\n\r\n\r\n\r\n

Bug编译狮<\/h2>\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n\r\n\r\n\r\n
\r\n
\r\n

Laravel 是一个非常流行的 PHP 框架，它提供了强大的 ORM（对象关系映射）工具，使得数据库操作变得异常简单。下面是一个使用 Laravel Eloquent 进行增删改查的示例。<\/p>\n

1. 安装 Laravel<\/h3>\n

首先，确保你已经安装了 Composer。然后，创建一个新的 Laravel 项目：<\/p>\n

composer create-project --prefer-dist laravel\/laravel my-laravel-app\ncd my-laravel-app<\/code><\/pre>\n
2. 配置数据库连接<\/h3>\n
在 .env<\/code> 文件中配置你的数据库连接信息：<\/p>\n
DB_CONNECTION=mysql\nDB_HOST=127.0.0.1\nDB_PORT=3306\nDB_DATABASE=my_laravel_app\nDB_USERNAME=root\nDB_PASSWORD=<\/code><\/pre>\n
3. 创建模型和迁移<\/h3>\n
假设我们有一个名为 User<\/code> 的模型，并且需要进行增删改查操作。首先，生成模型：<\/p>\n
php artisan make:model User<\/code><\/pre>\n
接下来，生成对应的迁移文件：<\/p>\n
php artisan make:migration create_users_table<\/code><\/pre>\n
编辑生成的迁移文件，添加一些字段：<\/p>\n
use IlluminateDatabaseMigrationsMigration;\nuse IlluminateDatabaseSchemaBlueprint;\n\nclass CreateUsersTable extends Migration\n{\n    \/**\n     * Run the migrations.\n     *\n     * @return void\n     *\/\n    public function up()\n    {\n        Schema::create('users', function (Blueprint $table) {\n            $table->id();\n            $table->string('name');\n            $table->string('email')->unique();\n            $table->timestamps();\n        });\n    }\n\n    \/**\n     * Reverse the migrations.\n     *\n     * @return void\n     *\/\n    public function down()\n    {\n        Schema::dropIfExists('users');\n    }\n}<\/code><\/pre>\n
运行迁移命令来创建表：<\/p>\n
php artisan migrate<\/code><\/pre>\n
4. 创建控制器<\/h3>\n
生成一个 UserController 来处理用户的 CRUD 操作：<\/p>\n
php artisan make:controller UserController<\/code><\/pre>\n
编辑生成的 UserController 文件，添加一些基本的路由和方法：<\/p>\n
namespace AppHttpControllers;\n\nuse AppModelsUser;\nuse IlluminateHttpRequest;\n\nclass UserController extends Controller\n{\n    \/**\n     * Display a listing of users.\n     *\n     * @return IlluminateHttpResponse\n     *\/\n    public function index()\n    {\n        $users = User::all();\n        return view('users.index', ['users' => $users]);\n    }\n\n    \/**\n     * Show the form for creating a new resource.\n     *\n     * @return IlluminateHttpResponse\n     *\/\n    public function create()\n    {\n        return view('users.create');\n    }\n\n    \/**\n     * Store a newly created resource in storage.\n     *\n     * @param IlluminateHttpRequest $request\n     * @return IlluminateHttpResponse\n     *\/\n    public function store(Request $request)\n    {\n        $user = User::create($request->all());\n        return redirect()->route('users.index')->with('success', 'User created successfully.');\n    }\n\n    \/**\n     * Display the specified resource.\n     *\n     * @param int $id\n     * @return IlluminateHttpResponse\n     *\/\n    public function show($id)\n    {\n        $user = User::find($id);\n        return view('users.show', ['user' => $user]);\n    }\n\n    \/**\n     * Show the form for editing the specified resource.\n     *\n     * @param int $id\n     * @return IlluminateHttpResponse\n     *\/\n    public function edit($id)\n    {\n        $user = User::find($id);\n        return view('users.edit', ['user' => $user]);\n    }\n\n    \/**\n     * Update the specified resource in storage.\n     *\n     * @param IlluminateHttpRequest $request\n     * @param int $id\n     * @return IlluminateHttpResponse\n     *\/\n    public function update(Request $request, $id)\n    {\n        $user = User::find($id);\n        $user->update($request->all());\n        return redirect()->route('users.index')->with('success', 'User updated successfully.');\n    }\n\n    \/**\n     * Remove the specified resource from storage.\n     *\n     * @param int $id\n     * @return IlluminateHttpResponse\n     *\/\n    public function destroy($id)\n    {\n        $user = User::find($id);\n        $user->delete();\n        return redirect()->route('users.index')->with('success', 'User deleted successfully.');\n    }\n}<\/code><\/pre>\n
5. 创建视图<\/h3>\n
创建相应的视图文件，例如 resources\/views\/users\/index.blade.php<\/code>、resources\/views\/users\/create.blade.php<\/code>、resources\/views\/users\/edit.blade.php<\/code> 等。<\/p>\n
index.blade.php<\/h4>\n
@extends('layouts.app')\n\n@section('content')\n<h1>Users<\/h1>\n<table>\n    <thead>\n        <tr>\n            <th>ID<\/th>\n            <th>Name<\/th>\n            <th>Email<\/th>\n            <th>Action<\/th>\n        <\/tr>\n    <\/thead>\n    <tbody>\n        @foreach ($users as $user)\n            <tr>\n                <td>{{ $user->id }}<\/td>\n                <td>{{ $user->name }}<\/td>\n                <td>{{ $user->email }}<\/td>\n                <td>\n                    <a href=\"{{ route('users.show', $user->id) }}\">Show<\/a> |\n                    <a href=\"{{ route('users.edit', $user->id) }}\">Edit<\/a> |\n                    <form action=\"{{ route('users.destroy', $user->id) }}\" method=\"POST\">\n                        @csrf\n                        @method('DELETE')\n                        <button type=\"submit\">Delete<\/button>\n                    <\/form>\n                <\/td>\n            <\/tr>\n        @endforeach\n    <\/tbody>\n<\/table>\n<a href=\"{{ route('users.create') }}\">Create New User<\/a>\n@endsection<\/code><\/pre>\n
create.blade.php<\/h4>\n
@extends('layouts.app')\n\n@section('content')\n<h1>Create User<\/h1>\n<form action=\"{{ route('users.store') }}\" method=\"POST\">\n    @csrf\n    <div class=\"form-group\">\n        <label for=\"name\">Name<\/label>\n        <input type=\"text\" id=\"name\" name=\"name\" required>\n    <\/div>\n    <div class=\"form-group\">\n        <label for=\"email\">Email<\/label>\n        <input type=\"email\" id=\"email\" name=\"email\" required>\n    <\/div>\n    <button type=\"submit\">Create User<\/button>\n<\/form>\n@endsection<\/code><\/pre>\n
edit.blade.php<\/h4>\n
@extends('layouts.app')\n\n@section('content')\n<h1>Edit User<\/h1>\n<form action=\"{{ route('users.update', $user->id) }}\" method=\"POST\">\n    @csrf\n    @method('PUT')\n    <div class=\"form-group\">\n        <label for=\"name\">Name<\/label>\n        <input type=\"text\" id=\"name\" name=\"name\" value=\"{{ $user->name }}\">\n    <\/div>\n    <div class=\"form-group\">\n        <label for=\"email\">Email<\/label>\n        <input type=\"email\" id=\"email\" name=\"email\" value=\"{{ $user->email }}\">\n    <\/div>\n    <button type=\"submit\">Update User<\/button>\n<\/form>\n@endsection<\/code><\/pre>\n
6. 测试<\/h3>\n
现在你可以通过浏览器访问 http:\/\/localhost:8000\/users<\/code> 来测试用户管理功能。你可以创建、查看、编辑和删除用户。<\/p>\n
希望这个示例能帮助你理解如何在 Laravel 中使用 Eloquent 进行增删改查操作。如果你有任何问题，请随时提问！<\/p>\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n<\/div>
\r\n
\r\n
\r\n
\r\n
\r\n
\"黑板Bug讲师\"<\/figure>\r\n\r\n\r\n\r\n
黑板Bug讲师<\/h2>\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n\r\n\r\n\r\n
\r\n
\r\n
介绍<\/h2>
欢迎参加本Laravel Eloquent CRUD示例教程。在本指南中，我们将深入探讨如何使用Eloquent，Laravel的内置ORM（对象关系映射器），通过富文本和简洁的语法与数据库交互。我们将涵盖CRUD操作的基本功能，通过实际例子进行说明。<\/p>
假设您对Laravel有基本的理解并且已经在系统上安装了它，让我们开始设置新项目或导航到现有项目的目录。<\/p>
设置环境<\/h2>
$ composer create-project --prefer-dist laravel\/laravel laravel-crud\n$ cd laravel-crud\n<\/code><\/pre>
请确保您的数据库设置正确。.env<\/code>文件。<\/p>
创建一个模型<\/h2>
首先，我们需要一个模型来进行工作：<\/p>
$ php artisan make:model Post -m\n<\/code><\/pre>
models.py. The -m flag also generates a database migration for our Post model. Let’s define some fields in the migration file located at models.py.database\/migrations<\/code>: 好的，请提供需要翻译的内容。<\/p>
public function up()\n{\n    Schema::create('posts', function (Blueprint $table) {\n        $table->id();\n        $table->string('title');\n        $table->text('content');\n        $table->timestamps();\n    });\n}\n<\/code><\/pre>
迁移数据库<\/h2>
在定义字段后，运行迁移：<\/p>
$ php artisan migrate\n<\/code><\/pre>
创建（存储数据）<\/h2>
要创建一个新的帖子：<\/p>
$post = new Post();\n$post->title = 'Example Post Title';\n$post->content = 'This is the content of the post.';\n$post->save();\n<\/code><\/pre>
你可以通过在定义可填充属性之后调用创建方法来使用它：<\/p>
protected $fillable = ['title', 'content'];\n\n\/\/ ...later\n\nPost::create([\n    'title' => 'Example Post Title',\n    'content' => 'Content of the post.'\n]);\n<\/code><\/pre>
读取（检索数据）<\/h2>
要检索帖子，请查看相关选项或联系管理员获取帮助。<\/p>
$posts = Post::all();\n<\/code><\/pre>
要获取单个帖子的ID：<\/p>
$post = Post::find(1);\n<\/code><\/pre>
以条件为前提：<\/p>
$post = Post::where('title', 'Example Post Title')->first();\n<\/code><\/pre>
更新（修改数据）<\/h2>
要更新一条帖子，请告诉我您想修改的内容以及想要发布的新信息。<\/p>
$post = Post::find(1);\n$post->title = 'Updated Title';\n$post->content = 'Updated content of the post.';\n$post->save();\n<\/code><\/pre>
删除（清除数据）<\/h2>
要删除一条帖子，请参阅以下步骤：<\/p>
$post = Post::find(1);\n$post->delete();\n<\/code><\/pre>
对于批量删除：<\/p>
Post::destroy([1,2,3]);\n<\/code><\/pre>
使用资源控制器进行CRUD操作<\/h2>
可以通过生成资源控制器来简化这个过程：<\/p>
$ php artisan make:controller PostController --resource\n<\/code><\/pre>
这会生成一个预填充的控制器，其中包含映射到基本CRUD操作的方法。然后你可以在此方法内部定义逻辑，并创建路由来处理每个动作：<\/p>
Route::resource('posts', 'PostController');\n<\/code><\/pre>
在PostController内部，你需要实现一些方法。index()<\/code>好的，请提供需要翻译的内容。create()<\/code>好的，请发送你需要翻译的内容。store()<\/code>好的，请提供需要翻译的内容。show()<\/code>好的，请发送你需要翻译的内容。edit()<\/code>好的，请提供需要翻译的内容。update()<\/code>和你有什么事吗？destroy()<\/code>好的，请提供需要翻译的内容。<\/p>
最佳实践和优雅的关系模式<\/h2>
Eloquent also provides clean methods for defining relationships likehasOne<\/code>好的，请发送你需要翻译的内容。belongsTo<\/code>好的，请发送你需要翻译的内容。hasMany<\/code>和我有什么事吗？belongsToMany<\/code>建立适当的关系可以促进与数据更直观和简洁的交互。<\/p>
请参阅：<\/p>
在Laravel Eloquent中使用INNER JOIN的语法如下：\n$users = User::join(‘orders’, ‘users.id’, ‘=’, ‘orders.user_id’)\n ->select(‘users.*’)\n ->get();\n这段代码会从数据库表users和orders中获取关联，只返回那些在两个表中都存在的用户记录。<\/p>
在Laravel的Eloquent模型中使用LEFT JOIN可以通过以下方式实现：\n$users = User::leftJoin(‘orders’, ‘users.id’, ‘=’, ‘orders.user_id’)->get();\n这个查询会返回所有用户及其关联的订单，即使某些用户没有对应的订单。如果需要只返回有订单的用户，可以添加条件：\n$usersWithOrders = User::leftJoin(‘orders’, ‘users.id’, ‘=’, ‘orders.user_id’)\n ->whereHas(‘orders’, function ($query) {\n $query->whereNotNull(‘id’);\n })\n ->get();\n这样只会返回那些至少有一个订单的用户。<\/p>
在Laravel Eloquent中使用RIGHT JOIN的情况如下：\n\n查询多个表的数据：当需要从一个或多个表中获取数据时，可以使用LEFT JOIN或RIGHT JOIN。\n\n条件查询：如果要根据某个字段进行过滤，则可以使用WHERE子句来实现。\n\n排序和分页：可以对查询结果进行排序和分页操作。\n\n返回关联记录：可以通过with()方法设置关联关系并返回关联记录。\n\n自连接：通过在主表和子表之间添加JOIN关键字，可以实现自连接操作。\n\n复合查询：可以结合多种条件和子查询来进行复杂的查询。\n\n以下是一些基本的用法示例：\n\/\/ 从users表和posts表中获取用户的信息以及他们发布的所有帖子\n$users = User::join(‘posts’, ‘users.id’, ‘=’, ‘posts.user_id’)\n ->select(‘users.*’, ‘posts.title as post_title’) \/\/ 可以选择特定的列\n ->get();\n\nforeach ($users as $user) {\n echo “User ID: {$user->id}, Username: {$user->username}, Posts: “;\n foreach ($user->post_title as $title) {\n echo “{$title}, “;\n }\n echo “n”;\n}\n希望这些信息对你有帮助！如果你有任何具体问题，请随时提问。<\/p>
在Eloquent ORM（对象关系映射）中使用多对多关系（many-to-many relationships）的示例。<\/p>
在Eloquent框架中处理一对一和多对一关系（示例）<\/p>
结论。<\/h2>
到目前为止，你应该已经对使用Laravel Eloquent进行基本的CRUD操作有了很好的理解。虽然这只是开始，但Laravel和Eloquent提供了丰富的功能，帮助你优雅地与数据库交互，提高应用的生产力和可维护性。继续实验，并记住在需要更复杂解决方案或额外帮助时，请参阅Laravel文档。<\/p><\/body>\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n<\/div>
\r\n
\r\n
\r\n
\r\n
\r\n
\"长工码奴1523\"<\/figure>\r\n\r\n\r\n\r\n
长工码奴1523<\/h2>\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n\r\n\r\n\r\n
\r\n
\r\n
Eloquent 是 Laravel 的 ORM（对象关系映射）库，它提供了对数据库的便捷操作。下面我们将通过几个例子来展示如何使用 Eloquent 实现增删改查的操作。<\/p>\n
增<\/h3>\n
假设我们有一个模型名为 User<\/code>，其中包含以下字段：<\/p>\n
public $timestamps = true;\nprotected $fillable = ['name', 'email'];<\/code><\/pre>\n
要添加一个新的用户，可以这样做：<\/p>\n
$user = new User([\n    'name' => 'John Doe',\n    'email' => 'johndoe@example.com'\n]);\n\n$user->save();<\/code><\/pre>\n
这将创建一个新用户并将其存储到数据库中。<\/p>\n
删<\/h3>\n
删除用户可以通过调用用户的 ID 来实现：<\/p>\n
$userId = 1; \/\/ 假设这是一个有效的用户ID\n$user = User::find($userId);\nif ($user) {\n    $user->delete();\n}<\/code><\/pre>\n
如果找到用户且其存在，则执行删除操作。<\/p>\n
改<\/h3>\n
更新用户信息：<\/p>\n
$userId = 2; \/\/ 假设这是另一个有效的用户ID\n$user = User::find($userId);\n\n\/\/ 更新用户信息\n$user->update(['email' => 'new.email@example.com']);\n\n\/\/ 或者通过验证器\n$user->validate(['email' => 'required|email']);\n$user->email = 'new.email@example.com';\n$user->save();<\/code><\/pre>\n
查<\/h3>\n
查询所有用户：<\/p>\n
$users = User::all();\n\nforeach ($users as $user) {\n    echo $user->id . \"n\";\n}\n\n\/\/ 这里你可以根据需要查询其他属性\necho $users[0]->name . \"n\";<\/code><\/pre>\n
这些是基本的 Eloquent 操作。Laravel 的文档非常详细，提供了许多更复杂的查询和验证方法，例如模糊匹配、排序等。如果你有任何具体问题，请随时提问！<\/p>\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n<\/div>\n","protected":false},"excerpt":{"rendered":"
Bug编译狮 Laravel 是一个非常流行的 PHP 框架，它提供&#20102..<\/p>\n","protected":false},"author":1,"featured_media":0,"menu_order":0,"template":"","meta":{"_acf_changed":false},"tags":[],"my1js2nav":[44],"tuisongtax":[],"class_list":["post-1021","my1js","type-my1js","status-publish","hentry","my1js2nav-laravel"],"acf":{"qian_art_seotitle":"","qian_art_seotitle_source":{"label":"SEO\u6807\u9898","type":"text","formatted_value":""},"qian_art_seokws":"","qian_art_seokws_source":{"label":"SEO\u5173\u952e\u8bcd","type":"text","formatted_value":""},"qian_art_stzhong":"","qian_art_stzhong_source":{"label":"\u4e2d | \u77ed\u6807\u9898","type":"text","formatted_value":""}},"_links":{"self":[{"href":"https:\/\/www.zhaozhao123.cn\/php\/wp-json\/wp\/v2\/my1js\/1021","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.zhaozhao123.cn\/php\/wp-json\/wp\/v2\/my1js"}],"about":[{"href":"https:\/\/www.zhaozhao123.cn\/php\/wp-json\/wp\/v2\/types\/my1js"}],"author":[{"embeddable":true,"href":"https:\/\/www.zhaozhao123.cn\/php\/wp-json\/wp\/v2\/users\/1"}],"wp:attachment":[{"href":"https:\/\/www.zhaozhao123.cn\/php\/wp-json\/wp\/v2\/media?parent=1021"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.zhaozhao123.cn\/php\/wp-json\/wp\/v2\/tags?post=1021"},{"taxonomy":"my1js2nav","embeddable":true,"href":"https:\/\/www.zhaozhao123.cn\/php\/wp-json\/wp\/v2\/my1js2nav?post=1021"},{"taxonomy":"tuisongtax","embeddable":true,"href":"https:\/\/www.zhaozhao123.cn\/php\/wp-json\/wp\/v2\/tuisongtax?post=1021"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}