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