PHP 连接 MSSQL

1 设置

 

 

 

2 php 代码:

<?php
header('Content-Type:text/html; charset=GBK');



define('DB_HOST','localhost');
define('DB_USER','xxxx');
define('DB_PWD','xxxx');
define('DB_NAME', 'xxxx');
//连接服务器
$conn= mssql_connect(DB_HOST,DB_USER,DB_PWD) or die("SQL SERVER 数据库连接失败！");  ;
//选择数据库
mssql_select_db(DB_NAME, $conn);
//执行
$sqlstr='SELECT top 100 cast(accountid as varchar(36)) accountid, name FROM account';
$result=mssql_query($sqlstr); 
$Num=mssql_num_rows($result);

for($i=0;$i<$Num;$i++) 
{ 
$Row=mssql_fetch_array($result); 
 echo   $Row[0] ."--" .$Row[1] ."<br/>";
} 
mssql_free_result($result);
mssql_close($conn);
?>