PHP辅攻_[学习资料收集]PHP连接SQLServer2005方法

1.

php.in将mssql.secure_connection = Off改为mssql.secure_connection = On。

连接2005的 ntwdblib.dll (2000.80.194.0)

X:\AppServ\php5\ext ，

 

服务

 

<?<span php
 </span><span $conn</span>=mssql_connect('59.173.xxxxxx.xxxxxx,1468','sa','xxxxxx'<span ); 
   mssql_select_db(</span>'HR',<span $conn</span><span ); 
 
 </span><span $Query</span>="select * from Class"<span ; 
 </span><span $Result</span>=mssql_query(<span $Query</span><span ); 

 </span><span $Number</span>=mssql_num_rows(<span $Result</span><span ); 
 </span><span for</span>(<span $i</span>=0;<span $i</span><<span $Number</span>;<span $i</span>++<span ) 
   { 
 </span><span $Row</span>=mssql_fetch_array(<span $Result</span><span ); 
 </span><span echo</span>(<span $Row</span>[1<span ]); 
 </span><span echo</span>("<br/>"<span ); 
   }   
</span>?>

 

 

来源:http://blog.csdn.net/gumanren/article/details/4673674