这篇文章主要介绍了关于Laravel之Eloquent ORM ,有着一定的参考价值,现在分享给大家,有需要的朋友可以参考一下
一、ORM编程思想
1.1 Active Record 设计模式
Active Record
是一种数据访问设计模式,它可以帮助你实现数据对象Object
到关系数据库的映射。应用Active Record
时,每一个类的实例对象唯一对应一个数据库表的一行(一对一关系)。你只需继承一个abstract Active Record
类就可以使用该设计模式访问数据库,其最大的好处是使用非常简单
1.2 调试工具 Laravel Debugbar
https://github.com/barryvdh/l...
Installation:
composer require barryvdh/laravel-debugbar --dev
二、一对一关系映射
2.1 创建表
public function up() { Schema::create('profiles', function (Blueprint $table) { $table->increments('id'); $table->string('phone'); $table->unsignedInteger('user_id'); //显示的声明外键:通知数据库根据外键关联表和建立索引,提高运行速度 $table->foreign('user_id') ->references('id') ->on('users') ->onDelete('cascade'); $table->timestamps(); }); }
2.2 创建模型关系
2.2.1 正向关系绑定
public function profile() { return $this->hasOne(Profile::class); }
2.2.2 反向关系绑定
public function user() { return $this->belongsTo(User::class); }
2.3 外键
自定义外键:
return $this->hasOne(Profile::class,'显示指定自定义外键');
2.4 一对一测试
依赖注入Request $request
,获取当前登录用户$request->user()
Route::get('/test',function (Request $request){ //反向 // $profile = \App\Profile::find(1); // dd($profile->user); $user = $request->user(); // if (is_null($user->profile)){ // $user->profile()->create([ // 'phone' => '15801340269' // ]); // } //用firstOrCreate改进if $user->profile()->firstOrCreate(['user_id' => $user->id],[ 'phone' => '18363046291' ]); //访问属性一样访问方法 dd($user->profile); });
三、一对多关系映射
1:N hasMany(XXX:class) 反之:belongsTo(XXX:class)
3.1 面向对象方式绑定一对多的关系
四、多对多关系映射
中间表命名:按照A-Z
首字母排序
public function users() { return $this->belongsToMany(User::class); } public function habits() { return $this->belongsToMany(Habit::class); }
4.1 面向对象方式绑定多对多的关系
detach解绑,sync方法用的比较多,只保留1,2
4.2 访问多对多中间数据表
五、HasManyThrough对象桥接式穿越关联(远层一对多)
数据表:
countries id - integer name - string users id - integer country_id - integer name - string posts id - integer user_id - integer title - string
class Country extends Model { protected $fillable = ['name']; /** * 获得某个国家下所有的用户文章。 */ public function papers() { return $this->hasManyThrough(Paper::class,User::class); } }
$factory->define(App\Paper::class, function (Faker $faker) { return [ 'title' => $faker->sentence, 'user_id' => \App\User::all()->random()->id, ]; });
$factory->define(App\User::class, function (Faker $faker) { return [ 'name' => $faker->name, 'email' => $faker->unique()->safeEmail, 'country_id' => \App\Country::all()->random()->id, 'password' => '$2y$10$TKh8H1.PfQx37YgCzwiKb.KjNyWgaHb9cbcoQgpFlYg7B77UdFm', // secret 'remember_token' => str_random(10), ]; });
获取每个国家论文总数:
五、多样化的一对多关系映射(多态关联)
面向对象多态:运行时加载机制
更多:https://laravel-china.org/doc...
伪造数据:
6. Many-to-Many Polymorphic Association
In addition to traditional polymorphic associations, you can also define "many-to-many" polymorphic associations. For example, the Post
model and the Video
model can share a polymorphic association to the Tag
model. Using a many-to-many polymorphic association allows you to share a unique list of tags across articles and videos.
More: https://laravel-china.org/doc...
The above is the entire content of this article. I hope it will be helpful to everyone's study. For more related content, please pay attention to PHP Chinese net!
Related recommendations:
Detailed explanation of the responsive interface provided in Laravel 5.5 for responding to requests
About Laravel basic Migrations Analysis
The above is the detailed content of Analysis of Laravel's Eloquent ORM. For more information, please follow other related articles on the PHP Chinese website!

TomakePHPapplicationsfaster,followthesesteps:1)UseOpcodeCachinglikeOPcachetostoreprecompiledscriptbytecode.2)MinimizeDatabaseQueriesbyusingquerycachingandefficientindexing.3)LeveragePHP7 Featuresforbettercodeefficiency.4)ImplementCachingStrategiessuc

ToimprovePHPapplicationspeed,followthesesteps:1)EnableopcodecachingwithAPCutoreducescriptexecutiontime.2)ImplementdatabasequerycachingusingPDOtominimizedatabasehits.3)UseHTTP/2tomultiplexrequestsandreduceconnectionoverhead.4)Limitsessionusagebyclosin

Dependency injection (DI) significantly improves the testability of PHP code by explicitly transitive dependencies. 1) DI decoupling classes and specific implementations make testing and maintenance more flexible. 2) Among the three types, the constructor injects explicit expression dependencies to keep the state consistent. 3) Use DI containers to manage complex dependencies to improve code quality and development efficiency.

DatabasequeryoptimizationinPHPinvolvesseveralstrategiestoenhanceperformance.1)Selectonlynecessarycolumnstoreducedatatransfer.2)Useindexingtospeedupdataretrieval.3)Implementquerycachingtostoreresultsoffrequentqueries.4)Utilizepreparedstatementsforeffi

PHPisusedforsendingemailsduetoitsbuilt-inmail()functionandsupportivelibrarieslikePHPMailerandSwiftMailer.1)Usethemail()functionforbasicemails,butithaslimitations.2)EmployPHPMailerforadvancedfeatureslikeHTMLemailsandattachments.3)Improvedeliverability

PHP performance bottlenecks can be solved through the following steps: 1) Use Xdebug or Blackfire for performance analysis to find out the problem; 2) Optimize database queries and use caches, such as APCu; 3) Use efficient functions such as array_filter to optimize array operations; 4) Configure OPcache for bytecode cache; 5) Optimize the front-end, such as reducing HTTP requests and optimizing pictures; 6) Continuously monitor and optimize performance. Through these methods, the performance of PHP applications can be significantly improved.

DependencyInjection(DI)inPHPisadesignpatternthatmanagesandreducesclassdependencies,enhancingcodemodularity,testability,andmaintainability.Itallowspassingdependencieslikedatabaseconnectionstoclassesasparameters,facilitatingeasiertestingandscalability.

CachingimprovesPHPperformancebystoringresultsofcomputationsorqueriesforquickretrieval,reducingserverloadandenhancingresponsetimes.Effectivestrategiesinclude:1)Opcodecaching,whichstorescompiledPHPscriptsinmemorytoskipcompilation;2)DatacachingusingMemc


Hot AI Tools

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Undress AI Tool
Undress images for free

Clothoff.io
AI clothes remover

Video Face Swap
Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Article

Hot Tools

EditPlus Chinese cracked version
Small size, syntax highlighting, does not support code prompt function

SublimeText3 English version
Recommended: Win version, supports code prompts!

PhpStorm Mac version
The latest (2018.2.1) professional PHP integrated development tool

Dreamweaver Mac version
Visual web development tools

Safe Exam Browser
Safe Exam Browser is a secure browser environment for taking online exams securely. This software turns any computer into a secure workstation. It controls access to any utility and prevents students from using unauthorized resources.
