2017 © Pedro Peláez
 

library php-activerecord

php-activerecord is an open source ORM library based on the ActiveRecord pattern.

image

zamzar/php-activerecord

php-activerecord is an open source ORM library based on the ActiveRecord pattern.

  • Thursday, July 26, 2018
  • by louismrose
  • Repository
  • 1 Watchers
  • 2 Stars
  • 3,581 Installations
  • PHP
  • 0 Dependents
  • 0 Suggesters
  • 411 Forks
  • 2 Open issues
  • 23 Versions
  • 16 % Grown

The README.md

PHP ActiveRecord - Version 1.0

Build Status, (*1)

by, (*2)

http://www.phpactiverecord.org/, (*3)

Introduction

A brief summarization of what ActiveRecord is:, (*4)

Active record is an approach to access data in a database. A database table or view is wrapped into a class, thus an object instance is tied to a single row in the table. After creation of an object, a new row is added to the table upon save. Any object loaded gets its information from the database; when an object is updated, the corresponding row in the table is also updated. The wrapper class implements accessor methods or properties for each column in the table or view., (*5)

More details can be found here., (*6)

This implementation is inspired and thus borrows heavily from Ruby on Rails' ActiveRecord. We have tried to maintain their conventions while deviating mainly because of convenience or necessity. Of course, there are some differences which will be obvious to the user if they are familiar with rails., (*7)

Minimum Requirements

  • PHP 5.3+
  • PDO driver for your respective database

Supported Databases

  • MySQL
  • SQLite
  • PostgreSQL
  • Oracle

Features

  • Finder methods
  • Dynamic finder methods
  • Writer methods
  • Relationships
  • Validations
  • Callbacks
  • Serializations (json/xml)
  • Transactions
  • Support for multiple adapters
  • Miscellaneous options such as: aliased/protected/accessible attributes

Installation

Setup is very easy and straight-forward. There are essentially only two configuration points you must concern yourself with:, (*8)

  1. Configuring your database connections.
  2. Setting the database connection to use for your environment.

Example:, (*9)

ActiveRecord\Config::initialize(function($cfg)
{
   $cfg->set_connections(
     array(
       'development' => 'mysql://username:password@localhost/development_database_name',
       'test' => 'mysql://username:password@localhost/test_database_name',
       'production' => 'mysql://username:password@localhost/production_database_name'
     )
   );
});

Alternatively (w/o the 5.3 closure):, (*10)

$cfg = ActiveRecord\Config::instance();
$cfg->set_connections(
  array(
    'development' => 'mysql://username:password@localhost/development_database_name',
    'test' => 'mysql://username:password@localhost/test_database_name',
    'production' => 'mysql://username:password@localhost/production_database_name'
  )
);

PHP ActiveRecord will default to use your development database. For testing or production, you simply set the default connection according to your current environment ('test' or 'production'):, (*11)

ActiveRecord\Config::initialize(function($cfg)
{
  $cfg->set_default_connection(your_environment);
});

Once you have configured these three settings you are done. ActiveRecord takes care of the rest for you. It does not require that you map your table schema to yaml/xml files. It will query the database for this information and cache it so that it does not make multiple calls to the database for a single schema., (*12)

Basic CRUD

Retrieve

These are your basic methods to find and retrieve records from your database. See the Finders section for more details., (*13)

$post = Post::find(1);
echo $post->title; # 'My first blog post!!'
echo $post->author_id; # 5

# also the same since it is the first record in the db
$post = Post::first();

# finding using dynamic finders
$post = Post::find_by_name('The Decider');
$post = Post::find_by_name_and_id('The Bridge Builder',100);
$post = Post::find_by_name_or_id('The Bridge Builder',100);

# finding using a conditions array
$posts = Post::find('all',array('conditions' => array('name=? or id > ?','The Bridge Builder',100)));

Create

Here we create a new post by instantiating a new object and then invoking the save() method., (*14)

$post = new Post();
$post->title = 'My first blog post!!';
$post->author_id = 5;
$post->save();
# INSERT INTO `posts` (title,author_id) VALUES('My first blog post!!', 5)

Update

To update you would just need to find a record first and then change one of its attributes. It keeps an array of attributes that are "dirty" (that have been modified) and so our sql will only update the fields modified., (*15)

$post = Post::find(1);
echo $post->title; # 'My first blog post!!'
$post->title = 'Some real title';
$post->save();
# UPDATE `posts` SET title='Some real title' WHERE id=1

$post->title = 'New real title';
$post->author_id = 1;
$post->save();
# UPDATE `posts` SET title='New real title', author_id=1 WHERE id=1

Delete

Deleting a record will not destroy the object. This means that it will call sql to delete the record in your database but you can still use the object if you need to., (*16)

$post = Post::find(1);
$post->delete();
# DELETE FROM `posts` WHERE id=1
echo $post->title; # 'New real title'

Contributing

Please refer to CONTRIBUTING.md for information on how to contribute to PHP ActiveRecord., (*17)

The Versions

26/07 2018

dev-master

9999999-dev http://www.phpactiverecord.org/

php-activerecord is an open source ORM library based on the ActiveRecord pattern.

  Sources   Download

MIT

The Requires

  • php >=5.3.0

 

The Development Requires

orm activerecord

26/07 2018

v1.4.6

1.4.6.0 http://www.phpactiverecord.org/

php-activerecord is an open source ORM library based on the ActiveRecord pattern.

  Sources   Download

MIT

The Requires

  • php >=5.3.0

 

The Development Requires

orm activerecord

22/03 2018

v1.4.5

1.4.5.0 http://www.phpactiverecord.org/

php-activerecord is an open source ORM library based on the ActiveRecord pattern.

  Sources   Download

MIT

The Requires

  • php >=5.3.0

 

The Development Requires

orm activerecord

22/03 2018

dev-drop-connection

dev-drop-connection http://www.phpactiverecord.org/

php-activerecord is an open source ORM library based on the ActiveRecord pattern.

  Sources   Download

MIT

The Requires

  • php >=5.3.0

 

The Development Requires

orm activerecord

07/03 2018

1.0rc1

1.0.0.0-RC1

  Sources   Download

07/03 2018

v1.1

1.1.0.0

  Sources   Download

07/03 2018

1.0

1.0.0.0

  Sources   Download

11/01 2017

v1.4.4

1.4.4.0 http://www.phpactiverecord.org/

php-activerecord is an open source ORM library based on the ActiveRecord pattern.

  Sources   Download

MIT

The Requires

  • php >=5.3.0

 

The Development Requires

orm activerecord

11/01 2017

v1.3.5

1.3.5.0 http://www.phpactiverecord.org/

php-activerecord is an open source ORM library based on the ActiveRecord pattern.

  Sources   Download

MIT

The Requires

  • php >=5.3.0

 

The Development Requires

orm activerecord

16/12 2016

v1.4.3

1.4.3.0 http://www.phpactiverecord.org/

php-activerecord is an open source ORM library based on the ActiveRecord pattern.

  Sources   Download

MIT

The Requires

  • php >=5.3.0

 

The Development Requires

orm activerecord

16/12 2016

1.3.x-dev

1.3.9999999.9999999-dev http://www.phpactiverecord.org/

php-activerecord is an open source ORM library based on the ActiveRecord pattern.

  Sources   Download

MIT

The Requires

  • php >=5.3.0

 

The Development Requires

orm activerecord

16/12 2016

v1.3.4

1.3.4.0 http://www.phpactiverecord.org/

php-activerecord is an open source ORM library based on the ActiveRecord pattern.

  Sources   Download

MIT

The Requires

  • php >=5.3.0

 

The Development Requires

orm activerecord

16/12 2016

v1.4.2

1.4.2.0 http://www.phpactiverecord.org/

php-activerecord is an open source ORM library based on the ActiveRecord pattern.

  Sources   Download

MIT

The Requires

  • php >=5.3.0

 

The Development Requires

orm activerecord

16/12 2016

v1.3.3

1.3.3.0 http://www.phpactiverecord.org/

php-activerecord is an open source ORM library based on the ActiveRecord pattern.

  Sources   Download

MIT

The Requires

  • php >=5.3.0

 

The Development Requires

orm activerecord

16/12 2016

v1.4.1

1.4.1.0 http://www.phpactiverecord.org/

php-activerecord is an open source ORM library based on the ActiveRecord pattern.

  Sources   Download

MIT

The Requires

  • php >=5.3.0

 

The Development Requires

orm activerecord

16/12 2016

v1.3.2

1.3.2.0 http://www.phpactiverecord.org/

php-activerecord is an open source ORM library based on the ActiveRecord pattern.

  Sources   Download

MIT

The Requires

  • php >=5.3.0

 

The Development Requires

orm activerecord

12/12 2016

v1.4.0

1.4.0.0 http://www.phpactiverecord.org/

php-activerecord is an open source ORM library based on the ActiveRecord pattern.

  Sources   Download

MIT

The Requires

  • php >=5.3.0

 

The Development Requires

orm activerecord

01/12 2016

v1.3.1

1.3.1.0 http://www.phpactiverecord.org/

php-activerecord is an open source ORM library based on the ActiveRecord pattern.

  Sources   Download

MIT

The Requires

  • php >=5.3.0

 

The Development Requires

orm activerecord

31/10 2016

v1.3.0

1.3.0.0 http://www.phpactiverecord.org/

php-activerecord is an open source ORM library based on the ActiveRecord pattern.

  Sources   Download

MIT

The Requires

  • php >=5.3.0

 

The Development Requires

orm activerecord

30/09 2016

v1.2.0

1.2.0.0 http://www.phpactiverecord.org/

php-activerecord is an open source ORM library based on the ActiveRecord pattern.

  Sources   Download

MIT

The Requires

  • php >=5.3.0

 

The Development Requires

orm activerecord

05/07 2016

dev-issue546

dev-issue546 http://www.phpactiverecord.org/

php-activerecord is an open source ORM library based on the ActiveRecord pattern.

  Sources   Download

MIT

The Requires

  • php >=5.3.0

 

The Development Requires

orm activerecord

26/04 2013

v1.1.2

1.1.2.0 http://www.phpactiverecord.org/

php-activerecord is an open source ORM library based on the ActiveRecord pattern.

  Sources   Download

MIT

The Requires

  • php >=5.3.0

 

orm activerecord

28/02 2013

v1.1.1

1.1.1.0 http://www.phpactiverecord.org/

php-activerecord is an open source ORM library based on the ActiveRecord pattern.

  Sources   Download

MIT

The Requires

  • php >=5.3.0

 

orm activerecord