樹心幽徑

« 20190311在windows裝qemu | Main | 20190318在linux LVM建立多個lv邏輯分割區 »

20190314用php程式加入一筆資料到ms-access2000資料庫檔(selldb.accdb)的goods資料表中 (b2.php)
2019/03/14,15:58

<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>

迴響

 
Accessible and Valid XHTML 1.0 Strict and CSS Powered by LifeType