|Ratings|| ||Unique User Downloads|| ||Download Rankings|
| 78%||Total: 735 ||All time: 4,486 This week: 291|
This class can build SQL queries using a fluent interface.
It can compose SQL SELECT, UPDATE, INSERT and DELETE queries using functions that define query parameters.
The parameters define the SQL query type, tables, conditions, field names and values.
An Intelligent Query Builder for the SQL Language. It generates a complete sql string by calling methods on a parent QueryBuilder() object
This SQL Query Builder works through method chaining. You can call subsequent methods on another recursively.
$query = new QueryBuilder()
->where("employee_id < 563")
__You finally build the sql query by calling the
build() method on your
build() method is the only method that returns a string data, every other method returns a new instance
Supported SQL Methods
- select(string ...$string) //zero or more string parameters
- from(string $string)
- where(string $string)
- values(string ...$string)
- into(string $string, QueryBuilder $query_builder_object = null) //optional second parameter
- update(string $string)
- set(string $string)
- delete(string $string)
<i>You should know that:</i>
> This class is not an SQL string validator. It does not validate your sql queries.
It only appends a string to another based on the method you've called.
So if you append a
where() method directly to a
select() method, it still
generates an sql string.
||Applications that use this package
No pages of applications that use this class were specified.
If you know an application of this package, send a message to the author to add a link here.