sumpygump/qi-db

Basic database adapter

1.3.0.1 2024-07-12 22:01 UTC

Requires

• php: >=5.3

Requires (Dev)

• phpstan/phpstan: ^1.11
• phpunit/phpunit: ^9.5

MIT

• Jansen Price

• database
• mysql
• sqlite
• adapter

README

Qi Db provides PHP library classes for running SQL on databases.

Installation with Composer

Use composer to include the Qi\Db library in a project.

composer require sumpygump/qi-db

If you don't have composer already installed, this is my recommendation for installing it. See getcomposer.org installation instructions.

Once the files have been composed with the composer install command, you can use any of the Qi\Db classes after composer's autoloader is included.

require 'vendor/autoload.php';

$db = new Qi\Db\PdoMysql();
// ...

Manual Installation

You can also download the files and place them in a library folder. If you do this, be sure to update your autoloader to handle the Qi_Db_* classes or else manually include the files of the classes you'll need.

Basic Usage

This is some example code that illustrates connecting to a Mysql database:

$dbConfig = [
    'host' => 'localhost',
    'db'   => 'databasename',
    'user' => 'username',
    'pass' => 'mypassword',
];
$db = new Qi\Db\PdoMysql($dbConfig);

This is some example code that illustrates using the insert() and fetchRow() methods of the PdoMysql class.

// This will insert a new record into a `users` table
$newRow = [
    'email' => '[e-mail]',
    'first_name' => 'Joe',
    'last_name' => 'Schmoe',
];
$db->insert('users', $newRow);

// This will fetch a user by email address
$user = $db->fetchRow("SELECT * FROM `users` WHERE `email`=?", ['[e-mail]']);

Please check the class source code for the full list of other methods that can be used.