我想想数据库中插入一条数据 该怎么写? //创建ADO连接
$conn = @new COM("ADODB.Connection") or die ("ADO连接失败!");
$connstr = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" .realpath("database/IAtest.mdb");
$conn->Open($connstr);//创建记录集查询
$rs = @new COM("ADODB.RecordSet");
$rs->Open("select * from request where Server_IAGUID = '$IA300IAID'",$conn,1,3);
查的话我会 但是用ADODB插入数据我就不会了...
$conn = @new COM("ADODB.Connection") or die ("ADO连接失败!");
$connstr = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" .realpath("database/IAtest.mdb");
$conn->Open($connstr);//创建记录集查询
$rs = @new COM("ADODB.RecordSet");
$rs->Open("select * from request where Server_IAGUID = '$IA300IAID'",$conn,1,3);
查的话我会 但是用ADODB插入数据我就不会了...
$connstr="DRIVER=Microsoft Access Driver (*.mdb);DBQ=".realpath("data/att2000.mdb") or die("fail");
$connid=odbc_connect($connstr,"","",SQL_CUR_USE_ODBC );
$queryAdd=odbc_do($connid,"insert into php_admin (szd_user,szd_password) values ('allen','".sha1($pass)."')");//插入
$queryupdate=odbc_do($connid,"update php_admin set szd_user='shiwo' where id=3");//更新
$querydelete=odbc_do($connid,"delete from php_admin where id=3");//删除
建议打开 magic_quotes_sybase 开关