libcsi/libcsi

lib csi composer project

libcsi

Simple library for connecting database and create query builder model
version dev-master
* only support mysql/mariadb syntax, _(*1)

installatation

It's recommended that you use Composer to install, _(*2)

$ composer require libcsi/libcsi "dev-master"  

OR, _(*3)

• create composer.json containing

{
    "minimum-stability": "dev",
    "require": {
        "php": ">=5.3.0",
        "libcsi/libcsi": "dev-master"
    }
}

• run composer install

usage example

<?php

require_once 'vendor/autoload.php';

// put it somewhere you like  
$config = array (
        'DB' => array (
                'dbdriver' => 'mysql',
                'dbserver' => 'localhost',
                'dbname' => 'dbname',
                'dbuser' => 'dbuser',
                'dbpass' => 'dbpass'
        )
);
$db = new \CSI\Data\DataAdapter ( $config ["DB"] );
try{
    // connect to database
    $db->connect();
}catch(\Exception $e){
    die($e->getMessage());
}

example model

<?php

final class TableTest extends \CSI\Data\Model {
    // name of the table in database
    protected $table="table_test";
    // name of primary key of this table
    protected $primaryKey="id";
}

fetching data using model

$table = new TableTest();  
$table->find("a primary key value");  
$fieldvalue = $table->afiedname;

That's it, _(*4)