Public Member Functions |
| | __call ($function, $args) |
| | fatal ($msg, $lev=null) |
| | foundRows () |
| | s () |
| | l ($a=null) |
| | do_getHash ($f=null) |
| | do_getAll ($f=null) |
| | do_getAllHash ($f=null) |
| | do_getRow ($f=null) |
| | do_getOne () |
| | do_getAssoc () |
| | do_getColumn () |
| | do_select () |
| | do_delete () |
| | do_insert () |
| | do_replace () |
| | query ($str) |
| | do_fetchRow ($l=null) |
| | do_fetchHash ($l=null) |
| | debug () |
| | table ($table) |
| | field ($field, $table=null) |
| | set ($set, $val=array()) |
| | getArgsList ($args_type) |
| | call_sql_function ($function_name, $params) |
| | setDate ($field='ts', $value=null) |
| | where ($where, $equals=false, $escape=true, $cond='where') |
| | clear_args ($arg_name) |
| | having ($having, $equals=false, $escape=true) |
| | join ($table, $on, $type='inner') |
| | order ($order, $desc=null, $prepend=null) |
| | isArgSet ($option, $field) |
| | limit ($cnt, $shift=0) |
| | group ($group, $prepend=null) |
| | paramExists ($param, $value) |
| | select () |
| | update () |
| | insert () |
| | replace () |
| | delete () |
| | getArgs ($required) |
| | parseTemplate ($template) |
| | calc_found_rows () |
| | option ($option) |
Data Fields |
| | $db |
| | $my = array(null,null,null) |
| | $saved = array(null,null,null) |
| | $args |
| | $debug |
Protected Member Functions |
| | escapeValue ($val) |
Member Function Documentation
Escape value for protect SQL injection and support complex strings
- Parameters:
-
- Returns:
- string
| fatal |
( |
$ |
msg, |
|
|
$ |
lev = null |
|
) |
| |
| field |
( |
$ |
field, |
|
|
$ |
table = null |
|
) |
| |
Support external access to args property
- Parameters:
-
- Returns:
- array
| group |
( |
$ |
group, |
|
|
$ |
prepend = null |
|
) |
| |
| having |
( |
$ |
having, |
|
|
$ |
equals = false, |
|
|
$ |
escape = true |
|
) |
| |
Returns true if argument $option has been set for the $field in this query I.e. isArgSet('where','id') returns true if where('id',$value) was called
| join |
( |
$ |
table, |
|
|
$ |
on, |
|
|
$ |
type = 'inner' |
|
) |
| |
| limit |
( |
$ |
cnt, |
|
|
$ |
shift = 0 |
|
) |
| |
| order |
( |
$ |
order, |
|
|
$ |
desc = null, |
|
|
$ |
prepend = null |
|
) |
| |
Returns true if specified $value already set for $param E.g. paramExists('group',$field) returns true if grouping by $field was already set
May not work for where or having, as they are implemented like shit
| set |
( |
$ |
set, |
|
|
$ |
val = array() |
|
) |
| |
| setDate |
( |
$ |
field = 'ts', |
|
|
$ |
value = null |
|
) |
| |
| where |
( |
$ |
where, |
|
|
$ |
equals = false, |
|
|
$ |
escape = true, |
|
|
$ |
cond = 'where' |
|
) |
| |
Field Documentation
| $my = array(null,null,null) |
| $saved = array(null,null,null) |
The documentation for this class was generated from the following file:
- /Users/rw/Sites/atk42/atk4/lib/DBlite/dsql.php