Yii 2.0 ActiveRecord: A Deep Dive into Object-Relational Mapping
Yii 2.0's ActiveRecord provides a robust Object-Relational Mapping (ORM) interface, simplifying database interactions. This approach, common in frameworks like Laravel and Ruby on Rails, offers features like mass assignment, validation, and scenario-based behavior. Let's explore its capabilities and advanced features.
Core Functionality (Inherited from yiibaseModel):
-
Attributes: Model data is stored in publicly accessible attributes. Mass assignment is facilitated by assigning arrays to the
attributes
property, leveraging the__set()
andsetAttributes()
methods inherited fromyiibaseComponent
. Attribute retrieval similarly uses__get()
andgetAttributes()
. Attribute labels, crucial for user interfaces, are defined for display purposes. -
Validation: The
rules()
method defines validation rules for attributes, ensuring data integrity. By default, only "safe" attributes (those with defined validation rules) are mass-assignable. -
Scenarios: Scenarios allow defining different validation and data handling rules depending on the context (e.g., registration vs. login). This enhances flexibility and maintainability.
Creating an ActiveRecord Model:
The example uses a simple blog structure (see image above). The Articles
model, generated using Gii, demonstrates the basic structure:
namespace app\models; use Yii; class Articles extends \yii\db\ActiveRecord { // ... (tableName(), rules(), attributeLabels() as shown in the original text) ... public function getAuthors() { return $this->hasOne(Authors::className(), ['ID' => 'AuthorsID']); } public function getArticlestags() { return $this->hasMany(Articlestags::className(), ['ArticlesID' => 'ID']); } public function getTags() { return $this->hasMany(Tags::className(), ['ID' => 'TagsID']) ->viaTable(Articlestags::tableName(), ['ArticlesID' => 'ID']); } }
Note the addition of the getTags()
method, which defines the many-to-many relationship with Tags
via the Articlestags
junction table.
Advanced Usage:
Yii 2.0 ActiveRecord enhances the base functionality with several advanced features:
-
Dirty Attributes: Track changes to model attributes using
getDirtyAttributes()
,isAttributeChanged()
, andmarkAttributeDirty()
. This is invaluable for efficiently updating database records. -
Arrayable: The
toArray()
method, inherited via theArrayable
trait, converts the model to an array.fields()
andextraFields()
allow customizing the array's content, including calculated fields. For example, adding a comma-separated string of tags:
namespace app\models; use Yii; class Articles extends \yii\db\ActiveRecord { // ... (tableName(), rules(), attributeLabels() as shown in the original text) ... public function getAuthors() { return $this->hasOne(Authors::className(), ['ID' => 'AuthorsID']); } public function getArticlestags() { return $this->hasMany(Articlestags::className(), ['ArticlesID' => 'ID']); } public function getTags() { return $this->hasMany(Tags::className(), ['ID' => 'TagsID']) ->viaTable(Articlestags::tableName(), ['ArticlesID' => 'ID']); } }
- Events: ActiveRecord triggers events at various stages of its lifecycle (e.g.,
beforeValidate()
,afterSave()
). These allow customizing behavior without modifying core model code. For example, automatically updatingLastEdited
:
public function extraFields() { return [ 'tagsString' => function () { return implode(', ', array_map(function ($tag) { return $tag->Tag; }, $this->tags)); }, ]; }
- Behaviors: Behaviors add functionality to models without modifying their code. Yii provides built-in behaviors like
BlameableBehavior
(tracking creators/updaters) andTimestampBehavior
(automatic timestamps). Attaching these behaviors:
public function beforeValidate() { $this->LastEdited = new \yii\db\Expression('NOW()'); return parent::beforeValidate(); }
-
Transactional Operations: The
transactions()
method defines which operations should be wrapped in database transactions, ensuring data consistency.
Conclusion:
Yii 2.0 ActiveRecord provides a powerful and flexible ORM, significantly simplifying database interactions. The advanced features, including dirty attributes, events, behaviors, and transactional operations, enhance its capabilities and adaptability to complex scenarios. This detailed exploration highlights its strengths and demonstrates how to leverage its full potential.
The above is the detailed content of Yii 2.0 ActiveRecord Explained. For more information, please follow other related articles on the PHP Chinese website!

Hot AI Tools

Undress AI Tool
Undress images for free

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

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

ArtGPT
AI image generator for creative art from text prompts.

Stock Market GPT
AI powered investment research for smarter decisions

Hot Article

Hot Tools

Notepad++7.3.1
Easy-to-use and free code editor

SublimeText3 Chinese version
Chinese version, very easy to use

Zend Studio 13.0.1
Powerful PHP integrated development environment

Dreamweaver CS6
Visual web development tools

SublimeText3 Mac version
God-level code editing software (SublimeText3)

Hot Topics



PHParrayshandledatacollectionsefficientlyusingindexedorassociativestructures;theyarecreatedwitharray()or[],accessedviakeys,modifiedbyassignment,iteratedwithforeach,andmanipulatedusingfunctionslikecount(),in_array(),array_key_exists(),array_push(),arr

TheObserverdesignpatternenablesautomaticnotificationofdependentobjectswhenasubject'sstatechanges.1)Itdefinesaone-to-manydependencybetweenobjects;2)Thesubjectmaintainsalistofobserversandnotifiesthemviaacommoninterface;3)Observersimplementanupdatemetho

$_COOKIEisaPHPsuperglobalforaccessingcookiessentbythebrowser;cookiesaresetusingsetcookie()beforeoutput,readvia$_COOKIE['name'],updatedbyresendingwithnewvalues,anddeletedbysettinganexpiredtimestamp,withsecuritybestpracticesincludinghttponly,secureflag

Useinterfacestodefinecontractsforunrelatedclasses,ensuringtheyimplementspecificmethods;2.Useabstractclassestosharecommonlogicamongrelatedclasseswhileenforcinginheritance;3.Usetraitstoreuseutilitycodeacrossunrelatedclasseswithoutinheritance,promotingD

B-TreeindexesarebestformostPHPapplications,astheysupportequalityandrangequeries,sorting,andareidealforcolumnsusedinWHERE,JOIN,orORDERBYclauses;2.Full-Textindexesshouldbeusedfornaturallanguageorbooleansearchesontextfieldslikearticlesorproductdescripti

Public members can be accessed at will; 2. Private members can only be accessed within the class; 3. Protected members can be accessed in classes and subclasses; 4. Rational use can improve code security and maintainability.

Usedate('Y-m-dH:i:s')withdate_default_timezone_set()togetcurrentdateandtimeinPHP,ensuringaccurateresultsbysettingthedesiredtimezonelike'America/New_York'beforecallingdate().

Using MySQLi object-oriented method: establish a connection, preprocess UPDATE statements, bind parameters, execute and check the results, and finally close the resource. 2. Using MySQLi procedure method: connect to the database through functions, prepare statements, bind parameters, perform updates, and close the connection after processing errors. 3. Use PDO: Connect to the database through PDO, set exception mode, pre-process SQL, bind parameters, perform updates, use try-catch to handle exceptions, and finally release resources. Always use preprocessing statements to prevent SQL injection, verify user input, and close connections in time.
