Sqlsrv
extends AbstractAdapter
in package
SQL Server database adapter class
Tags
Table of Contents
- $connection : mixed
- Database connection object/resource
- $database : string
- Database
- $error : mixed
- Error string/object/resource
- $info : array<string|int, mixed>
- Database info
- $listener : CallableObject
- Query listener object/resource
- $options : mixed
- Database connection options
- $profiler : Profiler
- Query profiler
- $result : mixed
- Result object/resource
- $statement : mixed
- Statement object/resource
- $statementResult : bool
- Statement result
- $statementString : string
- Prepared statement string
- __construct() : mixed
- Constructor
- beginTransaction() : Sqlsrv
- Begin a transaction
- bindParams() : Sqlsrv
- Bind parameters to a prepared SQL query
- clearError() : AbstractAdapter
- Clear the error
- clearProfiler() : AbstractAdapter
- Clear query profiler
- commit() : Sqlsrv
- Commit a transaction
- connect() : Sqlsrv
- Connect to the database
- createSchema() : Schema
- Create Schema builder
- createSql() : Sql
- Create SQL builder
- disconnect() : void
- Disconnect from the database
- escape() : string
- Escape the value
- execute() : Sqlsrv
- Execute a prepared SQL query
- fetch() : array<string|int, mixed>
- Fetch and return a row from the result
- fetchAll() : array<string|int, mixed>
- Fetch and return all rows from the result
- getConnection() : mixed
- Get the connection object/resource
- getError() : mixed
- Get the error
- getLastId() : int
- Return the last ID of the last query
- getListener() : CallableObject
- Get query listener
- getNumberOfRows() : int
- Return the number of rows from the last query
- getOptions() : array<string|int, mixed>
- Get database connection options
- getProfiler() : Profiler
- Get query profiler
- getResult() : mixed
- Get the result object/resource
- getSqlSrvErrors() : mixed
- Get SQL Server errors
- getStatement() : mixed
- Get the statement object/resource
- getTables() : array<string|int, mixed>
- Return the tables in the database
- getVersion() : string
- Return the database version
- hasError() : bool
- Determine whether or not there is an error
- hasOptions() : bool
- Has database connection options
- hasResult() : bool
- Determine whether or not a result resource exists
- hasStatement() : bool
- Determine whether or not a statement resource exists
- hasTable() : bool
- Return if the database has a table
- isConnected() : bool
- Determine whether or not connected
- listen() : mixed
- Add query listener to the adapter
- prepare() : Sqlsrv
- Prepare a SQL query
- query() : Sqlsrv
- Execute a SQL query directly
- rollback() : Sqlsrv
- Rollback a transaction
- setError() : AbstractAdapter
- Set the error
- setOptions() : Sqlsrv
- Set database connection options
- setProfiler() : AbstractAdapter
- Set query profiler
- throwError() : void
- Throw a database error exception
Properties
$connection
Database connection object/resource
protected
mixed
$connection
= null
$database
Database
protected
string
$database
= null
$error
Error string/object/resource
protected
mixed
$error
= null
$info
Database info
protected
array<string|int, mixed>
$info
= []
$listener
Query listener object/resource
protected
CallableObject
$listener
= null
$options
Database connection options
protected
mixed
$options
= []
$profiler
Query profiler
protected
Profiler
$profiler
= null
$result
Result object/resource
protected
mixed
$result
= null
$statement
Statement object/resource
protected
mixed
$statement
= null
$statementResult
Statement result
protected
bool
$statementResult
= false
$statementString
Prepared statement string
protected
string
$statementString
= null
Methods
__construct()
Constructor
public
__construct([array<string|int, mixed> $options = [] ]) : mixed
Instantiate the SQL Server database connection object
Parameters
- $options : array<string|int, mixed> = []
Return values
mixed —beginTransaction()
Begin a transaction
public
beginTransaction() : Sqlsrv
Return values
Sqlsrv —bindParams()
Bind parameters to a prepared SQL query
public
bindParams(array<string|int, mixed> $params[, mixed $options = null ]) : Sqlsrv
Parameters
- $params : array<string|int, mixed>
- $options : mixed = null
Return values
Sqlsrv —clearError()
Clear the error
public
clearError() : AbstractAdapter
Return values
AbstractAdapter —clearProfiler()
Clear query profiler
public
clearProfiler() : AbstractAdapter
Return values
AbstractAdapter —commit()
Commit a transaction
public
commit() : Sqlsrv
Return values
Sqlsrv —connect()
Connect to the database
public
connect([array<string|int, mixed> $options = [] ]) : Sqlsrv
Parameters
- $options : array<string|int, mixed> = []
Return values
Sqlsrv —createSchema()
Create Schema builder
public
createSchema() : Schema
Return values
Schema —createSql()
Create SQL builder
public
createSql() : Sql
Return values
Sql —disconnect()
Disconnect from the database
public
disconnect() : void
Return values
void —escape()
Escape the value
public
escape(string $value) : string
Parameters
- $value : string
Return values
string —execute()
Execute a prepared SQL query
public
execute() : Sqlsrv
Return values
Sqlsrv —fetch()
Fetch and return a row from the result
public
fetch() : array<string|int, mixed>
Return values
array<string|int, mixed> —fetchAll()
Fetch and return all rows from the result
public
fetchAll() : array<string|int, mixed>
Return values
array<string|int, mixed> —getConnection()
Get the connection object/resource
public
getConnection() : mixed
Return values
mixed —getError()
Get the error
public
getError() : mixed
Return values
mixed —getLastId()
Return the last ID of the last query
public
getLastId() : int
Return values
int —getListener()
Get query listener
public
getListener() : CallableObject
Return values
CallableObject —getNumberOfRows()
Return the number of rows from the last query
public
getNumberOfRows() : int
Return values
int —getOptions()
Get database connection options
public
getOptions() : array<string|int, mixed>
Return values
array<string|int, mixed> —getProfiler()
Get query profiler
public
getProfiler() : Profiler
Return values
Profiler —getResult()
Get the result object/resource
public
getResult() : mixed
Return values
mixed —getSqlSrvErrors()
Get SQL Server errors
public
getSqlSrvErrors([bool $asString = true ]) : mixed
Parameters
- $asString : bool = true
Return values
mixed —getStatement()
Get the statement object/resource
public
getStatement() : mixed
Return values
mixed —getTables()
Return the tables in the database
public
getTables() : array<string|int, mixed>
Return values
array<string|int, mixed> —getVersion()
Return the database version
public
getVersion() : string
Return values
string —hasError()
Determine whether or not there is an error
public
hasError() : bool
Return values
bool —hasOptions()
Has database connection options
public
hasOptions() : bool
Return values
bool —hasResult()
Determine whether or not a result resource exists
public
hasResult() : bool
Return values
bool —hasStatement()
Determine whether or not a statement resource exists
public
hasStatement() : bool
Return values
bool —hasTable()
Return if the database has a table
public
hasTable(string $table) : bool
Parameters
- $table : string
Return values
bool —isConnected()
Determine whether or not connected
public
isConnected() : bool
Return values
bool —listen()
Add query listener to the adapter
public
listen(mixed $listener[, mixed $params = null ][, Profiler $profiler = null ]) : mixed
Parameters
- $listener : mixed
- $params : mixed = null
- $profiler : Profiler = null
Return values
mixed —prepare()
Prepare a SQL query
public
prepare(mixed $sql) : Sqlsrv
Parameters
- $sql : mixed
Return values
Sqlsrv —query()
Execute a SQL query directly
public
query(mixed $sql) : Sqlsrv
Parameters
- $sql : mixed
Return values
Sqlsrv —rollback()
Rollback a transaction
public
rollback() : Sqlsrv
Return values
Sqlsrv —setError()
Set the error
public
setError(string $error) : AbstractAdapter
Parameters
- $error : string
Return values
AbstractAdapter —setOptions()
Set database connection options
public
setOptions(array<string|int, mixed> $options) : Sqlsrv
Parameters
- $options : array<string|int, mixed>
Return values
Sqlsrv —setProfiler()
Set query profiler
public
setProfiler(Profiler $profiler) : AbstractAdapter
Parameters
- $profiler : Profiler
Return values
AbstractAdapter —throwError()
Throw a database error exception
public
throwError([string $error = null ]) : void
Parameters
- $error : string = null