libcsi/libcsi

This package is abandoned and no longer maintained. No replacement package was suggested.

lib csi composer project

dev-master 2017-09-05 22:29 UTC

Requires

• php: >=5.3.0

MIT

• dhaim

README

Simple library for connecting database and create query builder model
version dev-master

• only support mysql/mariadb syntax

installatation

It's recommended that you use Composer to install

$ composer require libcsi/libcsi "dev-master"  

OR

• 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