(1)修改php.ini加入如下設定,並重新啟動appserv的apache網頁伺服程式。 [PHP_COM_DOTNET] extension=php_com_dotnet.dll (2)程式碼: b1.php <body bgcolor=yellow> <?php $constr="Provider=Microsoft.ACE.OLEDB.12.0;Data Source = d:\selldb.accdb"; $con = new com("ADODB.Connection"); $con->Open($constr); $rs = new com("ADODB.RecordSet"); $rs->Open("select * from goods",$con,1,3); while(!$rs->eof){ echo "gdsno=" . $rs->Fields["gdsno"]->Value . "<br>"; echo "gdsname=" . $rs->Fields["gdsname"]->Value . "<br>"; echo "cost=" . $rs->Fields["cost"]->Value . "<br>"; echo "price=" . $rs->Fields["price"]->Value . "<br>"; echo "stock_qty=" . $rs->Fields["stock_qty"]->Value . "<br>"; echo "unit=" . $rs->Fields["unit"]->Value . "<br>"; echo "fac_no=" . $rs->Fields["fac_no"]->Value . "<br>"; echo "mem=" . $rs->Fields["mem"]->Value . "<br>"; $rs->Movenext(); } $rs->close(); ?> </body> (3)Result(欄位內容為中文資料會出現亂碼) gdsno= g0001 (4)REF2: https://codertw.com/%E7%A8%8B%E5%BC%8F%E8%AA%9E%E8%A8%80/218413/ (5)REF1: https://zhidao.baidu.com/question/418743381.html
|