Agile Toolkit  4.2
Agile Toolkit is a powerful web development framework. Inspired by GUI Applications development
DBlite_dsql Class Reference

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

__call ( function,
args 
)
call_sql_function ( function_name,
params 
)
clear_args ( arg_name)
debug ( )
delete ( )
do_delete ( )
do_fetchHash ( l = null)
do_fetchRow ( l = null)
do_getAll ( f = null)
do_getAllHash ( f = null)
do_getHash ( f = null)
do_getOne ( )
do_getRow ( f = null)
do_insert ( )
do_select ( )
escapeValue ( val) [protected]

Escape value for protect SQL injection and support complex strings

Parameters:
mixed$val
Returns:
string
fatal ( msg,
lev = null 
)
field ( field,
table = null 
)
foundRows ( )
getArgs ( required)
getArgsList ( args_type)

Support external access to args property

Parameters:
string$arg_type
Returns:
array
group ( group,
prepend = null 
)
having ( having,
equals = false,
escape = true 
)
insert ( )
isArgSet ( option,
field 
)

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' 
)
l ( a = null)
limit ( cnt,
shift = 0 
)
option ( option)
order ( order,
desc = null,
prepend = null 
)
paramExists ( param,
value 
)

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

parseTemplate ( template)
query ( str)
replace ( )
s ( )
select ( )
set ( set,
val = array() 
)
setDate ( field = 'ts',
value = null 
)

Accepts any date format

table ( table)
update ( )
where ( where,
equals = false,
escape = true,
cond = 'where' 
)

Field Documentation

$args
$db
$my = array(null,null,null)
$saved = array(null,null,null)

The documentation for this class was generated from the following file:
 All Data Structures Files Functions Variables Enumerations