湖濱散記部落格的樹心幽徑[login][主頁]
486:20190307用php設計b1.php來連線ms-access 2000資料庫檔(selldb.accdb)並讀出貨品資料表(goods)中的所有資料錄。

(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
gdsname=���B
cost=5
price=8
stock_qty=2000
unit=��
fac_no=f0008
mem=�N�B�A��
gdsno=g0002
gdsname=oarnge
cost=6
price=9
stock_qty=3000
unit=kg
fac_no=f0009
mem=kfarm

(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

 

 


select id,article_id,topic,text from lt_articles_text where article_id =486; ok. update lt_articles set num_reads=num_reads +1 where id=486; ok.