php通过什么连接sql server,怎么用php连接sql server数据库?

我用的PHP版本是php5.6.12,mssql数据库版本为2008

两种途径：

1、直接连接

$servname="CAPTAINHERO567";

$conninfo=array( "Database"=>"netdata", "UID"=>"lxz2005", "PWD"=>"831140");

$conn=sqlsrv_connect($servname, $conninfo);

$sql="select * from Pinfo";

$db=sqlsrv_query($conn, $sql);

while($row=sqlsrv_fetch_array($db))

{

echo("

".iconv("GB2312","UTF-8",$row["Pname"])."

");

}

2、使用PDO抽象数据层连接

$hostname = "192.168.1.100";

$dbname = "Northwind";

$username = "sa";

$pwd = "pwd100";

$dsn="sqlsrv:Server=$hostname;database=$dbname";

$conn = new PDO ($dsn,$username,$pwd);

$conn->setAttribute(PDO::ATTR_ERRMODE,PDO::ERRMODE_EXCEPTION);

echo "mssql database connnection sucessed!";

取消

评论