Laravel: Up & Running, 3rd Edition

Chapter 5. Databases and Eloquent

Laravel provides a suite of tools for interacting with your application’s databases, the most notable of which is Eloquent, Laravel’s ActiveRecord ORM.

Eloquent is one of Laravel’s most popular and influential features. It’s a great example of how Laravel is different from the majority of PHP frameworks; in a world of DataMapper ORMs that are powerful but complex, Eloquent stands out for its simplicity. There’s one class per table, which is responsible for retrieving, representing, and persisting data in that table.

Whether or not you choose to use Eloquent, you’ll still get a ton of benefit from the other database tools Laravel provides. So before we dig into Eloquent, we’ll start by covering the basics of Laravel’s database functionality: migrations, seeders, and the query builder.

Then we’ll cover Eloquent: defining your models; inserting, updating, and deleting; customizing your responses with accessors, mutators, and attribute casting; and, finally, relationships. There’s a lot going on here, and it’s easy to get overwhelmed, but if we take it one step at a time, we’ll make it through.

Configuration

Before we get into how to use Laravel’s database tools, let’s pause for a second and go over how to configure your database credentials and connections.

The configuration for database access lives in config/database.php and .env. Like many other configuration areas in Laravel, you can define multiple “connections” and then decide which the code ...