mssqlnative

Should we return on errors, or stop

Should we return the number of cached or normal queries?

Number of queries that have been executed

Is this query cached?

False if no connection was opened before, Server response otherwise

The SQL query to execute

The number of rows to select

Either 0 to avoid caching or the time in seconds which the result shall be kept in cache

Buffered, seekable result handle, false on error

Already executed query to get the rows from, if false, the last query will be used.

Nested array if the query had rows, false otherwise

Row number the curser should point to Note: $rownum is 0 based

ID of the query to set the row cursor on if false, the last query will be used. $query_id will then be set correctly

False if something went wrong

Name of the column

Row number, if false the current row will be used and the row curser will point to the next row Note: $rownum is 0 based

Already executed query to get the rows from, if false, the last query will be used.

String value of the field in the selected row, false, if the row does not exist

The expression to use. Every wildcard is escaped, except $this->any_char and $this->one_char

A SQL statement like: "LIKE 'bertie_%'"

The expression to use. Every wildcard is escaped, except $this->any_char and $this->one_char

A SQL statement like: "NOT LIKE 'bertie_%'"

The condition which must be true, to use action_true rather then action_else

SQL expression that is used, if the condition is true

SQL expression that is used, if the condition is false

CASE expression including the condition and statements

Base SQL expression where we append the second one

SQL expression that is appended to the first expression

Concatenated string

Whether buffering is required.

Should be one of the following strings: begin, commit, rollback

Buffered, seekable result handle, false on error

Should be on of the following strings: INSERT, INSERT_SELECT, UPDATE, SELECT, DELETE

Array with "column => value" pairs

A SQL statement like "c1 = 'a' AND c2 = 'b'"

Name of the sql column that shall be compared

Array of values that are (not) allowed

true for NOT IN (), false for IN ()

If true, allow $array to be empty, this function will return 1=1 or 1=0 then.

A SQL statement like: "IN (1, 2, 3, 4)" or "= 1"

The column name to use

The value to use for the AND operator, will be converted to (1 << $bit). Is used by options, using the number schema: 0, 1, 2...29

Any custom SQL code after the check (for example "= 0")

A SQL statement like: "{$column} & (1 << {$bit}) {$compare}"

The column name to use

The value to use for the OR operator, will be converted to (1 << $bit). Is used by options, using the number schema... 0, 1, 2...29

Any custom SQL code after the check (e.g. "= 0")

A SQL statement like "$column | (1 << $bit) {$compare}"

An expression evaluating to string

Expression returning an int

Auto-incremented value of the last inserted row

An expression evaluating to int

Expression returning a string

The column name to use

A SQL statement like "LOWER($column_name)"

Table name to run the statements on

Multi-dimensional array holding the statement data

false if no statements were executed.

Should be one of: SELECT, SELECT_DISTINCT

Array with the query data: SELECT A comma imploded list of columns to select FROM Array with "table => alias" pairs, (alias can also be an array) Optional: LEFT_JOIN Array of join entries: FROM Table that should be joined ON Condition for the join Optional: WHERE Where SQL statement Optional: GROUP_BY Group by SQL statement Optional: ORDER_BY Order by SQL statement

A SQL statement ready for execution

The SQL query causing the error

Returns the full error message, if $this->return_on_error is set, null otherwise

Available modes: display, start, stop, add_select_row, fromcache, record_fromcache

The Query that should be explained

Either a full HTML page, boolean or null

Table name

Number of rows in $table_name. Prefixed with ~ if estimated (otherwise exact).

Table name

Exact number of rows in $table_name.

Mixed type query id

Query id in string or integer format

String to be escaped

Escaped version of $msg

String to be quoted

Quoted version of $msg

Address of the database server

User name of the SQL user

Password of the SQL user

Name of the database

Port of the database server

Should a new connection be established

Connection ID on success, string error message otherwise

Only return the fetched sql_server_version

Is it safe to retrieve the value from the cache

sql server version

The SQL query to execute

Either 0 to avoid caching or the time in seconds which the result shall be kept in cache

Buffered, seekable result handle, false on error

Number of the affected rows by the last query false if no query has been run before

Already executed query to get the rows from, if false, the last query will be used.

Array with the current row, false, if the row does not exist

Auto-incremented value of the last inserted row

Already executed query result, if false, the last query will be used.