Basic Usagelink to this

Load a new model instancelink to this

To create a new Model_User instance, you can do one of two things:

?
$user = ORM::factory('user');
// Or
$user = new Model_User();

Insertinglink to this

To insert a new record into the database, create a new instance of the model:

?
$user = ORM::factory('user');

Then, assign values for each of the properties;

?
$user->first_name = 'Trent';
$user->last_name = 'Reznor';
$user->city = 'Mercer';
$user->state = 'PA';

Insert the new record into the database by running ORM::save:

?
$user->save();

ORM::save checks to see if a value is set for the primary key (id by default). If the primary key is set, then ORM will execute an UPDATE otherwise it will execute an INSERT.

Finding an objectlink to this

To find an object you can call the ORM::find method or pass the id into the ORM constructor:

?
// Find user with ID 20
$user = ORM::factory('user')
    ->where('id', '=', 20)
    ->find();
// Or
$user = ORM::factory('user', 20);

Check that ORM loaded a recordlink to this

Use the ORM::loaded method to check that ORM successfully loaded a record.

?
if ($user->loaded())
{
    // Load was successful
}
else
{
    // Error
}

Updating and Savinglink to this

Once an ORM model has been loaded, you can modify a model's properties like this:

?
$user->first_name = "Trent";
$user->last_name = "Reznor";

And if you want to save the changes you just made back to the database, just run a save() call like this:

?
$user->save();

Deletinglink to this

To delete an object, you can call the ORM::delete method on a loaded ORM model.

?
$user = ORM::factory('user', 20);
$user->delete();