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.

FAQ

After the download, you have to make one include require_once('vendor/autoload.php');. After that you have to import the classes with use statements.

Example:
If you use only one package a project is not needed. But if you use more then one package, without a project it is not possible to import the classes with use statements.

In general, it is recommended to use always a project to download your libraries. In an application normally there is more than one library needed.
Some PHP packages are not free to download and because of that hosted in private repositories. In this case some credentials are needed to access such packages. Please use the auth.json textarea to insert credentials, if a package is coming from a private repository. You can look here for more information.

  • Some hosting areas are not accessible by a terminal or SSH. Then it is not possible to use Composer.
  • To use Composer is sometimes complicated. Especially for beginners.
  • Composer needs much resources. Sometimes they are not available on a simple webspace.
  • If you are using private repositories you don't need to share your credentials. You can set up everything on our site and then you provide a simple download link to your team member.
  • Simplify your Composer build process. Use our own command line tool to download the vendor folder as binary. This makes your build process faster and you don't need to expose your credentials for private repositories.
Please rate this library. Is it a good library?

Informations about the package db

The most elegant, simple, beautiful DBAL ever.

Drivers / adapters / databases

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.


All versions of db with dependencies

PHP Build Version
Package Version
No informations.
Composer command for our command line client (download client) This client runs in each environment. You don't need a specific PHP version etc. The first 20 API calls are free. Standard composer command

The package rdx/db contains the following files

Loading the files please wait ....