$dsn
$dsn : string
Data Source Name / Connect string
MS SQL Database Adapter Class
Note: _DB is an extender class that the app controller creates dynamically based on whether the query builder class is being used or not.
query(string $sql, array $binds = FALSE, boolean $return_object = NULL) : mixed
Execute the query
Accepts an SQL string as input and returns a result object upon successful execution of a "read" type query. Returns boolean TRUE upon successful execution of a "write" type query. Returns boolean FALSE upon failure, and if the $db_debug variable is set to TRUE will raise an error.
| string | $sql | |
| array | $binds | = FALSE An array of binding data |
| boolean | $return_object | = NULL |
trans_strict(boolean $mode = TRUE) : void
Enable/disable Transaction Strict Mode
When strict mode is enabled, if you are running multiple groups of transactions, if one group fails all subsequent groups will be rolled back.
If strict mode is disabled, each group is treated autonomously, meaning a failure of one group will not affect any others
| boolean | $mode | = TRUE |
protect_identifiers( $item, $prefix_single = FALSE, $protect_identifiers = NULL, $field_exists = TRUE) : string
Protect Identifiers
This function is used extensively by the Query Builder class, and by a couple functions in this class. It takes a column or table name (optionally with an alias) and inserts the table prefix onto it. Some logic is necessary in order to deal with column names that include the path. Consider a query like this:
SELECT hostname.database.table.column AS c FROM hostname.database.table
Or a query with aliasing:
SELECT m.member_id, m.member_name FROM members AS m
Since the column name can include up to four segments (host, DB, table, column) or also have an alias prefix, we need to do a bit of work to figure this out and insert the table prefix (if it exists) in the proper position, and escape only the correct identifiers.
| $item | ||
| $prefix_single | ||
| $protect_identifiers | ||
| $field_exists |