Class SQLiteDB

SQLiteDB

Methods summary

`private Logger &`	# `getLogger( )` Returns `Logger`
`private`	# `setIntErr( $id, $errno )`
`private`	# `writeTrace( $s )`
`private`	# `writeLog( $s, $file )`
`public`	# `__construct( $useSQLite3 = true )`
`public`	# `__destruct( )`
`public`	# `free( )`
`public array`	# `getStatistics( )` return a array with statistics about SELECTS, UPDATES, INSERTS ect. since the object was created return a array with statistics about SELECTS, UPDATES, INSERTS ect. since the object was created Returns array
`public mixed`	# `version( )` version of SQLite library (if you use SQLite3 you get an array instead of a string) version of SQLite library (if you use SQLite3 you get an array instead of a string) Returns mixed
`public integer`	# `getError( string $id )` get last error code (if you use SQLite3 you should check for 0 and 101 if table or record not exists) get last error code (if you use SQLite3 you should check for 0 and 101 if table or record not exists) Parameters `$id` Returns integer
`public string`	# `getErrorMsg( string $id )` get last error message get last error message Parameters `$id` Returns string
`public`	# `connect( string $id, string $filename = "" )` open a SQLite database file open a SQLite database file Parameters `$id` => id for the database name `$filename`
`public`	# `open( string $id, string $filename = "" )` open a SQLite database file open a SQLite database file Parameters `$id` => id for the database name `$filename`
`public`	# `disconnect( $id )`
`public`	# `close( $id )`
`public SQLiteDBResult`	# `sql( string $id, mixed $sql, integer $fetch_type = SQLITE_BOTH, boolean $free_resource = true )` return SQLiteDBResult or number of affected rows return SQLiteDBResult or number of affected rows Parameters `$id` => id for the database name `$sql` $sql_query or $sql_builder_object `$fetch_type` `$free_resource` if false the result resource will be free by garbage collector or should be free manually Returns `SQLiteDBResult`
`public`	# `begin( string $id = "master" )` start a transaction start a transaction Parameters `$id`
`public`	# `rollback( string $id = "master" )` rollback a transaction rollback a transaction Parameters `$id`
`public`	# `commit( string $id = "master" )` commit a transaction commit a transaction Parameters `$id`

Methods inherited from SQLiteDB_

escapeString()

Properties summary

`private array`	`$m_db`	# `array()`
`private array`	`$m_sqlite_int_error`	# `array()`
`private array`	`$m_internal_errors`	# `array()`
`private array`	`$m_statistic`	# `array()`
`private`	`$m_logger`	# `null`
`private array`	`$m_transaction`	# `array()`
`private boolean`	`$m_use_sqlite3`	# `false`
`public boolean`	`$m_show_warning` show warnings show warnings	# `true`
`public boolean`	`$m_persistent_connection` open the connection persistent open the connection persistent	# `false`
`public integer`	`$m_last_query_ms` return the last query execution time return the last query execution time	# `0`
`public string`	`$m_last_id` id of last used db id of last used db	# `""`
`public string`	`$m_trace_path` path for trace file path for trace file	# `""`
`public string`	`$m_trace_file` filename of tracefile filename of tracefile	# `""`
`public mixed`	`$m_trace_delAfter` size before trace file will set to zero size before trace file will set to zero	# `"1024K"`
`public mixed`	`$m_log_delAfter` size before log file(s) will set to zero size before log file(s) will set to zero	# `"1024K"`
`public string`	`$m_log_path` path for log files path for log files	# `""`
`public string`	`$m_log_critical_section_id` enable critical section for write log files enable critical section for write log files	# `null`
`public string`	`$m_log_critical_section_path` path to share the critical section for write log files path to share the critical section for write log files	# `""`
`public integer`	`$m_log_critical_section_maxlock_ms` max lock time for zombie processes max lock time for zombie processes	# `1000`
`public integer`	`$m_log_critical_section_sleep_ms` sleep for retry enter critical section sleep for retry enter critical section	# `10`
`public string`	`$m_trace_critical_section_id` enable critical section for write trace files enable critical section for write trace files	# `null`
`public string`	`$m_trace_critical_section_path` path to share the critical section for write trace files path to share the critical section for write trace files	# `"./"`
`public integer`	`$m_trace_critical_section_maxlock_ms` max lock time for zombie processes max lock time for zombie processes	# `1000`
`public integer`	`$m_trace_critical_section_sleep_ms` sleep for retry enter critical section sleep for retry enter critical section	# `10`

Classes

Interfaces

Traits

Functions

Class SQLiteDB

Methods summary

Returns

Returns

Returns

Parameters

Returns

Parameters

Returns

Parameters

Parameters

Parameters

Returns

Parameters

Parameters

Parameters

Methods inherited from SQLiteDB_

Properties summary