Basic Example

CREATETABLEusers (  idINTEGERPRIMARY KEY,   nameTEXT,   passwordTEXT );

/** * An ActiveRecord class is usually singular * * It's highly recommended to add the properties of the table as comments here * * @property int    $id * @property string $name * @property string $password */class Userextendsflight\ActiveRecord {publicfunction__construct($databaseConnection)  {parent::__construct($databaseConnection,'users', [/* custom values */]);  }}

// for sqlite$database_connection =newPDO('sqlite:test.db');// this is just for example, you'd probably use a real database connection// for mysql$database_connection =newPDO('mysql:host=localhost;dbname=test_db&charset=utf8bm4','username','password');// or mysqli$database_connection =newmysqli('localhost','username','password','test_db');// or mysqli with non-object based creation$database_connection =mysqli_connect('localhost','username','password','test_db');$user =newUser($database_connection);$user->name ='Bobby Tables';$user->password =password_hash('some cool password');$user->insert();// or $user->save();echo$user->id;// 1$user->name ='Joseph Mamma';$user->password =password_hash('some cool password again!!!');$user->insert();echo$user->id;// 2

$user->find(1);// find id = 1 in the database and return it.echo$user->name;// 'Bobby Tables'

$users =$user->findAll();

$users =$user->like('name','%mamma%')->findAll();

Installation

composerrequire flightphp/active-record

Documentation

License