What are the five ways to connect php to sqlserver?-PHP Problem-php.cn

What are the five ways to connect php to sqlserver?

尊渡假赌尊渡假赌尊渡假赌

Release： 2023-06-02 11:59:50

Original

5482 people have browsed it

The five methods for PHP to connect to SQL Server are as follows: 1. Use the "mssql_connect()" function; 2. Use the "sqlsrv_connect()" function; 3. Use the PDO class connection; 4. Use "odbc_connect()" Function; 5. Use COM object mode to connect.

What are the five ways to connect php to sqlserver?

Operating system for this tutorial: Windows 10 system, php8.1.3 version, Dell G3 computer.

The five methods for php to connect to sqlserver are:

1. Use the "mssql_connect()" function

$server = &#39;localhost&#39;;
$username = &#39;sa&#39;;
$password = &#39;&#39;;
$database = &#39;example_db&#39;;
$conn = mssql_connect($server, $username, $password);
mssql_select_db($database, $conn);

Copy after login

2. Use "sqlsrv_connect ()" function

$server = &#39;localhost&#39;;
$username = &#39;sa&#39;;
$password = &#39;&#39;;
$database = &#39;example_db&#39;;
$conn = sqlsrv_connect($server, array(&#39;UID&#39;=>$username, &#39;PWD&#39;=>$password, &#39;Database&#39;=>$database));

Copy after login

3. Use PDO class connection

$server = &#39;localhost&#39;;
$username = &#39;sa&#39;;
$password = &#39;&#39;;
$database = &#39;example_db&#39;;
try {
    $conn = new PDO("sqlsrv:Server=$server;Database=$database", $username, $password);
}
catch(PDOException $e) {
    die("Error connecting to SQL Server: " . $e->getMessage());
}

Copy after login

4. Use "odbc_connect()" function

$dsn = &#39;Driver={SQL Server};Server=localhost;Database=example_db&#39;;
$username = &#39;sa&#39;;
$password = &#39;&#39;;
$conn = odbc_connect($dsn, $username, $password);

Copy after login

5. Use COM object method to connect

$conn = new COM(&#39;ADODB.Connection&#39;);
$dsn = &#39;Driver={SQL Server};Server=localhost;Database=example_db&#39;;
$conn->Open($dsn, &#39;sa&#39;, &#39;&#39;);

Copy after login

The above is the detailed content of What are the five ways to connect php to sqlserver?. For more information, please follow other related articles on the PHP Chinese website!