æ°æ®åºæ¥è¯¢ä¸å¤ä¹4个æ¥éª¤ï¼1ã建ç«è¿æ¥ã2ãè¾å
¥æ¥è¯¢ä»£ç ã3ã建ç«æ¥è¯¢å¹¶ååºæ°æ®ã4ãå
³éè¿æ¥ã phpè¿æ¥mssqlæ°æ®åºæå 个注æäºé¡¹ï¼å°¤å
¶mssqlçå¤ä¸ªçæ¬ã32ä½ã64ä½é½æåºå«ã
é¦å
ï¼php.iniæ件ä¸;extension=php_pdo_mssql.dll ;extension=php_pdo_odbc.dll åé¢çåå·å»æï¼å¯¹åºç使åªç§æ¹å¼è¿æ¥mssqlã注æè¦éå¯æå¡ä½¿å
¶çæã
ä¸ã建ç«è¿æ¥
1ãodbc
é¦å
ï¼å¨phpç¨åºæå¨çæå¡å¨è®¾ç½®odbcãè¿é32ä½å64ä½æä½ç³»ç»æåºå«ã32ä½çä»æ§å¶é¢æ¿ä¸ç®¡çå·¥å
·ä¸çæ°æ®æºï¼odbcï¼ç´æ¥å»ºç«å°±å¯ä»¥äºï¼64ä½çè¦è¿è¡C:\Windows\SysWOW64\odbcad32.exe
ä»è¿éé¢è®¾ç½®ã注æï¼ä¸é¢åªçæ¯æ°æ®åºæå¡å¨ä¸º32为çï¼æ°æ®æºè®¾ç½®æå¡å¨ä¸º32ä½å64ä½ä¸¤ç§çæ
åµãåªè¦ä¸¤ä¸ªæå¡å¨å»ºç«çæ°æ®æºä½æ°ä¸è´å°±å¥½ã
ä¸é¢æ¯odbc建ç«è¿æ¥ä»£ç ã
å¤å¶ä»£ç 代ç å¦ä¸:
$con = odbc_connect('odbcå称','ç¨æ·å','å¯ç ');
2ãè¿æ¥mssql2000
å¤å¶ä»£ç 代ç å¦ä¸:
$con = mssql_connect('æ°æ®åºå°å','ç¨æ·å','å¯ç ');
3ãè¿æ¥mssql2008
å¤å¶ä»£ç 代ç å¦ä¸:
$connectionInfo = array("UID"=>ç¨æ·å,"PWD"=>å¯ç ,"Database"=>"æ°æ®åºå称");
$con = sqlsrv_connect( æ°æ®åºå°å,$connectionInfo);
äºãè¾å
¥æ¥è¯¢ä»£ç
è¿ä¸ªé½ä¸æ ·ï¼å¯ä»¥ç´æ¥åå
¥ï¼ä¹å¯ä»¥ä»mssqlä¸éªè¯å¥½åå¤å¶è¿æ¥ãç®åç¹è¯´å°±æ¯æä¸ä¸ªsqlè¯å¥èµå¼ç»ä¸ä¸ªåéã
类似ä¸é¢ä»£ç
å¤å¶ä»£ç 代ç å¦ä¸:
$query = "SELECT top 12 * æ°æ®åºå称 order by id desc";
ä¸ã建ç«æ¥è¯¢å¹¶ååºæ°æ®
1ãodbc
å¤å¶ä»£ç 代ç å¦ä¸:
$result = odbc_do($con,$query);
while(odbc_fetch_row($result))
{
$åéå称 = odbc_result($result, "å段å称");
}
2ãè¿æ¥mssql2000
å¤å¶ä»£ç 代ç å¦ä¸:
$result = mssql_query($con, $query);
while($row =mssql_fetch_array($result))
{
$åéå称 = $row["å段å称"];
}
3ãè¿æ¥mssql2008
å¤å¶ä»£ç 代ç å¦ä¸:
$result = sqlsrv_query($con, $query);
while($row = sqlsrv_fetch_array($result))
{
$åéå称 = $row["å段å称"];
}
å¨php5.3å以åççæ¬ä¸ä¸é带sqlsrvåºäºãæ以è¦ä»å¾®è½¯è¿éä¸è½½ã
åãå
³éè¿æ¥
è¿ä¸ªæ²¡æä»ä¹åºå«ï¼åå«æ¯odbc_close();åmssql_close()åsqlsrv_close();
æåä½ä¼ï¼phpè¿æ¥mssqlæ¯è¿æ¥mssqlçå½æ°å°äºä¸äºï¼ä½æ¯ä¹å¤ç¨äºãå
·ä½å½æ°å¯ä»¥åèphpå®æ¹æå
温馨提示:答案为网友推荐,仅供参考