Working with databases in Laravel is ridiculously easy thanks to Eloquent. Eloquent allows you to map database tables as simple model objects that include various methods for retrieving and updating the database. While working on other people’s code, however, I’m usually not lucky enough to be working with something as enjoyable as Laravel. Thankfully Laravel is written in such a way that some of it’s key components can be used as stand-alone modules.

Using Laravel’s database magic in your own projects is pretty simple. First you need to make sure you have all the required components included in your project. Currently Laravel 4 is the latest version and it’s codename is “Illuminate”. It’s database component is therefore called “Illuminate\Database”. The easiest way to grab “Illuminate\Database” and it’s dependencies is to use Composer.

Make sure there is file called ‘composer.json’ in your project that contains the following:

{ "require": { "illuminate/database": "*" } }

Now run:

$ composer install

In order to start using Eloquent let’s create a file called database.php to include in our various project files.

<?php require 'vendor/autoload.php'; use Illuminate\Database\Capsule\Manager as Capsule; $capsule = new Capsule; $capsule->addConnection(array( 'driver' => 'mysql', 'host' => 'localhost', 'database' => 'test', 'username' => 'test', 'password' => 'l4m3p455w0rd!', 'charset' => 'utf8', 'collation' => 'utf8_unicode_ci', 'prefix' => '' )); $capsule->bootEloquent();

Now we can start working with database tables just like we would if we were using Laravel!

<?php include 'database.php'; // Create the Books model class Books extends Illuminate\Database\Eloquent\Model { public $timestamps = false; } // Grab a book with an id of 1 $book = Books::find(1); // Change some stuff $book->name = "The Best Book in the World"; $book->author = "Ed Zynda"; // Save it to the database $book->save();

Check out the Laravel documentation for more information on working with Eloquent.