| [ Index ] |
PHP Cross Reference of Unnamed Project |
[Source view] [Print] [Project Stats]
(no description)
| Copyright: | (c) 2005 phpBB Group |
| License: | http://opensource.org/licenses/gpl-license.php GNU Public License |
| Version: | $Id$ |
| File Size: | 370 lines (8 kb) |
| Included or required: | 0 times |
| Referenced: | 0 times |
| Includes or requires: | 0 files |
dbal_sqlite:: (16 methods):
sql_connect()
sql_server_info()
_sql_transaction()
sql_query()
_sql_query_limit()
sql_affectedrows()
sql_fetchrow()
sql_rowseek()
sql_nextid()
sql_freeresult()
sql_escape()
sql_like_expression()
_sql_error()
_sql_custom_build()
_sql_close()
_sql_report()
Class: dbal_sqlite - X-Ref
Sqlite Database Abstraction Layer| sql_connect($sqlserver, $sqluser, $sqlpassword, $database, $port = false, $persistency = false, $new_link = false) X-Ref |
| Connect to server |
| sql_server_info($raw = false, $use_cache = true) X-Ref |
| Version information about used database param: bool $raw if true, only return the fetched sql_server_version param: bool $use_cache if true, it is safe to retrieve the stored value from the cache return: string sql server version |
| _sql_transaction($status = 'begin') X-Ref |
| SQL Transaction |
| sql_query($query = '', $cache_ttl = 0) X-Ref |
| Base query method param: string $query Contains the SQL query which shall be executed param: int $cache_ttl Either 0 to avoid caching or the time in seconds which the result shall be kept in cache return: mixed When casted to bool the returned value returns true on success and false on failure |
| _sql_query_limit($query, $total, $offset = 0, $cache_ttl = 0) X-Ref |
| Build LIMIT query |
| sql_affectedrows() X-Ref |
| Return number of affected rows |
| sql_fetchrow($query_id = false) X-Ref |
| Fetch current row |
| sql_rowseek($rownum, &$query_id) X-Ref |
| Seek to given row number rownum is zero-based |
| sql_nextid() X-Ref |
| Get last inserted id after insert statement |
| sql_freeresult($query_id = false) X-Ref |
| Free sql result |
| sql_escape($msg) X-Ref |
| Escape string used in sql query |
| sql_like_expression($expression) X-Ref |
| Correctly adjust LIKE expression for special characters For SQLite an underscore is a not-known character... this may change with SQLite3 |
| _sql_error() X-Ref |
| return sql error array |
| _sql_custom_build($stage, $data) X-Ref |
| Build db-specific query data |
| _sql_close() X-Ref |
| Close sql connection |
| _sql_report($mode, $query = '') X-Ref |
| Build db-specific report |
| Generated: Wed Oct 2 15:03:47 2013 | Cross-referenced by PHPXref 0.7.1 |