SQLite class.
Located in /db_sqlite.class.php (line 20)
The Name of the application using this class.
Contains the actual query to be processed.
The Database filename.
The default database filename permission mode.
Debugstate, default is OFF.
Error string of last sqlite operation (set in Print_Error()).
Flag indicates how the class should interact with errors
Internal connection handle.
Returns microtime in format s.mmmmm.
Used to measure SQL execution time.
Constructor of class.
Returns number of rows affected by most recent DML operation against $dbhandle.
Commits current transaction.
Note: Requires BEGIN TRANSACTION first! Without BEGIN TRANSACTION an auto-transaction is always auto-commited!
Performs the connection to a SQLite database file.
If anything goes wrong calls Print_Error(). You should set the defaults for your connection by setting database filename in dbdefs.inc.php and leave connect() parameters empty.
Disconnects from SQLite database.
You may optionally pass an external link identifier.
Escapes a given string with the 'sqlite_escape_string' method.
Always use this function to avoid SQL injections when adding dynamic data to SQLite! This function also handles the settings for magic_quotes_gpc, if this setting is enabled it will call stripslashes() first.
Fetches next row from result handle.
Returns either numeric array (SQL_NUM), associative array (SQL_ASSOC) or both (SQLITE_BOTH) for one data row as pointed to by result var.
Frees result returned by QueryResult().
Note that SQLite has nothing to free (?) so here only the internal query variable is set to an empty string.
Retrieve last SQLite error number.
Retrieve last SQLite error description.
Returns amount of time spend on queries executed by this class.
Returns last used auto_increment id.
Returns number of rows in a result set.
Note: This only works for statements returning a result set, for DML operations use AffectedRows() !
Handles output according to internal debug flag.
Prints out SQLite Error in own <div> container and exits.
Please note that this function does not return as long as you have not set DBOF_RETURN_ALL_ERRORS!
Single-Row query method.
Returns only the first row of a given query! Resflag can be one of SQLITE_NUM or SQLITE_ASSOC or SQLITE_BOTH depending on what kind of array you want to be returned.
Performs a multi-row query and returns result identifier.
Rollback current transaction.
Note: Requires BEGIN TRANSACTION first! Without BEGIN TRANSACTION an auto-transaction is always auto-commited!
Function allows debugging of SQL Queries.
$state can have these values:
Allows to set the handling of errors.
DEBUG: Debug to error.log
DEBUG: No Debug Info
DEBUG: Debug to screen
Connect and error handling.
If NO_ERRORS is set and an error occures, the class still reports an an error of course but the error shown is reduced to avoid showing sensible informations in a productive environment. Set RETURN_ALL_ERRORS if you want to handle errors yourself.
Connect and error handling.
If NO_ERRORS is set and an error occures, the class still reports an an error of course but the error shown is reduced to avoid showing sensible informations in a productive environment. Set RETURN_ALL_ERRORS if you want to handle errors yourself.
Connect and error handling.
If NO_ERRORS is set and an error occures, the class still reports an an error of course but the error shown is reduced to avoid showing sensible informations in a productive environment. Set RETURN_ALL_ERRORS if you want to handle errors yourself.
All defines for custom error codes *
All defines for custom error codes *
All defines for custom error codes *
All defines for custom error codes *
All defines for custom error codes *
Documentation generated on Sat, 07 Aug 2010 20:01:01 +0200 by phpDocumentor 1.4.3