Download the PHP package rdx/db without Composer
On this page you can find all versions of the php package rdx/db. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
Informations about the package db
The most elegant, simple, beautiful DBAL ever.
Drivers / adapters / databases
- SQLite 3 (via PDO)
- MySQLi
No SQLite 2 or procedural MySQL. What is it, 2003?
Where to start
Check out the test/
folder. It contains a few simple tests/examples.
Check out the projects where it's used. A powerful, very useful feature is the schema 'sync': create tables, columns, indexes, relations and fixtures, all in 1 clean array.
Do it! You can create other drivers. Just extend db_generic
and
db_generic_result
. You can call it db_pgsql
=) NoSQL won't work, because
there's no Query builder (and there won't be).
Show me examples!
Okay.
Simple select. Will return an Iterable.
$users = $db->select('users', 'lastname <> ?', array("De'sander"));
print_r($users); // NOT a list of users
Get the first result object.
$user = $users->nextObject();
var_dump($user->lastname);
Do a GROUP BY and get a 2D array.
$users_by_lastname = $db->select_fields('users', 'lastname, COUNT(1)', 'active = ? GROUP BY lastname', array(1));
var_dump($users_by_lastname["De'sander"]);
Another one. Perfect for HTML <option>
s.
$options = $db->select_fields('countries', 'code, name', array('active' => 1));
Return objects in a different class. Voila, Active Records. Use ->all()
to fetch all objects.
$sessions = $db->fetch('SELECT s.* from sessions s, people p WHERE p.access_level = ? AND p.id = s.person_id', array(
'params' => array(4),
'class' => 'UserSession',
))->all();
var_dump(get_class($sessions[0])); // UserSession
More advanced conditions.
$people = $db->select('people', array(
// Conditions
'enabled' => 1,
'age >= ?',
'age <= ?',
'lastname <> ?',
'(a < b OR b IS NULL)'
), array(
// Params
18,
65,
"De'sander",
));
And ofcourse there's updating and inserting etc.
$bool = $db->update('people', array('enabled' => 0), array(
'last_login' => 0,
'favourite_pizza IS NULL',
));
$affected = $db->affected_rows();
$bool = $db->insert('people', array(
'name' => 'De Rudie',
'awesomeness' => true,
'favourite_pizza' => null,
));
$pk = $db->insert_id();
Active Record Models
You can create models by extending db_generic_model
:
class User extends db_generic_model {
static public $_table = 'users';
}
And then make all procedures easier:
$user = User::find(12); // User|null
$user = User::first(['username' => 'sander']); // User|null
$users = User::all(['country_id' => 12]); // User[]
All objects are statically cached, so calling find(X)
6 times, takes it from the cache 5 times.
Do active things to active objects:
$user->update(['disabled' => true]);
$user->delete();
Or without the objects:
User::updateAll(['disabled' => true], ['username' => 'sander']);
User::deleteAll(['disabled' => true]);
Add dynamic properties with get_NAME()
.
class User extends db_generic_model {
function get_fullname() {
return "$this->firstname $this->lastname";
}
}
echo $user->fullname;
Properties are cached in the object, so the getter is called only once.
Add relationships with relate_NAME()
:
class User extends db_generic_model {
function relate_country() {
return $this->to_one(Country::class, 'country_id');
}
function relate_hobbies() {
return $this->to_many(Hobby::class, 'user_id');
}
function relate_groups() {
return $this->to_many_through(Group::class, 'users_groups', 'user_id', 'group_id');
}
function relate_num_groups() {
return $this->to_count(UserGroup::class, 'user_id');
}
function relate_group_ids() {
return $this->to_many_scalar('group_id', 'users_groups', 'user_id');
}
}
echo $user->country->name;
print_r($user->hobbies);
print_r($user->groups);
echo $user->num_groups;
print_r($user->group_ids);
All primary keys must be id
. Foreign keys can be anything.