PHP Classes


Recommend this page to a friend!
  Classes of Samuel Adeshina   Query Builder   Download  
Role: Documentation
Content type: text/markdown
Description: Documentation
Class: Query Builder
Build SQL queries using a fluent interface
Author: By
Last change:
Date: 8 years ago
Size: 1,297 bytes


Class file image Download


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")
		->where("employee_id < 563")

__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.