Database independent query interface This is a wrapper for the PHP PDO

Located in /lib/Roundcube/rcube_db_sqlsrv.php (line 27)

rcube_db
   |
   --rcube_db_sqlsrv

mixed $db_provider = 'mssql' (line 29)

• access: public

---

Redefinition of:

rcube_db::$db_provider

Inherited Variables

Inherited from rcube_db

rcube_db::$conn_failure
rcube_db::$dbh
rcube_db::$db_connected
rcube_db::$db_dsnr
rcube_db::$db_dsnw
rcube_db::$db_error
rcube_db::$db_error_msg
rcube_db::$db_index
rcube_db::$db_mode
rcube_db::$last_result
rcube_db::$options
rcube_db::$tables
rcube_db::$variables

concat (line 79)

Abstract SQL statement for value concatenation

• return: SQL statement to be used in query
• access: public

string concat ()

---

Redefinition of:

rcube_db::concat()

Abstract SQL statement for value concatenation

dsn_string (line 133)

Returns PDO DSN string from DSN array

• access: protected

void dsn_string ( $dsn)

• $dsn

---

Redefinition of:

rcube_db::dsn_string()

Returns PDO DSN string from DSN array

init (line 34)

Driver initialization

• access: protected

void init ()

---

Redefinition of:

rcube_db::init()

Initialization of the object with driver specific code

now (line 53)

Return SQL function for current time and date

• return: SQL function to use in query
• access: public

string now ()

---

Redefinition of:

rcube_db::now()

Return SQL function for current time and date

set_charset (line 43)

Database character set setting

• access: protected

void set_charset ( $charset)

• $charset

---

Redefinition of:

rcube_db::set_charset()

Driver-specific database character set setting

set_limit (line 99)

Adds TOP (LIMIT,OFFSET) clause to the query

• return: SQL query
• access: protected

string set_limit (string $query, [int $limit = 0], [int $offset = 0])

• string $query: SQL query
• int $limit: Number of rows
• int $offset: Offset

---

Redefinition of:

rcube_db::set_limit()

Adds LIMIT,OFFSET clauses to the query

unixtimestamp (line 69)

Return SQL statement to convert a field value into a unix timestamp

This method is deprecated and should not be used anymore due to limitations of timestamp functions in Mysql (year 2038 problem)

• return: SQL statement to use in query
• deprecated:
• access: public

string unixtimestamp (string $field)

• string $field: Field name

---

Redefinition of:

rcube_db::unixtimestamp()

Return SQL statement to convert a field value into a unix timestamp

Inherited Methods

Inherited From rcube_db

rcube_db::__construct()
rcube_db::affected_rows()
rcube_db::array2list()
rcube_db::concat()
rcube_db::conn_configure()
rcube_db::conn_prepare()
rcube_db::db_connect()
rcube_db::debug()
rcube_db::decode()
rcube_db::dsn_connect()
rcube_db::dsn_options()
rcube_db::dsn_string()
rcube_db::encode()
rcube_db::escape()
rcube_db::escapeSimple()
rcube_db::factory()
rcube_db::fetch_array()
rcube_db::fetch_assoc()
rcube_db::fromunixtime()
rcube_db::get_variable()
rcube_db::ilike()
rcube_db::init()
rcube_db::insert_id()
rcube_db::is_connected()
rcube_db::is_error()
rcube_db::is_replicated()
rcube_db::limitquery()
rcube_db::list_cols()
rcube_db::list_tables()
rcube_db::now()
rcube_db::num_rows()
rcube_db::parse_dsn()
rcube_db::query()
rcube_db::quote()
rcube_db::quoteIdentifier()
rcube_db::quote_identifier()
rcube_db::set_charset()
rcube_db::set_debug()
rcube_db::set_limit()
rcube_db::table_name()
rcube_db::unixtimestamp()
rcube_db::_fetch_row()
rcube_db::_query()