Sqlite Database Abstraction Layer

Minimum Requirement: 2.8.2+

Located in /includes/db/sqlite.php (line 26)

dbal
   |
   --dbal_sqlite

Inherited Variables

Inherited from dbal

dbal::$any_char
dbal::$curtime
dbal::$dbname
dbal::$db_connect_id
dbal::$html_hold
dbal::$multi_insert
dbal::$num_queries
dbal::$one_char
dbal::$open_queries
dbal::$persistency
dbal::$query_hold
dbal::$query_result
dbal::$return_on_error
dbal::$server
dbal::$sql_error_returned
dbal::$sql_error_sql
dbal::$sql_error_triggered
dbal::$sql_layer
dbal::$sql_report
dbal::$sql_time
dbal::$transaction
dbal::$transactions
dbal::$user

sql_affectedrows (line 162)

Return number of affected rows

void sql_affectedrows ()

sql_connect (line 31)

Connect to server

void sql_connect ( $sqlserver,  $sqluser,  $sqlpassword,  $database, [ $port = false], [ $persistency = false], [ $new_link = false])

• $sqlserver
• $sqluser
• $sqlpassword
• $database
• $port
• $persistency
• $new_link

sql_escape (line 239)

Escape string used in sql query

void sql_escape ( $msg)

• $msg

sql_fetchrow (line 170)

Fetch current row

void sql_fetchrow ([ $query_id = false])

• $query_id

sql_freeresult (line 219)

Free sql result

void sql_freeresult ([ $query_id = false])

• $query_id

sql_like_expression (line 248)

Correctly adjust LIKE expression for special characters

For SQLite an underscore is a not-known character... this may change with SQLite3

void sql_like_expression ( $expression)

• $expression

---

Redefinition of:

dbal::sql_like_expression()

Correctly adjust LIKE expression for special characters Some DBMS are handling them in a different way

sql_nextid (line 211)

Get last inserted id after insert statement

void sql_nextid ()

sql_query (line 91)

Base query method

• return: When casted to bool the returned value returns true on success and false on failure
• access: public

mixed sql_query ([string $query = ''], [int $cache_ttl = 0])

• string $query: Contains the SQL query which shall be executed
• int $cache_ttl: Either 0 to avoid caching or the time in seconds which the result shall be kept in cache

sql_rowseek (line 191)

Seek to given row number

rownum is zero-based

void sql_rowseek ( $rownum,  &$query_id)

• $rownum
• &$query_id

sql_server_info (line 53)

Version information about used database

void sql_server_info ()

_sql_close (line 285)

Close sql connection

• access: private

void _sql_close ()

_sql_custom_build (line 276)

Build db-specific query data

• access: private

void _sql_custom_build ( $stage,  $data)

• $stage
• $data

_sql_error (line 264)

return sql error array

• access: private

void _sql_error ()

_sql_query_limit (line 144)

Build LIMIT query

void _sql_query_limit ( $query,  $total, [ $offset = 0], [ $cache_ttl = 0])

• $query
• $total
• $offset
• $cache_ttl

_sql_report (line 294)

Build db-specific report

• access: private

void _sql_report ( $mode, [ $query = ''])

• $mode
• $query

_sql_transaction (line 62)

SQL Transaction

• access: private

void _sql_transaction ([ $status = 'begin'])

• $status

Inherited Methods

Inherited From dbal

dbal::dbal()
dbal::sql_add_num_queries()
dbal::sql_build_array()
dbal::sql_build_query()
dbal::sql_close()
dbal::sql_error()
dbal::sql_fetchfield()
dbal::sql_fetchrowset()
dbal::sql_in_set()
dbal::sql_like_expression()
dbal::sql_multi_insert()
dbal::sql_num_queries()
dbal::sql_query_limit()
dbal::sql_report()
dbal::sql_return_on_error()
dbal::sql_transaction()
dbal::_sql_validate_value()