PHPActiveRecord is an open source ORM library, largely based on Ruby on Rails' ActiveRecord.
This spark is used to easily integrate PHPActiveRecord into CodeIgniter 2.0+.
NOTE: PHPActiveRecord requires PHP5.3+, logging requires the PEAR Log library.
Navigate to the root of your CodeIgniter project and run
php tools/spark install php-activerecord
- Navigate to your CodeIgniter project's 'sparks' folder
- Extract the php-activerecord spark here, ensure it is named 'php-activerecord'
PHPActiveRecord will use the config/database.php file to determine your
database settings. It is capable of handling several connections, but will
default to your $active_group connection. You may change the connection any
model uses within the model itself.
PHPActiveRecord does not require you to define your database tables before use,
simply extend your model from the ActiveRecord\Model class and your model
will be ready for use (aside from any extra configuration you may want to add
later).
Examples, documentation, and help forums are available at http://phpactiverecord.org.
Create a table in your database named tests and give it some test
information, perhaps an id and a varchar column. Create at least one or two
records.
Create a new file in your models directory named 'Test.php'
Give model the following content:
<?php
class Test extends ActiveRecord\Model { }
Proceed to 'welcome.php' within your controllers directory
Within the index function, enter the following prior to the view being called
$this->load->spark('php-activerecord/0.0.2');
echo '<pre>'; var_dump(Test::all()); exit;
If you've followed the steps above, you should now see a print out of your object, with the class of your Model. Success! PHPActiveRecord is now ready for use!
If you'd like to enable logging and profiling, simply uncomment the
designated block from ./libraries/PHPActiveRecord.php beginning at
line 59.
If you use the Module Extensions HMVC, the model folders in each module will automatically be checked for models just as the regular model folder would.
PHPActiveRecord was created and is maintained by Kien La and Jacques Fuentes. I am not associated with the developers of this project, but love the work they've done and want to make it easily accessible to the CodeIgniter community.
This spark was created and is maintained by Matthew Machuga, is hosted on GitHub, and is made possible by the GetSparks team. Please support their project!