湖濱散記部落格的樹心幽徑[login][主頁]
489:20190314用php程式加入一筆資料到ms-access2000資料庫檔(selldb.accdb)的goods資料表中 (b2.php)

<body bgcolor=pink>

<?php

$constr="Provider=Microsoft.ACE.OLEDB.12.0;Data Source = d:\selldb.accdb";

$con = new com("ADODB.Connection");

$con->Open($constr);

$sql="insert into goods (gdsno,gdsname,cost,price,stock_qty,unit,fac_no,mem) values ('101','plum' ,30,40,2000,'li','f01','goodlone')";

$con->execute($sql);

?>

</body>


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