1ã软件é ç½®
Win7 64 +wampserver2.2d-x32+SQL Server 2008 R2æ°æ®åºï¼wamp2.2ä¸çphpçæ¬æ¯5.3.10ã
Phpç¯å¢ä¹å¯ä»¥æ¢æphp+apacheã
2ãæ¯æè¿æ¥MySQL Serveré ç½®
phpçæ¬5.3以åï¼æphp_mssqlåè½ï¼å¯ä»¥ä½¿ç¨ï¼ä½æ¯5.3å以åççæ¬ä¸æ¯æã
2.1ãphpè¿æ¥mssql设置ï¼php5.3以åçæ¬ï¼
ï¼1ï¼ãæå¼php.iniï¼å°
;extension=php_mssql.dllåé¢çåå·ï¼;ï¼å»æï¼ç¶åéå¯ Apacheãå¦æä¸è¡çè¯ï¼è¿è¡ç¬¬2æ¥ã
ï¼2ï¼æ£æ¥ä¸ä¸ä½ çphpå®è£
ç®å½ä¸çextä¸é¢æ没æphp_mssql.dllåå¨ï¼å¦æ没æï¼ä»www.php.netéæ°ä¸è½½ä¸ä¸ªphpå®è£
ï¼è¦ä¸è½½é£ä¸ªå缩å
çææ¯æå®æ´çã
å¦æextç®å½ä¸å·²ç»æäºphp_mssql.dllï¼é£ä¹ä½ éè¦æå¼php.iniï¼æ¾å°
extension_dir = "./ext"
è¿ä¸å¥ï¼æè
类似çï¼ä¸ä¸å®æ¯"./ext"ï¼æ¥æ¾"extension_dir"å³å¯ï¼ï¼ç¶åæ"./ext"ä¿®æ¹ä¸ºä½ çphpå®è£
ç®å½çextç®å½çå®æ´è·¯å¾ï¼æ¯å¦"c:/php/ext"ï¼æè
"c:/program files/php/ext"è¿æ ·ãç¶åå次éå¯ Apacheãå¦æè¿æ¯ä¸è¡çè¯ï¼å¯è½å°±éè¦ç¬¬3æ¥äºã
ï¼3ï¼æ php ç®å½ä¸ç ntwdblib.dll å php_mssql.dll å¤å¶å° system32çç³»ç»ç®å½ä¸å»ï¼ç¶åéèµ·Apacheã
ï¼4ï¼ç¶åå°±å¯ä»¥è¿æ¥MSSQLï¼å¹¶è¿è¡ä¸äºæä½äºãè¿æ¥ä¾åå¦ä¸ï¼
2.2ãphpè¿æ¥sqlsrvï¼php5.3以å以ä¸çæ¬ï¼
ï¼1ï¼ãä¸è½½Microsoft Drivers for PHP for SQL Serverï¼å®æ¹ä¸è½½å°åï¼http://www.microsoft.com/en-us/download/details.aspx?id=20098ï¼æ使ç¨çæ¯SQLSRV2.0ã
ï¼2ï¼ã解åä¸è½½ä¸æ¥çæ件å°php_pdo_sqlsrv_53_ts_vc9.dllæ件åphp_sqlsrv_53_ts_vc9.dllæ件å¤å¶å°phpå®è£ ç®å½ä¸çextæ件夹ä¸ãæ¤å¤æ ¹æ®çæ¬ä¸å使ç¨çæ件ä¸åã
ï¼3ï¼ãå¨php.iniä¸æ·»å
extension=php_sqlsrv_53_ts_vc9.dll
extension=php_pdo_sqlsrv_53_ts_vc9.dll
å°å¾å¤;extension=***.dllè¯å¥åé¢ï¼æ³¨æextension_dir æåçä½ç½®æ¯å¦æ£ç¡®ã
ï¼4ï¼ãéå¯apacheï¼ç¶å访é®http://apache访é®å°å/?Phpinfo=1,åºç°ä¸é¢å¾çä¸çå 容ï¼å代表é ç½®æ£ç¡®ã
ï¼5ï¼ãåæµè¯ä»£ç ï¼æµè¯ä»£ç å¦ä¸ï¼
<?php
header("Content-type: text/html; charset=utf-8");
$serverName = "localhost"; //æ°æ®åºæå¡å¨å°å$uid = "foodcert"; //æ°æ®åºç¨æ·å$pwd = "foodcert"; //æ°æ®åºå¯ç $connectionInfo = array("UID"=>$uid, "PWD"=>$pwd, "Database"=>"FoodCert");
$conn = sqlsrv_connect( $serverName, $connectionInfo);if( $conn == false)
{
echo "è¿æ¥å¤±è´¥ï¼";
die( print_r( sqlsrv_errors(), true));
}else{
echo "è¿æ¥æåï¼";
}
$query = sqlsrv_query($conn, "select * from æ°æ®åºè¡¨");while($row = sqlsrv_fetch_array($query))
{
print_r($row);
}?>
ï¼6ï¼ãä¸é¢å®æä¹åï¼æµè¯ä»£ç çæ¶åä¼åºç°è¿æ¥å¤±è´¥ï¼å 为没æå®è£ sql server nation client ï¼æ¬å°å®¢æ·ç«¯ï¼å»ä¸è½½åéç客æ·ç«¯ï¼æ使ç¨çæ¯Microsoft? SQL Server? 2012 Native Clientï¼ä¸è½½å°åï¼
ï¼7ï¼ãå®è£ å®æä¹åï¼å¨éæ°å¯å¨apache,ç¶å访é®å°±å¯ä»¥è¿æ¥æåäºã
ï¼8ï¼ã注æï¼å¨php.iniæ件æå¨çæ件夹ä¸å¿ é¡»è¦æntwdblib.dllæ件åå¨ã