Example
Create
-
$p->save(); # saves this post to the table
-
-
$p2 = new Post();
-
$p2->title = "Second Post";
-
$p2->body = "This is the body of the second post";
-
$p2->save(); # save yet another post to the db
Retrieve
-
$p = Post::find(1); # finds the post with an id = 1
-
$p->title; # title of this post
-
$p->body; # body of this post
-
-
# returns the 10 most recent posts in an array, assuming you have a column called "timestamp"
Update
-
$p = Post::find(1);
-
$p->title = "Some new title";
-
$p->save(); # saves the change to the post
-
-
# alternatively, the following is useful when a form submits an array
-
$p = Post::find(1);
-
$p->update_attributes($_POST[‘post’]); # saves the object with these attributes updated
Destroy
-
$p = Post::find(1);
-
$p->destroy();
Relationships
-
$p = Post::find(1);
-
# call to $p->comments results in query to get all comments for this post
-
# a subsequent call to $p->comments would not result in a query, but use results from previous query
-
foreach ($p->comments as $comment) {
-
}