How to connect php to mssql database

The methods for php to connect to mssql database include using PHP's MSSQL extension, using PDO, etc. Detailed introduction: 1. Use PHP's MSSQL extension method to ensure that PHP has the MSSQL extension installed. You can check whether the mssql extension is enabled in the PHP configuration file (php.ini); 2. Use the PDO method to ensure that PHP has the PDO extension installed. You can check whether the pdo_sqlsrv extension is enabled in the PHP configuration file (php.ini).

#In PHP, you can use a variety of methods to connect to an MSSQL database. Here are two common methods:

In PHP, you can use multiple methods to connect to an MSSQL database. The following are two common methods:

1. Use the MSSQL extension of PHP:

Make sure your PHP has the MSSQL extension installed. You can check whether the mssql extension is enabled in the PHP configuration file (php.ini).

Create a PHP file named connect.php and add the following code:

php`<?php   
$serverName = "localhost"; // MSSQL服务器名称或IP地址  
$connectionOptions = array(  
    "Database" => "your_database", // 数据库名称  
    "Uid" => "your_username", // 数据库用户名  
    "PWD" => "your_password" // 数据库密码  
);  
  
// 建立连接  
$conn = sqlsrv_connect($serverName, $connectionOptions);  
  
if ($conn === false) {  
    die(print_r(sqlsrv_errors(), true));  
}  
  
// 连接成功，执行其他操作...  
?>`

After saving the file, PHP will try to connect to the MSSQL database by accessing the file. If the connection is successful, you will see the message "Connected to MSSQL database successfully" on the page.

2. Use PDO (PHP Data Objects):

Make sure your PHP has the PDO extension installed. You can check whether the pdo_sqlsrv extension is enabled in the PHP configuration file (php.ini).

Create a PHP file named connect.php and add the following code:

php`<?php   
$serverName = "localhost"; // MSSQL服务器名称或IP地址  
$database = "your_database"; // 数据库名称  
$username = "your_username"; // 数据库用户名  
$password = "your_password"; // 数据库密码  
$driver = &#39;{pdo_sqlsrv}&#39;; // 根据你的PHP配置选择合适的驱动程序  
  
try {  
    $conn = new PDO($driver, $username, $password, array(PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION));  
    $conn->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_ASSOC);  
    $conn->setAttribute(PDO::ATTR_EMULATE_PREPARES, false);  
    $conn->setAttribute(PDO::SQLSRV_ATTR_INIT_COMMAND, "SET NAMES 'UTF8'"); // 设置字符集为UTF-8（如果需要）  
    $conn->setAttribute(PDO::SQLSRV_ATTR_SERVERTYPE, PDO::SQLSRV_SERVERTYPE_MSSQL); // 设置服务器类型为MSSQL  
    $conn->setAttribute(PDO::SQLSRV_ATTR_DIRECTCALLS, true); // 根据需要启用或禁用直接调用（默认为false）  
    $conn->setAttribute(PDO::SQLSRV_ATTR_CURSOR, PDO::SQLSRV_CURSOR_STATIC); // 根据需要设置游标类型（默认为静态游标）  
    $conn->setAttribute(PDO::SQLSRV_ATTR_SQLAUTHENTICATION, PDO::SQLSRV_SQLAUTHENTICATION_TRUSTED_AUTH); // 设置SQL验证模式（默认为受信任的连接）  
    $conn->setAttribute(PDO::SQLSRV_ATTR_CONNECTTIMEOUT, 30); // 设置连接超时时间（秒）  
    $conn->setAttribute(PDO::SQLSRV_ATTR_CLIENTTIMEOUT, 0); // 设置客户端超时时间（秒，默认为0）  
    $conn->setAttribute(PDO::SQLSRV_ATTR_CALLSPARAMS, array('CharacterSet' => 'UTF-8')); // 根据需要设置调用参数（默认为UTF-8）  
    $conn->setAttribute(PDO::SQLSRV_ATTR_CALLOPTIONS, array('MultipleActiveResultSets' => false)); // 根据需要设置调用选项（默认为false）  
    $conn->setAttribute(PDO::SQLSRV_ATTR_SSL, array('SSL' => array('Key' => '', 'Cert' => '', 'CA' => '', 'VerifyPeerCertificate' => false))); // 根据需要设置SSL连接选项（默认为false）  
    $conn->setAttribute(PDO::SQLSRV_ATTR_IGNORE_DRIVER_WARNINGS, true); // 根据需要忽略驱动程序警告

The above is the detailed content of How to connect php to mssql database. For more information, please follow other related articles on the PHP Chinese website!