BaseBuilder.php

Constructor Examples of $tableName: `mytable`, `jobs j`, `jobs j, users u`, `['jobs j','users u']`

Returns the current database connection

Sets a test mode status.

Gets the name of the primary table.

Returns an array of bind values and their named parameters for binding in the Query object later.

Ignore Set ignore Flag for next insert, update or delete query.

Generates the SELECT portion of the query

Generates a SELECT MAX(field) portion of a query

Generates a SELECT MIN(field) portion of a query

Generates a SELECT AVG(field) portion of a query

Generates a SELECT SUM(field) portion of a query

Generates a SELECT COUNT(field) portion of a query

Adds a subquery to the selection

SELECT [MAX|MIN|AVG|SUM|COUNT]()

Determines the alias name based on the table

Sets a flag which tells the query string compiler to add DISTINCT

Generates the FROM portion of the query

Generates the JOIN portion of the query

Generates the WHERE portion of the query. Separates multiple calls with 'AND'.

OR WHERE Generates the WHERE portion of the query. Separates multiple calls with 'OR'.

Generates a WHERE field IN('item', 'item') SQL query, joined with 'AND' if appropriate.

Generates a WHERE field IN('item', 'item') SQL query, joined with 'OR' if appropriate.

Generates a WHERE field NOT IN('item', 'item') SQL query, joined with 'AND' if appropriate.

Generates a WHERE field NOT IN('item', 'item') SQL query, joined with 'OR' if appropriate.

Generates a HAVING field IN('item', 'item') SQL query, joined with 'AND' if appropriate.

Generates a HAVING field IN('item', 'item') SQL query, joined with 'OR' if appropriate.

Generates a HAVING field NOT IN('item', 'item') SQL query, joined with 'AND' if appropriate.

Generates a HAVING field NOT IN('item', 'item') SQL query, joined with 'OR' if appropriate.

Generates a %LIKE% portion of the query. Separates multiple calls with 'AND'.

Generates a NOT LIKE portion of the query. Separates multiple calls with 'AND'.

Generates a %LIKE% portion of the query. Separates multiple calls with 'OR'.

Generates a NOT LIKE portion of the query. Separates multiple calls with 'OR'.

Generates a %LIKE% portion of the query. Separates multiple calls with 'AND'.

Generates a NOT LIKE portion of the query. Separates multiple calls with 'AND'.

Generates a %LIKE% portion of the query. Separates multiple calls with 'OR'.

Generates a NOT LIKE portion of the query. Separates multiple calls with 'OR'.

Platform independent LIKE statement builder.

Add UNION statement

Add UNION ALL statement

Starts a query group.

Starts a query group, but ORs the group

Starts a query group, but NOTs the group

Starts a query group, but OR NOTs the group

Ends a query group

Starts a query group for HAVING clause.

Starts a query group for HAVING clause, but ORs the group.

Starts a query group for HAVING clause, but NOTs the group.

Starts a query group for HAVING clause, but OR NOTs the group.

Ends a query group for HAVING clause.

Prepate a query group start.

Prepate a query group end.

Separates multiple calls with 'AND'.

Separates multiple calls with 'OR'.

Sets the OFFSET value

Generates a platform-specific LIMIT clause.

Allows key/value pairs to be set for insert(), update() or replace().

Returns the previously set() data, alternatively resetting it if needed.

Compiles a SELECT query string and returns the sql.

Returns a finalized, compiled query string with the bindings inserted and prefixes swapped out.

Compiles the select statement based on the other functions called and runs the query

Generates a platform-specific query string that counts all records in the particular table

Generates a platform-specific query string that counts all records returned by an Query Builder query.

Compiles the set conditions and returns the sql statement

Allows the where clause, limit and offset to be added directly

Compiles batch insert/update/upsert strings and runs the queries

Allows a row or multiple rows to be set for batch inserts/upserts/updates

Compiles an upsert query and returns the sql

Converts call to batchUpsert

Compiles batch upsert strings and runs the queries

Generates a platform-specific upsertBatch string from the supplied data

Set table alias for dataset pseudo table.

Sets update fields for upsert, update

Sets constraints for batch upsert, update

Sets data source as a query for insertBatch()/updateBatch()/upsertBatch()/deleteBatch()

Gets column names from a select query

Converts value array of array to array of strings

Compiles batch insert strings and runs the queries

Generates a platform-specific insert string from the supplied data.

Allows key/value pairs to be set for batch inserts

Compiles an insert query and returns the sql

Compiles an insert string and runs the query

This method is used by both insert() and getCompiledInsert() to validate that the there data is actually being set and that table has been chosen to be inserted into.

Generates a platform-specific insert string from the supplied data

Compiles a replace into string and runs the query

Generates a platform-specific replace string from the supplied data

Groups tables in FROM clauses if needed, so there is no confusion about operator precedence. Note: This is only used (and overridden) by MySQL and SQLSRV.

Compiles an update query and returns the sql

Compiles an update string and runs the query.

Generates a platform-specific update string from the supplied data

This method is used by both update() and getCompiledUpdate() to validate that data is actually being set and that a table has been chosen to be updated.

Sets data and calls batchExecute to run queries

Generates a platform-specific batch update string from the supplied data

Allows key/value pairs to be set for batch updating

Compiles a delete string and runs "DELETE FROM table"

Compiles a truncate string and runs the query If the database does not support the truncate() command This function maps to "DELETE FROM table"

Generates a platform-specific truncate string from the supplied data If the database does not support the truncate() command, then this method maps to 'DELETE FROM table'

Compiles a delete query string and returns the sql

Compiles a delete string and runs the query

Sets data and calls batchExecute to run queries

Generates a platform-specific batch update string from the supplied data

Increments a numeric column by the specified value.

Decrements a numeric column by the specified value.

Generates a platform-specific delete string from the supplied data

Used to track SQL statements written with aliased tables.

Compile the SELECT statement Generates a query string based on which functions were used. Should not be called directly.

Checks if the ignore option is supported by the Database Driver for the specific statement.

Escapes identifiers in WHERE and HAVING statements at execution time. Required so that aliases are tracked properly, regardless of whether where(), orWhere(), having(), orHaving are called prior to from(), join() and prefixTable is added only if needed.

Escapes identifiers in GROUP BY statements at execution time. Required so that aliases are tracked properly, regardless of whether groupBy() is called prior to from(), join() and prefixTable is added only if needed.

Escapes identifiers in ORDER BY statements at execution time. Required so that aliases are tracked properly, regardless of whether orderBy() is called prior to from(), join() and prefixTable is added only if needed.

Takes an object as input and converts the class variables to array key/vals

Takes an object as input and converts the class variables to array key/vals

Determines if a string represents a literal value or a field name

Publicly-visible method to reset the QB values.

Resets the query builder values. Called by the get() function

Resets the query builder values. Called by the get() function

Resets the query builder "write" values. Called by the insert() update() insertBatch() updateBatch() and delete() functions

Tests whether the string has an SQL operator

Returns the SQL string operator

Returns the SQL string operator from where key

Stores a bind value after ensuring that it's unique. While it might be nicer to have named keys for our binds array with PHP 7+ we get a huge memory/performance gain with indexed arrays instead, so lets take advantage of that here.

Returns a clone of a Base Builder with reset query builder values.