Kurulum
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 with several driver files. Which driver file you
use will depend on 3 factors: the PHP version you are using, whether you are
using thread-safe or non-thread-safe PHP, and whether your PHP installation
was compiled with the VC6 or VC9 compiler. For example, if you are running
PHP 5.3, you are using non-thread-safe PHP, and your PHP installation was
compiled with the VC9 compiler, you should use the php_pdo_sqlsrv_53_nts_vc9.dll
file. (You should use a non-thread-safe version compiled with the VC9 compiler
if you are using IIS as your web server). If you are running PHP 5.2, you are
using thread-safe PHP, and your PHP installation was compiled with the VC6
compiler, you should use the php_pdo_sqlsrv_52_ts_vc6.dll file.
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.
Öntanımlı Sabitler
Bu sabitler bu sürücü tarafından
tanımlanmış olup, sadece eklentinin PHP içinde derlenmiş olması veya çalışma
anında devingen olarak yüklenmesi halinde kullanılabilir. Ek olarak, bu
sürücüye özgü sabitler sadece bu sürücüyü kullanıyorsanız kullanılmalıdır.
Sürücüye özgü özniteliklerin postgres sürücüsü ile kullanılması beklenmedik
davranışlara yol açabilir. Eğer kodunuz çok sayıda sürücüye karşı çalışıyorsa
sürücüyü sınayacak PDO_ATTR_DRIVER_NAME özniteliğini
sağlamak için PDO::getAttribute()
kullanılabilir.
-
PDO::SQLSRV_TXN_READ_UNCOMMITTED
(integer)
-
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
(integer)
-
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
(integer)
-
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
(integer)
-
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
(integer)
-
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
(integer)
-
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
(integer)
-
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
(integer)
-
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
(integer)
-
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
(integer)
-
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
(integer)
-
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.