where()
The where method is an alias for and_where.
The Query_Builder_Where class handles the conditioning and limiting logic for query building. Every kind of where statement (including BETWEEN and IN etc...) is handled here. This class is not instantiated (it's abstract) but extended by other classes that share the same functions. These classes are:
Please note: Since Query_Builder_Where is extended by the classes listed above, the "current instance" returned will be one of those.
The where method is an alias for and_where.
The and_where method appends a WHERE statement.
Static | No | ||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Parameters |
|
||||||||||||||||
Returns | Returns the current instance. | ||||||||||||||||
Example |
|
The or_where method appends an OR WHERE statement.
Static | No | ||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Parameters |
|
||||||||||||||||
Returns | Returns the current instance. | ||||||||||||||||
Example |
|
The where_open method is an alias for and_where_open.
The and_where_open method opens an SQL closure and appends it using AND.
Static | No |
---|---|
Parameters | None |
Returns | Returns the current instance. |
Example |
|
The or_where_open method opens an SQL closure and appends it using OR.
Static | No |
---|---|
Parameters | None |
Returns | Returns the current instance. |
Example |
|
The where_close method is an alias for and_where_close.
The and_where_close method closes an SQL closure.
Static | No |
---|---|
Parameters | None |
Returns | Returns the current instance. |
Example |
|
The or_where_close method closes an SQL closure.
Static | No |
---|---|
Parameters | None |
Returns | Returns the current instance. |
Example |
|
The order_by method sets the order for the result/execution.
Static | No | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Parameters |
|
||||||||||||
Returns | Returns the current instance. | ||||||||||||
Example |
|
The limit method limits the number of rows selected/affected.
Static | No | ||||||||
---|---|---|---|---|---|---|---|---|---|
Parameters |
|
||||||||
Returns | Returns the current instance. | ||||||||
Example |
|