chamamme/orcons-db

A database query builder for ADODB which is aimed at code beautification by minimizing the use of raw SQL in codes

NoQuery

NoQuery is a php query builder running on ADODB library. It is aimed at making database interactions easier with less codes. NoQuery currently supports MySQL, Firebird-Interbase, PostgreSQL, SQLite3, Oracle, Microsoft SQL Server, Foxpro ODBC, Access ODBC, Informix, DB2, Sybase, Sybase SQL Anywhere, generic ODBC and Microsoft's ADO due its leverage on ADODB., _(*1)

Installation

 > composer require chamamme/noquery

Configuration

NoQuery requires a configuration array. A typical configuration looks like

     $config = [
            'driver'    => 'mysqli', #eg. access,ado,ibase,fbsql,db2,informix,ldap,mssqlnative,netezza,odbc,odbtp,oci8,pdo,postgres9,proxy,ads,sybase_ase,sqlite3,sybase

        'server'    => "localhost",

        'username'  => "root",

        'password'  => "",

        'port'      => "3306",

        'database'  => "test_db",

        'debug'     => false

    ];

Usage

It all starts with an instance of Tablet class which requires a configuration array variable., _(*2)

$db = new  NoQuery\Builder( $config ) 

Now we are ready to interact with our database., _(*3)

Methods

Sample

```php, <sub>(*4)</sub>

require("vendor/autoload.php"); #change to the actual path of your composer autoload.php file, <sub>(*5)</sub>

use NoQuery\Builder;, <sub>(*6)</sub>

$config = [ 'driver' => "mysqli", 'server' => "localhost", 'username' => "root", 'password' => "", 'port' => "3306", 'database' => "test_db", 'debug' => false ];, <sub>(*7)</sub>

$db = new Builder( $config ) ; #Instantiate the Builder class

#select query
$db->table('users')
    ->select(['name','gender','age'])
    ->get();

#update statement
$db->table('users')
      ->update(['name'=>'Chamamme'])
      ->where(["id = 5","gender ='male'"])
      ->go();

```, <sub>(*8)</sub>