Download the PHP package entraigas/slimdb without Composer
On this page you can find all versions of the php package entraigas/slimdb. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
Download entraigas/slimdb
More information about entraigas/slimdb
Files in entraigas/slimdb
Package slimdb
Short Description Slim Database, a wrapper around pdo
License MIT
Homepage http://github.com/entraigas/SlimDb
FAQ
Example:
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 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.
Informations about the package slimdb
SlimDb
Small db layer around the PDO and PDO statement.
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.
Installing the package
You can download the package directly from GitHub
Or install it using composer.json file
{
"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.
Finally, there is a 'default' connection name configured with the 'portal' value.
//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:
