Summary of methods for connecting php to MSsql server

This time I will bring you a summary of the methods of php connecting to MSsql server. What are the precautions of the method of php connecting to MSsql server. The following is a practical case, let's take a look.

1. Through mssql_ series functions

mssql_ series functions are mainly used for versions below php5.3 and sqlserver2000 and above.

In php.ini, remove the semicolon in front of;extension=php_mssql.dll;extension=php_msql.dll;extension=php_pdo_mssql.dll;extension=php_pdo_odbc.dll.

<?php
 $server ="localhost"; //服务器IP地址,如果是本地，可以写成localhost
 $uid ="sa"; //用户名
 $pwd ="123456"; //密码
 $database ="jb51net"; //数据库名称
 
////进行数据库连接
 $conn =mssql_connect($server,$uid,$pwd) or die ("connect failed");
 mssql_select_db($database,$conn);
 
////执行查询语句
 $query ="select * from A_PHP";
 $row =mssql_query($query);
 
////打印输出查询结果
 while($list=mssql_fetch_array($row))
 {
    print_r($list);
    echo "<br>";
 }
?>

2. Through the sqlsrv_ series of functions

sqlsrv_ series of functions are mainly aimed at php5.3 or above and sql server 2005 or above use.

You need to download and install the Microsoft Drivers for PHP for SQL Server driver, address: https://msdn.microsoft.com/library/dn865013.aspx. After downloading, unzip it and put it in the ext directory corresponding to php. Then open the php.ini file and add the configuration after extension

extension=php_pdo_sqlsrv_53_ts.dll
extension=php_sqlsrv_53_ts.dll

Restart apache and check phpinfo( ), make sure apache already supports sqlsrv. As shown in the figure below:

And install sqlncli.msi. This file is to assist windows environmentto access the database server where the sql server is located

<?php
 $serverName = "localhost";
 $connectionInfo = array( "Database"=>"jb51net", "UID"=>"sa", "PWD"=>"123456");
 $conn = sqlsrv_connect( $serverName, $connectionInfo );
 if( $conn === false ) {
   die( print_r( sqlsrv_errors(), true));
 }
 $sql = "SELECT * FROM dbo.A_PHP";
 $stmt = sqlsrv_query( $conn, $sql );
 if( $stmt === false) {
   die( print_r( sqlsrv_errors(), true) );
 }
 while($row = sqlsrv_fetch_array($stmt))
 {echo $row[0]."-----".$row[1]."<br/>";}
?>

3. Connect the sqlserver series through odbc method.

You need to enable the php_pdo_odbc.dll extension in php.ini.

<?php
$con = odbc_connect('DRIVER={SQL Server};SERVER=localhost;DATABASE=jb51net,'sa','123456');
$query = "SELECT * FROM dbo.A_PHP";
$result = odbc_do($con,$query);
while(odbc_fetch_row($result))
{
  $list = odbc_result($result, "id");	print_r($list);echo '<br/>';
}
?>

4. Connect to sqlserver through PDO.

Enable the php_pdo_mssql.dll extension in php.ini. You can view

<?php
 $conn = new PDO("sqlsrv:server=localhost;database=jb51net","sa","123456");
 $sql = "select count(*) count from CKXS2";
 $res = $conn->query($sql);
 while ($row = $res->fetch()){
 print_r($row);
 }
?>

in phpinfo. 5. Connect through COM.

The following is the implementation code:

<?php
 $conn = new Com("ADODB.Connection"); //实例化一个Connection对象 
 $connstr = "provider=sqloledb;datasource=.;uid=sa;pwd=123456;database=jb51net;"; 
 $conn->Open($connstr); 
 $rs = new Com("ADODB.Recordset"); //实例化一个Recordcount对象 
 $rs->Open('select * from CKXS2 ', $conn, 1, 1); 
 $count = $rs->RecordCount; 
 echo "共有{$count}条纪录<br />"; 
?>

I believe you have mastered the method after reading the case in this article. For more exciting information, please pay attention to other related articles on the PHP Chinese website!

Recommended reading:

What are the methods for php to read local json files

What are the methods for php to output json objects The value of

The above is the detailed content of Summary of methods for connecting php to MSsql server. For more information, please follow other related articles on the PHP Chinese website!