entraigas/slimdb

Slim Database, a wrapper around pdo

SlimDb

Small db layer around the PDO and PDO statement., _(*1)

The package goal used to be small and handy, with the basic, commonly used db functions (like select, update, insert and delete). Now it's more ambitious, and it's no so small and basic. Note: there's only support for mysql and sqlite., _(*2)

Installing the package

You can download the package directly from GitHub Or install it using composer.json file, _(*3)

{
    "require": {
        "entraigas/slimdb": "v1.2.1"
    }
}

Db Setup

The configuration it's done using arrays. In this example, there are two db settings: * the first has 'portal' as connection name, and it's a mysql db. * the second has 'admin' as connection name, and it's a sqlite db., _(*4)

Finally, there is a 'default' connection name configured with the 'portal' value., _(*5)

//database configuration array
$portal => array(
    'driver' => 'mysql',
    'getPdo' => function(){
            //validate PDO extensions
            if (!defined('\PDO::ATTR_DRIVER_NAME')) return false; //PDO is not available
            if (!extension_loaded('pdo_mysql')) return false; //pdo_mysql extension not loaded
            //make connection
            $pdo = new \PDO("mysql:host=127.0.0.1;port=3306;dbname=testdb", 'user', 'password');
            //default connection settings
            $pdo->setAttribute(\PDO::ATTR_ERRMODE, \PDO::ERRMODE_EXCEPTION);
            $pdo->query("SET NAMES 'utf8'");
            //done, return pdo object
            return $pdo;
        }
);
$admin => array(
    'driver' => 'sqlite',
    'getPdo' => function(){
            //validate PDO extensions
            if (!defined('\PDO::ATTR_DRIVER_NAME')) return false; //PDO is not available
            if (!extension_loaded('pdo_sqlite')) return false; //pdo_sqlite extension not loaded
            //make connection
            $pdo = new \PDO("sqlite:/path/to/database.db");
            //default connection settings
            $pdo->setAttribute(\PDO::ATTR_ERRMODE, \PDO::ERRMODE_EXCEPTION);
            //done, return pdo object
            return $pdo;
        }
);


//initialize SlimDb
\SlimDb\SlimDb::configure('portal', $portal);
\SlimDb\SlimDb::configure('admin', $admin);

//set the default connection
\SlimDb\SlimDb::setDefaultConnection('portal');

There are many classes bundled with the package. Depending on what you are trying to do, you should use one over the other. Here is a list:, _(*6)

• Running raw queries: SlimDb or Database classes
• Fetching data: ResultSet class
• Working with Tables
• Working with Orm