Using ActiveRecord to manipulate data
ActiveRecord offers a convenient way to access and manipulate data stored in a database. This class is linked to a database table and represents a row of the linked table. Its attributes are the fields of the table and its methods allow us to perform common actions on database, such as selecting, inserting, or updating SQL statements.
Many common databases are supported by ActiveRecord, such as:
- MySQL
- PostgreSQL
- SQLite
- Oracle
- Microsoft SQL Server
Also, some NoSQL databases are supported, such as:
- Redis
- MongoDB
ActiveRecord reads the table structure every time it is instanced and makes available table columns as its properties. Every change to the table structure is immediately available in the ActiveRecord object.
Get Yii2 By Example now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.