SQL Help class. More...
Public Member Functions | |
limit_parse ($str) | |
Parse the limit string and split into more sql standard LIMIT (val) OFFSET (val). | |
Static Public Member Functions | |
static | concat ($arg1, $arg2, $arg3) |
Concatenate arguments for use in sql query Since we are using 3 arguments, this method handles just this and nothing else. | |
static | sqlor () |
Joins arbitrary amount of sub-expressions into one OR separated string of expressions. | |
static | sqland () |
Joins arbitrary amount of sub-expressions into one AND separated string of expressions. |
SQL Help class.
static sql::concat | ( | $ | arg1, | |
$ | arg2, | |||
$ | arg3 | |||
) | [static] |
Concatenate arguments for use in sql query Since we are using 3 arguments, this method handles just this and nothing else.
Arguments 1 and 3 are assumed to be field names and argument 2 i assumed to be a string.
static sql::sqland | ( | ) | [static] |
Joins arbitrary amount of sub-expressions into one AND separated string of expressions.
Filters out empty arguments, and wraps all the sub-expressions in parenthesis.
static sql::sqlor | ( | ) | [static] |
Joins arbitrary amount of sub-expressions into one OR separated string of expressions.
Filters out empty arguments, and wraps all the sub-expressions in parenthesis.