How to connect to MSsql server using php-PHP Tutorial-php.cn

How to connect to MSsql server using php

php中世界最好的语言

Release： 2023-03-22 08:42:02

Original

1473 people have browsed it

This time I will show you how to use php to connect to MSsql server, and what are the precautions to use php to connect 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>";
 }
?>

Copy after login

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/>";}
?>

Copy after login

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/>';
}
?>

Copy after login

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);
 }
?>

Copy after login

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 />"; 
?>

Copy after login

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!