MySQL4 Database Abstraction Layer

Compatible with: MySQL 3.23+ MySQL 4.0+ MySQL 4.1+ MySQL 5.0+

Located in /includes/db/mysql.php (line 30)

dbal
   |
   --dbal_mysql

mixed $multi_insert = true (line 33)

---

Redefinition of:

dbal::$multi_insert

mixed $mysql_version (line 32)

Inherited Variables

Inherited from dbal

dbal::$any_char
dbal::$curtime
dbal::$dbname
dbal::$db_connect_id
dbal::$html_hold
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 211)

Return number of affected rows

void sql_affectedrows ()

sql_connect (line 39)

Connect to server

• access: public

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 294)

Escape string used in sql query

void sql_escape ( $msg)

• $msg

sql_fetchrow (line 219)

Fetch current row

void sql_fetchrow ([ $query_id = false])

• $query_id

sql_freeresult (line 268)

Free sql result

void sql_freeresult ([ $query_id = false])

• $query_id

sql_nextid (line 260)

Get last inserted id after insert statement

void sql_nextid ()

sql_query (line 139)

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 240)

Seek to given row number

rownum is zero-based

void sql_rowseek ( $rownum,  &$query_id)

• $rownum
• &$query_id

sql_server_info (line 101)

Version information about used database

void sql_server_info ()

_sql_close (line 353)

Close sql connection

• access: private

void _sql_close ()

_sql_custom_build (line 317)

Build db-specific query data

• access: private

void _sql_custom_build ( $stage,  $data)

• $stage
• $data

_sql_error (line 333)

return sql error array

• access: private

void _sql_error ()

_sql_like_expression (line 308)

Build LIKE expression

• access: private

void _sql_like_expression ( $expression)

• $expression

_sql_query_limit (line 192)

Build LIMIT query

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

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

_sql_report (line 362)

Build db-specific report

• access: private

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

• $mode
• $query

_sql_transaction (line 110)

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()