Title: Database Class
Post by: Chief! on February 10, 2012, 09:14:18 AM
Database_Contoller | # _allowed_exceptions = array(
'CURRENT_TIMESTAMP',
'NOW()',
'offline_capture'); Allowed exceptions
# _cached = false; bool; Was it a cached query?
# _db_connect_id = null; resource; database connection
# _found_rows = null; int; Number of rows found
# _prefix = ''; string; Store prefix
# _query = false; string; Query to execute
# _query_time = null; float; Query run time
# _result = null; array; Query result
# _instance; static instance; Class instance
| # __construct
+ __destruct
+ column_sort; string; Display column sort
+ count; int|false; Query count a field
+ debug; string; Returns "[QUERY] - " and derived query
+ delete; bool; DELETE query
+ doSQLBackup; string; Create schema/data restore script
+ getDebug; array; Get database debug info
+ getFulltextIndex; array; Get all fulltext fields from table
+ getFoundRows; int; Get the number of rows found
+ getSearchWordLen; int; Gets the size of the ft_min_word_len
+ getRows; array|false; Get all rows from a table
+ getQuery; string; Returns derived query
+ insert; int|false; Insert data into a table
+ misc; bool; Execute a misc query
+ numrows; int|false; Get the number of rows
+ pagination; string|false; Create a pagination
+ parseSchema; bool; Parse and execute schema script
+ query; array|false; Query database
+ select; array|false; SELECT query
+ sqldumptable; string; Create table schema/data restore script
+ strip_slashes; string; Strip slashes
+ truncate; bool; TRUNCATE query
+ update; bool; UPDATE query
+ where; string|false; Builds a WHERE string
# _getCached; array|false; Get cached query
# _logError; Log SQL errors
# _sqlDebug; bool; SQL debug
# _startTimer; Starts a timer for a query
# _stopTimer; Stops a timer
# _writeCache; bool; Write data to cached query
|
|