{"id":820,"date":"2025-06-12T00:26:25","date_gmt":"2025-06-11T16:26:25","guid":{"rendered":"https:\/\/www.zhaozhao123.cn\/php\/php-application-manual\/laravel\/820.html"},"modified":"2025-06-12T00:26:25","modified_gmt":"2025-06-11T16:26:25","slug":"laravel-eloquent%ef%bc%9a%e5%a6%82%e4%bd%95%e6%9e%84%e5%bb%ba%e8%af%84%e5%88%86%e7%b3%bb%e7%bb%9f","status":"publish","type":"my1js","link":"https:\/\/www.zhaozhao123.cn\/php\/my1js\/820.html","title":{"rendered":"Laravel + Eloquent\uff1a\u5982\u4f55\u6784\u5efa\u8bc4\u5206\u7cfb\u7edf"},"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 + Eloquent 构建评分系统<\/p>\n

评分系统是许多应用中的重要组成部分，例如在线评论、游戏排行榜等。在 Laravel 和 Eloquent 中，我们可以轻松地实现这个功能。以下是一个简单的示例，展示如何创建一个评分表，并使用 Eloquent 进行数据操作。<\/p>\n

1. 创建评分表模型<\/h3>\n

首先，我们需要创建一个评分表的模型。假设我们有一个名为 Rating<\/code> 的表，其中包含用户 ID、产品 ID 和评分值三个字段。<\/p>\n

php artisan make:model Rating<\/code><\/pre>\n
然后，在 app\/Models\/Rating.php<\/code> 文件中定义模型：<\/p>\n
namespace AppModels;\n\nuse IlluminateDatabaseEloquentModel;\n\nclass Rating extends Model\n{\n    protected $fillable = ['user_id', 'product_id', 'score'];\n}<\/code><\/pre>\n
2. 创建评分表迁移<\/h3>\n
接下来，我们需要创建一个数据库迁移文件来创建 Rating<\/code> 表。<\/p>\n
php artisan make:migration create_ratings_table --create=ratings<\/code><\/pre>\n
在生成的迁移文件中，添加以下代码：<\/p>\n
public function up()\n{\n    Schema::create('ratings', function (Blueprint $table) {\n        $table->id();\n        $table->unsignedBigInteger('user_id');\n        $table->unsignedBigInteger('product_id');\n        $table->integer('score')->nullable();\n        $table->timestamps();\n    });\n}\n\npublic function down()\n{\n    Schema::dropIfExists('ratings');\n}<\/code><\/pre>\n
运行迁移：<\/p>\n
php artisan migrate<\/code><\/pre>\n
3. 创建评分表控制器<\/h3>\n
现在，我们需要创建一个控制器来处理评分相关的请求。<\/p>\n
php artisan make:controller RatingController<\/code><\/pre>\n
在 app\/Http\/Controllers\/RatingController.php<\/code> 文件中定义控制器：<\/p>\n
namespace AppHttpControllers;\n\nuse AppModelsRating;\nuse IlluminateHttpRequest;\n\nclass RatingController extends Controller\n{\n    public function store(Request $request)\n    {\n        $rating = Rating::create([\n            'user_id' => $request->input('user_id'),\n            'product_id' => $request->input('product_id'),\n            'score' => $request->input('score')\n        ]);\n\n        return response()->json($rating, 201);\n    }\n\n    public function update(Request $request, $id)\n    {\n        $rating = Rating::find($id);\n\n        if ($rating) {\n            $rating->update([\n                'score' => $request->input('score')\n            ]);\n\n            return response()->json($rating, 200);\n        } else {\n            return response()->json(['message' => 'Rating not found'], 404);\n        }\n    }\n\n    public function destroy($id)\n    {\n        $rating = Rating::find($id);\n\n        if ($rating) {\n            $rating->delete();\n\n            return response()->json(['message' => 'Rating deleted'], 200);\n        } else {\n            return response()->json(['message' => 'Rating not found'], 404);\n        }\n    }\n}<\/code><\/pre>\n
4. 创建评分表路由<\/h3>\n
最后，我们需要在 routes\/api.php<\/code> 文件中定义路由。<\/p>\n
use AppHttpControllersRatingController;\n\nRoute::post('\/ratings', [RatingController::class, 'store']);\nRoute::put('\/ratings\/{id}', [RatingController::class, 'update']);\nRoute::delete('\/ratings\/{id}', [RatingController::class, 'destroy']);<\/code><\/pre>\n
示例代码<\/h3>\n
下面是一个完整的示例代码，展示了如何在 Laravel 和 Eloquent 中创建和操作评分系统。<\/p>\n
1. 安装 Laravel 和 Eloquent<\/h4>\n
确保你已经安装了 Laravel 和 Eloquent。如果没有安装，可以参考官方文档进行安装。<\/p>\n
2. 创建评分表模型和迁移<\/h4>\n
按照上述步骤创建评分表模型和迁移。<\/p>\n
3. 创建评分表控制器<\/h4>\n
按照上述步骤创建评分表控制器。<\/p>\n
4. 创建评分表路由<\/h4>\n
按照上述步骤创建评分表路由。<\/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 ORM。评分系统对于许多Web应用来说是不可或缺的功能，用于收集用户反馈。Laravel是一款流行且优雅的PHP Web应用程序框架，与Eloquent ORM相结合，使得实现这样的系统非常简单。<\/p>
定义评级模型<\/h2>
首先，创建一个评分模型和迁移文件。运行 Artisan 命令：<\/p>
php artisan make:model Rating -m<\/code><\/pre>
在创建的迁移文件中添加必要的列：<\/p>
Schema::create('ratings', function (Blueprint $table) {\n    $table->id();\n    $table->foreignId('user_id');\n    $table->foreignId('post_id');\n    $table->tinyInteger('rating');\n    $table->timestamps();\n});<\/code><\/pre>
迁移运行：<\/p>
php artisan migrate<\/code><\/pre>
建立关系<\/h2>
对于这个例子，假设我们有一个名为“Post”的模型，在该模型中用户可以留下评价。在Rating模型中添加关系：<\/p>
public function post()\n{\n    return $this->belongsTo(Post::class);\n}<\/code><\/pre>
此外，还需要在Post模型中添加逆关系：<\/p>
public function ratings()\n{\n    return $this->hasMany(Rating::class);\n}<\/code><\/pre>
创建一个评分控制器<\/h2>
使用Artisan创建一个新的控制器：<\/p>
php artisan make:controller RatingController<\/code><\/pre>
添加商店和更新方法：<\/p>
public function store(Request $request)\n{\n    \/\/ Validation and storage logic\n}\n\npublic function update(Rating $rating, Request $request)\n{\n    \/\/ Update logic\n}<\/code><\/pre>
刀模板和形式<\/h2>
设计一个Blade模板中的评分组件：<\/p>
<form method=\"POST\" action=\"{{ route('ratings.store') }}\">\n    @csrf\n    <div>\n        \/\/ Rating input elements\n    <\/div>\n    <button type=\"submit\">Submit Rating<\/button>\n<\/form><\/code><\/pre>
创建使用PUT方法的类似更新表单：<\/p>
<form method=\"POST\" action=\"{{ route('ratings.update', $rating) }}\">\n    @csrf\n    @method('PUT')\n    \/\/ Rating input elements for updating\n<\/form><\/code><\/pre>
在控制器中处理评分逻辑<\/h2>
在商店方法中，验证并保存评分：<\/p>
$request->validate(['rating' => 'required|integer|between:1,5']);\n$rating = new Rating($request->all());\n\/\/ Attach user ID to the rating\n$rating->user_id = auth()->id();\n$rating->save();\nreturn back()->with('message', 'Rating submitted successfully!');<\/code><\/pre>
在更新方法中，重用验证逻辑并更新：<\/p>
$request->validate(['rating' => 'required|integer|between:1,5']);\n$rating->update($request->all());\nreturn back()->with('message', 'Rating updated successfully!');<\/code><\/pre>
计算聚合评分<\/h2>
为了计算Post模型的平均评分：<\/p>
public function averageRating()\n{\n    return $this->ratings()->average('rating');\n}<\/code><\/pre>
显示 Blade 模板中的平均率：<\/p>
<p>Average Rating: {{ number_format($post->averageRating(), 1) }}<\/p><\/code><\/pre>
闭幕词<\/h2>
虽然简单，本教程介绍了使用Laravel的Eloquent ORM建立基础评分系统的步骤。进一步的复杂性可能涉及AJAX以提供无缝用户体验、对多个提交进行验证以及更复杂的用户界面元素如星级评分。然而，有了这个基础，有许多机会可以根据任何特定应用程序的需求进行扩展和定制。<\/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
要构建一个基于 Laravel 和 Eloquent 的评分系统，首先需要确保已经安装了 Laravel 以及相关的依赖包（如 Eloquent）。以下是一些基本的步骤来创建这样一个系统：<\/p>\n
    \n
  1. \n
    创建数据库模型（Score.php<\/code>）：<\/p>\n
    <?php\n\nnamespace App;\n\nuse IlluminateDatabaseEloquentModel;\n\nclass Score extends Model\n{\n   protected $fillable = ['user_id', 'product_id', 'rating'];\n\n   public function user() {\n       return $this->belongsTo('AppUser');\n   }\n\n   public function product() {\n       return $this->belongsTo('AppProduct');\n   }\n}<\/code><\/pre>\n<\/li>\n
  2. \n
    使用 Eloquent 完成评分数据的添加和更新操作：<\/p>\n
    <?php\n\nnamespace AppHttpControllers;\n\nuse AppScore;\nuse IlluminateHttpRequest;\n\nclass ScoreController extends Controller\n{\n   public function store(Request $request) {\n       $score = new Score();\n       $score->user_id = $request->input('user_id');\n       $score->product_id = $request->input('product_id');\n       $score->rating = $request->input('rating');\n\n       $score->save();\n\n       return redirect('\/')->with('success', 'Your score has been saved.');\n   }\n\n   public function update(Request $request, $id) {\n       $score = Score::find($id);\n\n       if ($score) {\n           $score->user_id = $request->input('user_id');\n           $score->product_id = $request->input('product_id');\n           $score->rating = $request->input('rating');\n\n           $score->save();\n\n           return redirect('\/')->with('success', 'Your score has been updated.');\n       } else {\n           return redirect('\/')->with('error', 'No score found with ID: ' . $id);\n       }\n   }\n}<\/code><\/pre>\n<\/li>\n
  3. \n
    添加路由：<\/p>\n
    <?php\n\nRoute::get('\/', function () {\n   return view('welcome');\n});\n\nRoute::resource('scores', 'ScoreController');<\/code><\/pre>\n<\/li>\n
  4. \n
    在控制器中处理用户请求：<\/p>\n
    <?php\n\nnamespace AppHttpControllers;\n\nuse AppScore;\nuse IlluminateHttpRequest;\n\nclass ScoreController extends Controller\n{\n   public function __construct()\n   {\n       $this->middleware('auth');\n   }\n\n   public function show($id)\n   {\n       $score = Score::findOrFail($id);\n       return view('show', compact('score'));\n   }\n}<\/code><\/pre>\n<\/li>\n
  5. \n
    部署到生产环境：<\/p>\n
      \n
    • 将项目打包为 Laravel 应用程序。<\/li>\n
    • 启动并访问应用程序。<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n
      以上就是在 Laravel + Eloquent 中构建评分系统的示例。通过这些步骤，你可以创建一个可以接受用户输入并保存评分的数据管理系统。<\/p>\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n<\/div>\n","protected":false},"excerpt":{"rendered":"
      Bug编译狮 标题：Laravel + Eloquent 构建评分系统 评分系统是..<\/p>\n","protected":false},"author":1,"featured_media":0,"menu_order":0,"template":"","meta":{"_acf_changed":false},"tags":[],"my1js2nav":[44],"tuisongtax":[],"class_list":["post-820","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\/820","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=820"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.zhaozhao123.cn\/php\/wp-json\/wp\/v2\/tags?post=820"},{"taxonomy":"my1js2nav","embeddable":true,"href":"https:\/\/www.zhaozhao123.cn\/php\/wp-json\/wp\/v2\/my1js2nav?post=820"},{"taxonomy":"tuisongtax","embeddable":true,"href":"https:\/\/www.zhaozhao123.cn\/php\/wp-json\/wp\/v2\/tuisongtax?post=820"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}