SqlsrvDriver
class SqlsrvDriver implements Driver
The 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
Methods
No description
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
Encodes string for use in a LIKE statement.
Injects LIMIT/OFFSET to the SQL query.
Details
at line 45
__construct(array $config)
No description
at line 82
void
disconnect()
Disconnects from a database.
at line 92
ResultDriver|null
query(string $sql)
Executes the SQL query.
at line 112
int|null
getAffectedRows()
Gets the number of affected rows by the last INSERT, UPDATE or DELETE query.
at line 121
int|null
getInsertId(string|null $sequence)
Retrieves the ID generated for an AUTO_INCREMENT column by the previous INSERT query.
at line 136
void
begin(string $savepoint = null)
Begins a transaction (if supported).
at line 146
void
commit(string $savepoint = null)
Commits statements in a transaction.
at line 156
void
rollback(string $savepoint = null)
Rollback changes in a transaction.
at line 166
mixed
getResource()
Returns the connection resource.
at line 175
Reflector
getReflector()
Returns the connection reflector.
at line 185
SqlsrvResult
createResultDriver(resource $resource)
Result set driver factory.
at line 197
string
escapeText(string $value)
Encodes data for use in a SQL statement.
at line 203
string
escapeBinary(string $value)
No description
at line 209
string
escapeIdentifier(string $value)
No description
at line 216
string
escapeBool(bool $value)
No description
at line 225
string
escapeDate(DateTimeInterface|string|int $value)
No description
at line 237
string
escapeDateTime(DateTimeInterface|string|int $value)
No description
at line 249
string
escapeLike(string $value, int $pos)
Encodes string for use in a LIKE statement.
at line 259
void
applyLimit(string $sql, int|null $limit, int|null $offset)
Injects LIMIT/OFFSET to the SQL query.
Traits
Better OOP experience.