Property | Type | Description | |
---|---|---|---|
$columns | |||
$data | |||
$groupBy | |||
$having | |||
$index | |||
$join | |||
$method | |||
$option | |||
$orderBy | |||
$table | |||
$where |
Method | Description | |
---|---|---|
__call ( $callName, $argu ) | ||
__construct ( object &$db = null ) | ||
__get ( $getName ) | ||
__set ( $name, $value ) | ||
_sqlPush ( $sql ) | If we use $this->$getName directly, PHP will throw [Indirect modification of overloaded property] So we have to wrap it. | |
column ( $columns ) | Set column for query | |
data ( ) | Set data for INSERT & UPDATE | |
exist ( $table ) | ||
groupBy ( $groupBy ) | GroupBy | |
having ( $having ) | Set having | |
limit ( ) | Set limit & offset | |
option ( $option ) | Set SQL query option | |
orderBy ( ) | Order by | |
query ( $sql = null ) | ||
reset ( ) | Re-initialize this class | |
where ( ) | Set where query |
Method | Description | |
---|---|---|
buildBeforeWhere ( ) | ||
buildColumn ( ) | ||
buildCreate ( ) | ||
buildDelete ( ) | ||
buildDrop ( ) | ||
buildGroupBy ( ) | ||
buildHaving ( ) | ||
buildIndex ( ) | ||
buildInsert ( ) | ||
buildJoin ( ) | ||
buildLimit ( ) | ||
buildOrderBy ( ) | ||
buildOthers ( ) | ||
buildPagebar ( ) | ||
buildSelect ( ) | ||
buildTable ( ) | ||
buildUpdate ( ) | ||
buildWhere ( $originalWhere = null, $whereKeyword = null ) | ||
columnLoaderArray ( $columns ) |
Method | Description | |
---|---|---|
sql ( ) | ||
validateParamater ( $param ) |