Last Updated | | Ratings | | Unique User Downloads | | Download Rankings |
2016-01-05 (9 months ago) | | 78% | | Total: 431 This week: 4 | | All time: 5,987 This week: 267 |
|
Description | | Author |
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. | |
|
|
Innovation award
Nominee: 7x
Winner: 1x |
|
Details
Plug-Query-Builder
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.
For example:
$query = new QueryBuilder()
->select("first_name", "last_name")
->from("EmployeeInfo")
->where("employee_id < 563")
->build();
__You finally build the sql query by calling the build()
method on your QueryBuilder()
object__
The build()
method is the only method that returns a string data, every other method returns a new instance
of a QueryBuilder()
object
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
- insert()
- 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.