Download the PHP package hraw/dbqb without Composer
On this page you can find all versions of the php package hraw/dbqb. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
Please rate this library. Is it a good library?
Informations about the package dbqb
PHP-Mysql QueryBuilder
Query builder package to implement database queries easily in core PHP.
Requirements
- PHP 7.0 or higher
- Composer for installation
Installation
composer require hraw/dbqb
Implementation
Example: filename -> index.php
Transactions
Multiple database connections
Supported methods
- where('columnName', 'operator', 'value') or where([$keyValues]) //operator is optional
- orWhere('columnName', 'operator', 'value') //operator is optional
- whereIn('columnName', 'values') //values must an array
- orWhereIn('columnName', 'values') //values must an array
- whereNotIn('columnName', 'values') //values must an array
- orWhereNotIn('columnName', 'values') //values must an array
- whereBetween('columnName', [val1, val2])
- whereNotBetween('columnName', [val1, val2])
- orWhereBetween('columnName', [val1, val2])
- orWhereNotBetween('columnName', [val1, val2])
- whereNull('columnName')
- orWhereNull('columnName')
- whereNotNull('columnName')
- orWhereNotNull('columnName')
- orderBy('columnName', type) // type can be ASC or DESC
- groupBy(column1, column2)
- limit(value)
- offset(value)
- raw(query, placeholders) //you can run raw queries through this query builder with or without prepare statements, for prepare statements all you have to do is pass array of values of in placeholders parameter(optional parameter).
- count('columnName') //optional
- min('columnName')
- max('columnName')
- avg('columnName')
- sum('columnName')
- insert([values]) //Insert single row in table, values must be an associative array
- batchInsert([values]) //Insert multiple records in table, values must array of arrays
- delete() //Delete record from database
- update([values]) //values must be an associative array
- having (Note:- All having methods are same as where methods)
Run Server
php -S localhost:8000
All versions of dbqb with dependencies
PHP Build Version
Package Version
Requires
php Version
>=7.0
ext-pdo Version *
ext-pdo Version *
The package hraw/dbqb contains the following files
Loading the files please wait ....