README

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.

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.

$db = new  NoQuery\Builder( $config ) 

Now we are ready to interact with our database.

Methods

Sample

require("vendor/autoload.php"); #change to the actual path of your composer autoload.php file

use NoQuery\Builder;

$config = [
       'driver' 	=> "mysqli",
   	'server' 	=> "localhost",
   	'username' 	=> "root",
   	'password' 	=> "",
   	'port' 		=> "3306",
   	'database' 	=> "test_db",
   	'debug' 	=> false
   ];
   
   $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();