Instalarea
The PDO_SQLSRV extension is enabled by adding appropriate DLL file to your PHP
extension directory and the corresponding entry to the php.ini file. The
PDO_SQLSRV download comes 8 driver files, four of which are for PDO support.
If you are running non-thread-safe PHP (PHP 5.3), use the php_pdo_sqlsrv_53_nts.dll
file. (You should use a non-thread-safe version if you are using IIS as your
web server). If you are running thread-safe PHP, use the php_pdo_sqlsrv_53_ts.dll
file. Similarly for PHP 5.4, use the php_pdo_sqlsrv_54_nts.dll or php_pdo_sqlsrv_54_ts.dll
depending on whether your PHP installation is non-thread-safe or thread-safe.
The most recent version of the driver is available for download here:
» SQLSRV download. If you need support
for PHP 5.2 and/or PHP compiled with VC6, use the 2.0 release of the driver:
» SQLSRV 2.0 download.
The driver sources are hosted in a » public repository.
For more information about system requirements, see
» SQLSRV System Requirements.
The PDO_SQLSRV extension is only compatible with PHP running on Windows.
For Linux, see ODBC and
» Microsoft's SQL Server ODBC Driver for Linux.
Constante predefinite
Constantele de mai jos sunt definite de acest driver și vor fi disponibile
doar când această extensie a fost compilată în interiorul PHP, sau a fost
încărcată dinamic în timpul rulării. În plus, aceste constante specifice
driver-ului trebuie utilizate numai dacă utilizați acest driver.
Utilizarea atributelor specifice unui driver cu un alt driver poate rezulta
într-un comportament imprevizibil. PDO::getAttribute()
poate fi utilizată pentru a obține atributul PDO::ATTR_DRIVER_NAME
, pentru a verifica driver-ul în caz că codul-sursă al
dumneavoastră poate rula cu mai multe driver-e.
-
PDO::SQLSRV_TXN_READ_UNCOMMITTED
(int)
-
This constant is an acceptable value for the SQLSRV DSN key TransactionIsolation.
This constant sets the transaction isolation level for the connection to
Read Uncommitted.
-
PDO::SQLSRV_TXN_READ_COMMITTED
(int)
-
This constant is an acceptable value for the SQLSRV DSN key TransactionIsolation.
This constant sets the transaction isolation level for the connection to
Read Committed.
-
PDO::SQLSRV_TXN_REPEATABLE_READ
(int)
-
This constant is an acceptable value for the SQLSRV DSN key TransactionIsolation.
This constant sets the transaction isolation level for the connection to
Repeateable Read.
-
PDO::SQLSRV_TXN_SNAPSHOT
(int)
-
This constant is an acceptable value for the SQLSRV DSN key TransactionIsolation.
This constant sets the transaction isolation level for the connection to Snapshot.
-
PDO::SQLSRV_TXN_SERIALIZABLE
(int)
-
This constant is an acceptable value for the SQLSRV DSN key TransactionIsolation.
This constant sets the transaction isolation level for the connection to
Serializable.
-
PDO::SQLSRV_ENCODING_BINARY
(int)
-
Specifies that data is sent/retrieved as a raw byte stream to/from the server
without performing encoding or translation. This constant can be passed to
PDOStatement::setAttribute, PDO::prepare, PDOStatement::bindColumn, and
PDOStatement::bindParam.
-
PDO::SQLSRV_ENCODING_SYSTEM
(int)
-
Specifies that data is sent/retrieved to/from the server as 8-bit characters
as specified in the code page of the Windows locale that is set on the system.
Any multi-byte characters or characters that do not map into this code page
are substituted with a single byte question mark (?) character. This constant
can be passed to PDOStatement::setAttribute, PDO::setAttribute, PDO::prepare,
PDOStatement::bindColumn, and PDOStatement::bindParam.
-
PDO::SQLSRV_ENCODING_UTF8
(int)
-
Specifies that data is sent/retrieved to/from the server in UTF-8 encoding.
This is the default encoding. This constant can be passed to
PDOStatement::setAttribute, PDO::setAttribute, PDO::prepare,
PDOStatement::bindColumn, and PDOStatement::bindParam.
-
PDO::SQLSRV_ENCODING_DEFAULT
(int)
-
Specifies that data is sent/retrieved to/from the server according to
PDO::SQLSRV_ENCODING_SYSTEM if specified during connection. The connection's
encoding is used if specified in a prepare statement. This constant can be
passed to PDOStatement::setAttribute, PDO::setAttribute, PDO::prepare,
PDOStatement::bindColumn, and PDOStatement::bindParam.
-
PDO::SQLSRV_ATTR_QUERY_TIMEOUT
(int)
-
A non-negative integer representing the timeout period, in seconds. Zero (0)
is the default and means no timeout. This constant can be passed to
PDOStatement::setAttribute, PDO::setAttribute, and PDO::prepare.
-
PDO::SQLSRV_ATTR_DIRECT_QUERY
(int)
-
Indicates that a query should be executed directly, without being prepared.
This constant can be passed to PDO::setAttribute, and PDO::prepare. For more
information, see
» Direct and Prepared Statement Execution.