SqlsrvDriver
class SqlsrvDriver implements Driver, ResultDriver
The dibi driver for Microsoft SQL Server and SQL Azure databases.
Driver options:
- host => the MS SQL server host name. It can also include a port number (hostname:port)
- username (or user)
- password (or pass)
- database => the database name to select
- options (array) => connection options https://msdn.microsoft.com/en-us/library/cc296161(SQL.90).aspx
- charset => character encoding to set (default is UTF-8)
- resource (resource) => existing connection resource
- lazy, profiler, result, substitutes, ... => see Dibi\Connection options
Methods
No description
Connects to a database.
Disconnects from a database.
Executes the SQL query.
Gets the number of affected rows by the last INSERT, UPDATE or DELETE query.
Retrieves the ID generated for an AUTO_INCREMENT column by the previous INSERT query.
Begins a transaction (if supported).
Commits statements in a transaction.
Rollback changes in a transaction.
Returns the connection resource.
Returns the connection reflector.
Result set driver factory.
Encodes data for use in a SQL statement.
No description
No description
No description
No description
No description
Encodes string for use in a LIKE statement.
Decodes data from result set.
Injects LIMIT/OFFSET to the SQL query.
Automatically frees the resources allocated for this result set.
Returns the number of rows in a result set.
Fetches the row at current position and moves the internal cursor to the next position.
Moves cursor position without fetching row.
Frees the resources allocated for this result set.
Returns metadata for all columns in a result set.
Returns the result set resource.
Details
at line 50
__construct()
No description
at line 63
void
connect(array $config)
Connects to a database.
at line 99
void
disconnect()
Disconnects from a database.
at line 111
ResultDriver|null
query($sql)
Executes the SQL query.
at line 132
int|false
getAffectedRows()
Gets the number of affected rows by the last INSERT, UPDATE or DELETE query.
at line 142
int|false
getInsertId($sequence)
Retrieves the ID generated for an AUTO_INCREMENT column by the previous INSERT query.
at line 159
void
begin($savepoint = null)
Begins a transaction (if supported).
at line 171
void
commit($savepoint = null)
Commits statements in a transaction.
at line 183
void
rollback($savepoint = null)
Rollback changes in a transaction.
at line 193
mixed
getResource()
Returns the connection resource.
at line 203
Reflector
getReflector()
Returns the connection reflector.
at line 214
ResultDriver
createResultDriver($resource)
Result set driver factory.
at line 230
string
escapeText($value)
Encodes data for use in a SQL statement.
at line 240
string
escapeBinary($value)
No description
at line 250
string
escapeIdentifier($value)
No description
at line 261
string
escapeBool($value)
No description
at line 271
string
escapeDate($value)
No description
at line 284
string
escapeDateTime($value)
No description
at line 299
string
escapeLike($value, $pos)
Encodes string for use in a LIKE statement.
at line 311
string
unescapeBinary($value)
Decodes data from result set.
at line 318
escape($value, $type)
deprecated
deprecated
No description
at line 332
void
applyLimit($sql, $limit, $offset)
Injects LIMIT/OFFSET to the SQL query.
at line 362
void
__destruct()
Automatically frees the resources allocated for this result set.
at line 372
int
getRowCount()
Returns the number of rows in a result set.
at line 383
array
fetch($assoc)
Fetches the row at current position and moves the internal cursor to the next position.
at line 394
bool
seek($row)
Moves cursor position without fetching row.
at line 404
void
free()
Frees the resources allocated for this result set.
at line 415
array
getResultColumns()
Returns metadata for all columns in a result set.
at line 433
mixed
getResultResource()
Returns the result set resource.
Traits
Better OOP experience.