Download the PHP package chamamme/noquery without Composer
On this page you can find all versions of the php package chamamme/noquery. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
Table of contents
Download chamamme/noquery
More information about chamamme/noquery
Files in chamamme/noquery
Download chamamme/noquery
More information about chamamme/noquery
Files in chamamme/noquery
Vendor chamamme
Package noquery
Short Description A database query builder aimed at code beautification by minimizing the use of raw SQL in 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 to its leverage on ADODB
License MIT
Package noquery
Short Description A database query builder aimed at code beautification by minimizing the use of raw SQL in 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 to its leverage on ADODB
License MIT
Please rate this library. Is it a good library?
Informations about the package noquery
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.
Installation
> composer require chamamme/noquery
Configuration
NoQuery requires a configuration array. A typical configuration looks like
Usage
It all starts with an instance of Tablet class which requires a configuration array variable.
Now we are ready to interact with our database.
Methods
Name | Params (Type) | Description | Example |
---|---|---|---|
table |
table (string) |
Tells orcons-db the database table to interact with. | table('users') |
select |
columns (array) | Performs a select query. | select(['name','age']) |
update |
args (array) | Performs an UPDATE statement . |
update(['name'=>'Andrew','age'=>10]) |
where |
conditions (array) | Adds an where clause to sql statement |
where(["name = 'Chamamme']) |
orWhere |
conditions (array) | Adds an OR clause to sql statement |
orWhere([age = 25]) |
whereIn |
column (string) , conditions (array) | Adds an WHERE IN clause to sql statement |
whereIn('age',[ 25 , 6 , 8 ]) |
whereNotIn |
column (string) , conditions (array) | Adds an WHERE NOT IN clause to sql statement |
whereNotIn('age',[ 25 , 6 , 8 ]) |
whereBetween |
column (string) , conditions (array) | Adds an BETWEEN clause to sql statement |
whereBetween('age',[ 18 ,19 ]) |
orWhereIn |
conditions (array) | Adds an OR IN clause to sql statement |
orWhereIn(['name'=>'Andrew','age'=>25]) |
get |
limit (int), offset (int) | Executes the sql statement | get() or get(0,10) |
run |
Executes the sql statement | run() |
|
toSql |
returns the final sql statment | toSql() |
Sample
All versions of noquery with dependencies
PHP Build Version
Package Version
The package chamamme/noquery contains the following files
Loading the files please wait ....