PHP » GoLang |
login |
register |
about
|
sqlsrv_connect(No version information available, might only be in Git) sqlsrv_connect — Opens a connection to a Microsoft SQL Server database Description
resource sqlsrv_connect
( string
$serverName
[, array $connectionInfo
] )Opens a connection to a Microsoft SQL Server database. By default, the connection is attempted using Windows Authentication. To connect using SQL Server Authentication, include "UID" and "PWD" in the connection options array. Parameters
Return Values
A connection resource. If a connection cannot be successfully opened, Examples
Example #1 Connect using Windows Authentication.
<?php
Example #2 Connect by specifying a user name and password.
<?php
Example #3 Connect on a specifed port.
<?php Notes
By default, the sqlsrv_connect() uses connection pooling to
improve connection performance. To turn off connection pooling (i.e. force a
new connection on each call), set the "ConnectionPooling" option in the
$connectionOptions array to 0 (or The SQLSRV extension does not have a dedicated function for changing which database is connected to. The target database is specified in the $connectionOptions array that is passed to sqlsrv_connect. To change the database on an open connection, execute the following query "USE dbName" (e.g. sqlsrv_query($conn, "USE dbName")). See Also
|
more
Recently updated
more
Most requested
more
Last requests
|