Quick Start
Version 4 (Kien La, 2010-07-12 06:25 PM)
| 1 | 2 | Kien La |
h2. Quick Start |
|---|---|---|---|
| 2 | 1 | ||
| 3 | 1 |
This guide will show you the bare essentials to get up and running with php-activerecord. I will assume you have downloaded the library into your include_path in a directory called php-activerecord. |
|
| 4 | 1 | ||
| 5 | 1 |
The first steps are to include the library and define our database connection: |
|
| 6 | 1 | ||
| 7 | 3 | Kien La |
<pre class="code"><code class="php"> |
| 8 | 1 |
require_once 'php-activerecord/ActiveRecord.php'; |
|
| 9 | 1 | ||
| 10 | 1 |
ActiveRecord\Config::initialize(function($cfg) |
|
| 11 | 1 |
{
|
|
| 12 | 1 |
$cfg->set_model_directory('models');
|
|
| 13 | 1 |
$cfg->set_connections(array( |
|
| 14 | 1 |
'development' => 'mysql://username:password@localhost/database_name')); |
|
| 15 | 1 |
}); |
|
| 16 | 3 | Kien La |
</code></pre> |
| 17 | 1 | ||
| 18 | 1 |
Next, lets create a model for a table called users. We'll save this class in the file models/User.php |
|
| 19 | 1 | ||
| 20 | 3 | Kien La |
<pre class="code"><code class="php"> |
| 21 | 1 |
class User extends ActiveRecord\Model |
|
| 22 | 1 |
{
|
|
| 23 | 1 |
} |
|
| 24 | 3 | Kien La |
</code></pre> |
| 25 | 1 | ||
| 26 | 1 |
That's it! Now you can access the users table thru the User model. |
|
| 27 | 1 | ||
| 28 | 3 | Kien La |
<pre class="code"><code class="php"> |
| 29 | 1 |
# create Tito |
|
| 30 | 1 |
$user = User::create(array('name' => 'Tito', 'state' => 'VA'));
|
|
| 31 | 1 | ||
| 32 | 1 |
# read Tito |
|
| 33 | 1 |
$user = User::find_by_name('Tito');
|
|
| 34 | 1 | ||
| 35 | 1 |
# update Tito |
|
| 36 | 1 |
$user->name = 'Tito Jr'; |
|
| 37 | 1 |
$user->save(); |
|
| 38 | 1 | ||
| 39 | 1 |
# delete Tito |
|
| 40 | 1 |
$user->delete(); |
|
| 41 | 3 | Kien La |
</code></pre> |
| 42 | 1 | ||
| 43 | 4 | Kien La |
That's it! Pretty simple. Check out the [[Frameworks]] page for more in depth guides on setting up php-activerecord in specific frameworks. |
