源代码如下: $conn = new com("ADODB.Connection"); $connstr = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=d:\php_web\xxgc\db\ftpdb01.mdb"; $conn->Open($connstr); $rs = new com("ADODB.Connection"); $datetime=date("Y-m-d",$day); $rs->Open("insert into news01(fl,zt,nr,time,day,bm,cs) values($xwfl,'$xwbt','$xwnr','$datetime',0,$fwbm,0)",$conn,1,1);请给看看有什么错么?
源代码: $conn = new com("ADODB.Connection"); $connstr = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=d:\php_web\xxgc\db\ftpdb01.mdb"; $conn->Open($connstr); $rs = new com("ADODB.RecordSet"); $datetime=date("Y-m-d",$day); $rs->Open("insert into news01(fl,zt,nr,time,day,bm,cs) values($xwfl,'$xwbt','$xwnr','$datetime',0,$fwbm,0)",$conn,1,1);请给看看有什么错?
$rs->Open("insert into news01(fl,zt,nr,time,day,bm,cs) values($xwfl,'$xwbt','$xwnr','$datetime',0,$fwbm,0)",$conn,1,1); ==> $rs->Open(...,$conn,1,3); // 1,1 是只读的或 $conn->Execute("insert into news01(fl,zt,nr,time,day,bm,cs) values($xwfl,'$xwbt','$xwnr','$datetime',0,$fwbm,0)");请自行保证类型和数据的有效性
用 $conn->Execute("insert into news01(fl,zt,nr,time,day,bm,cs) values($xwfl,'$xwbt','$xwnr','$datetime',0,$fwbm,0)");//第30行。 后提示: Warning: (null)(): Invoke() failed: 未知名称。 Source: Microsoft OLE DB Provider for ODBC Drivers Description: [Microsoft][ODBC Microsoft Access Driver] INSERT INTO 语句的语法错误。 in D:\php_web\xxgc\addnews.php on line 30
$conn = new com("ADODB.Connection");
$connstr = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=d:\php_web\xxgc\db\ftpdb01.mdb";
$conn->Open($connstr);
$rs = new com("ADODB.Connection");
$datetime=date("Y-m-d",$day);
$rs->Open("insert into news01(fl,zt,nr,time,day,bm,cs) values($xwfl,'$xwbt','$xwnr','$datetime',0,$fwbm,0)",$conn,1,1);请给看看有什么错么?
$conn = new com("ADODB.Connection");
$connstr = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=d:\php_web\xxgc\db\ftpdb01.mdb";
$conn->Open($connstr);
$rs = new com("ADODB.RecordSet");
$datetime=date("Y-m-d",$day);
$rs->Open("insert into news01(fl,zt,nr,time,day,bm,cs) values($xwfl,'$xwbt','$xwnr','$datetime',0,$fwbm,0)",$conn,1,1);请给看看有什么错?
==>
$rs->Open(...,$conn,1,3); // 1,1 是只读的或
$conn->Execute("insert into news01(fl,zt,nr,time,day,bm,cs) values($xwfl,'$xwbt','$xwnr','$datetime',0,$fwbm,0)");请自行保证类型和数据的有效性
$conn->Execute("insert into news01(fl,zt,nr,time,day,bm,cs) values($xwfl,'$xwbt','$xwnr','$datetime',0,$fwbm,0)");//第30行。
后提示:
Warning: (null)(): Invoke() failed: 未知名称。 Source: Microsoft OLE DB Provider for ODBC Drivers Description: [Microsoft][ODBC Microsoft Access Driver] INSERT INTO 语句的语法错误。 in D:\php_web\xxgc\addnews.php on line 30