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