chanhong/pdolite

database lite classes for mysql, sqlsrv, sqlite, odbc, pdo (mysql, sqlite, sqlsrv)

PdoLite

Very lite PDO database class with lite query builder and SIDU (Select, Insert, Delete, Update)., _(*1)

One class file with the size of 22 KB., _(*2)

You can also use all the native PDO methods: http://php.net/manual/en/book.pdo.php, _(*3)

Installation

$ ./composer.phar require chanhong/pdolite 1.0.x-dev, _(*4)

Usage

Use Case: Use with Slim 3 modify 3 files: settings.php, dependencies.php and index.php

You can download the sample application of Slim 3 using PdoLite here: https://github.com/chanhong/slimbookshelf4iis, _(*5)

In settings.php, _(*6)

    'pdolite' => [
        'dsn' => 'mysql:host=localhost;dbname=bookshelf;charset=utf8',
        'username' => 'user',
        'password' => 'password',
    ], 

In dependencies.php, _(*7)

use PdoLite\PdoLite; // Database $container['pdolite'] = function ($c) { PdoLite::$cfg = $settings = $c->get('settings')['pdolite'];
$conn = PdoLite::dbConnect($settings['dsn'],$settings['username'],$settings['password']); return $conn;
};, _(*8)

In your index.php, _(*9)

// Register the database connection with PdoLite $pdolite = $app->getContainer()->get('pdolite');, _(*10)

In any of your php file that you want to use PdoLite, _(*11)

    return PdoLite::select("authors");

Use Case: Use with your own code:

//Sample dsn, _(*12)

Please see settings-dist.php, _(*13)

// Sample code using New Ojbect call, _(*14)

<?php, _(*15)

include ('src\pdolite.php');, _(*16)

use PdoLite\PdoLite;, _(*17)

$db = new PdoLite();, _(*18)

$conn = $db->dbConnect($dsn,$username,$password);, _(*19)

print_r($conn->dbFetchAssoc($sql));, _(*20)

// Sample code using static call, _(*21)

PdoLite::pln(PdoLite::select("authors", ['type'=>'assoc']),"select");, _(*22)

$sqlUpdList = ['biography'=>'test']; PdoLite::pln(PdoLite::update("authors", ['fl'=>$sqlUpdList, 'where'=>'id=1']),"update");, _(*23)

Please see testcase.php for more detail, _(*24)

PHPUnit Usage

cd pdolite, _(*25)

phpunit test\PdoLiteTest.php, _(*26)