Docs For Class ezSQLcore

Description

********************************************************************

Core class containg common functions to manipulate query result sets once returned

Located in /shared/ez_sql_core_202console.php (line 45)

Variable Summary

mixed $cache_dir

mixed $cache_inserts

mixed $cache_queries

mixed $cache_timeout

mixed $captured_errors

mixed $col_info

mixed $debug_all

mixed $debug_called

mixed $debug_echo

mixed $last_error

mixed $last_query

mixed $num_queries

mixed $show_errors

mixed $trace

mixed $use_disk_cache

mixed $vardump_called

Method Summary

ezSQLcore ezSQLcore ()

void connect ()

void debug ( $debug_echo)

void donation ()

void dumpvar ( $mixed)

void escape ()

void flush ()

void get_cache ( $query)

void get_col ([ $query = null], [ $x = 0])

void get_col_info ([ $info_type = "name"], [ $col_offset = -1])

void get_results ([ $query = null], [ $output = OBJECT])

void get_row ([ $query = null], [ $output = OBJECT], [ $y = 0])

void get_var ([ $query = null], [ $x = 0], [ $y = 0])

void hide_errors ()

void query ()

void register_error ( $err_str)

void select ()

void show_errors ()

void store_cache ( $query, $is_insert)

void sysdate ()

void vardump ([ $mixed = ''])

Variables

mixed $cache_dir = false (line 60)

mixed $cache_inserts = false (line 62)

mixed $cache_queries = false (line 61)

mixed $cache_timeout = 24 (line 64)

mixed $captured_errors = array() (line 59)

mixed $col_info = null (line 58)

mixed $debug_all = false (line 49)

mixed $debug_called = false (line 52)

mixed $debug_echo = true (line 51)

mixed $last_error = null (line 57)

mixed $last_query = null (line 56)

mixed $num_queries = 0 (line 55)

mixed $show_errors = true (line 54)

mixed $trace = false (line 48)

mixed $use_disk_cache = false (line 63)

mixed $vardump_called = false (line 53)

Methods

Constructor ezSQLcore (line 70)

********************************************************************

Constructor

ezSQLcore ezSQLcore ()

connect (line 78)

********************************************************************

Connect to DB - over-ridden by specific DB class

void connect ()

debug (line 460)

******************************************************************** Displays the last query string that was sent to the database & a table listing results (if there were any).

(abstracted into a seperate file to save server overhead).

void debug ( $debug_echo)

$debug_echo

donation (line 556)

********************************************************************

Naughty little function to ask for some remuniration!

void donation ()

dumpvar (line 444)

********************************************************************

Alias for the above function

void dumpvar ( $mixed)

$mixed

escape (line 106)

********************************************************************

Format a string correctly for safe insert - over-ridden by specific DB class

void escape ()

flush (line 156)

********************************************************************

Kill cached query results

void flush ()

get_cache (line 370)

********************************************************************

get_cache

void get_cache ( $query)

$query

get_col (line 235)

********************************************************************

Function to get 1 column from the cached result set based in X index see docs for usage and info

void get_col ([ $query = null], [ $x = 0])

$query
$x

get_col_info (line 308)

********************************************************************

Function to get column meta data info pertaining to the last query see docs for more info and usage

void get_col_info ([ $info_type = "name"], [ $col_offset = -1])

$info_type
$col_offset

get_results (line 258)

********************************************************************

Return the the query as a result set - see docs for more details

void get_results ([ $query = null], [ $output = OBJECT])

$query
$output

get_row (line 195)

********************************************************************

Get one row from the DB - see docs for more detail

void get_row ([ $query = null], [ $output = OBJECT], [ $y = 0])

$query
$output
$y

get_var (line 169)

********************************************************************

Get one variable from the DB - see docs for more detail

void get_var ([ $query = null], [ $x = 0], [ $y = 0])

$query
$x
$y

hide_errors (line 147)

void hide_errors ()

query (line 96)

********************************************************************

Basic Query - over-ridden by specific DB class

void query ()

register_error (line 125)

********************************************************************

Print SQL/DB error - over-ridden by specific DB class

void register_error ( $err_str)

$err_str

select (line 87)

********************************************************************

Select DB - over-ridden by specific DB class

void select ()

show_errors (line 142)

******************************************************************** Turn error handling on or off..

void show_errors ()

store_cache (line 336)

********************************************************************

store_cache

void store_cache ( $query, $is_insert)

$query
$is_insert

sysdate (line 116)

********************************************************************

Return database specific system date syntax i.e. Oracle: SYSDATE Mysql: NOW()

void sysdate ()

vardump (line 413)

********************************************************************

Dumps the contents of any input variable to screen in a nicely formatted and easy to understand way - any type: Object, Var or Array

void vardump ([ $mixed = ''])

$mixed