xmiop.blogg.se - Source code menghitung total dan subtotal di php

$values ( array) – Array of target values.

$key ( string) – Name of field to examine.

Generates a WHERE field NOT IN(‘item’, ‘item’) SQL query, Generates a WHERE field IN(‘item’, ‘item’) SQL query,

$values ( array) – The values searched on.

Generates the WHERE portion of the query.

$value ( mixed) – If a single key, compared to this value.

$key ( mixed) – Name of field to compare, or associative array.

$cond ( string) – The JOIN ON conditionĪdds a JOIN clause to a query.

$from ( mixed) – Table name(s) string or array.

Sets a flag which tells the query builder to addĪ DISTINCT clause to the SELECT portion of the query.

$val ( bool) – Desired value of the “distinct” flag.

$select ( string) – Field to compute the sum ofĪdds a SELECT SUM(field) clause to a query.

$select ( string) – Field to compute the minimum ofĪdds a SELECT MIN(field) clause to a query.

$select ( string) – Field to compute the maximum ofĪdds a SELECT MAX(field) clause to a query.

$alias ( string) – Alias for the resulting value nameĪdds a SELECT AVG(field) clause to a query.

$select ( string) – Field to compute the average of.

$escape ( bool) – Whether to escape values and identifiersĪdds a SELECT clause to a query.

$select ( string) – The SELECT portion of a query.

Same as get(), but also allows the WHERE to be added directly.

$table ( mixed) – The table(s) to fetch data from string or array.

get ( ] ] ) ¶ Parameters:Ĭompiles and runs SELECT statement based on the alreadyĬalled Query Builder methods. Generates a platform-specific query string that countsĪll records returned by an Query Builder query.

$reset ( bool) – Whether to reset values for SELECTs.

Prepends a database prefix, if one exists in configuration.

$table ( string) – The table name to prefix.

Sets the database prefix, without having to reconnect.

$prefix ( string) – The new prefix to use.

flush_cache ( ) ¶ Returns:Įmpties the Query Builder cache. To build a query that can be cancelled under certain conditions. Class Reference ¶ class CI_DB_query_builder ¶ reset_query ( ) ¶ Returns:ĬI_DB_query_builder instance (method chaining)