???? PHP? ???? MSSQL ??? ???? ??? ??? ?? ??? ?????. Notes? ???? PHP? MSSQL ??? ???? ??? ?? ??? ??? ????. ??.

1. mssql_ ??? ??? ??

mssql_ ??? ??? php5.3 ?? ??? sqlserver2000 ?? ???? ?? ?????.

php.ini??;extension=php_mssql.dll;extension=php_msql.dll;extension=php_pdo_mssql.dll;extension=php_pdo_odbc.dll ?? ????? ?????.

<?php
 $server ="localhost"; //服務(wù)器IP地址,如果是本地，可以寫成localhost
 $uid ="sa"; //用戶名
 $pwd ="123456"; //密碼
 $database ="jb51net"; //數(shù)據(jù)庫名稱
 
////進行數(shù)據(jù)庫連接
 $conn =mssql_connect($server,$uid,$pwd) or die ("connect failed");
 mssql_select_db($database,$conn);
 
////執(zhí)行查詢語句
 $query ="select * from A_PHP";
 $row =mssql_query($query);
 
////打印輸出查詢結(jié)果
 while($list=mssql_fetch_array($row))
 {
    print_r($list);
    echo "<br>";
?}
?>

2. sqlsrv_ ?? ???? ??

sqlsrv_ ?? ???? ?? php5.3 ??, SQL Server 2005 ???? ?????.

SQL Server? PHP? Microsoft ????(??: https://msdn.microsoft.com/library/dn865013.aspx)? ?????? ???? ???. ???? ? ??? ?? php.ini? ???? ext ????? ?????. ?? ?? php.ini ??? ??

extension=php_pdo_sqlsrv_53_ts.dll
extension=php_sqlsrv_53_ts.dll

apache? ?? ???? phpinfo()? ???? Apache? ?? sqlsrv? ????? ?????. ?? ??? ??

sqlncli.msi? ?????. ? ??? windows ??? sql ??? ??? ?????? ??? ?????? ???? ?? ????

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

??, sqlserver ???? ????? odbc? ??.

php.ini?? php_pdo_odbc.dll ??? ????? ???.

<?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. PDO? ?? sqlserver? ?????.

php.ini?? php_pdo_mssql.dll ??? ??????. phpinfo

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

?? ?? ? ????. 5. COM?? ?????.

??? ?? ?????.

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

? ??? ??? ??? ? ??? ??????? ?????. ? ???? ??? ??? PHP ??? ????? ?? ?? ??? ?????!

?? ??:

PHP? ?? json ??? ?? ??? ??????

PHP? json ??? ?? ???? ??? ??????

? ??? PHP? MSSQL ??? ???? ?? ??? ?? ?????. ??? ??? PHP ??? ????? ?? ?? ??? ?????!