$update = OCIParse($conn, "update emp set sal = :sal where ROWID = :rid");
OCIBindByName($update, ":rid", &$rowid, -1, OCI_B_ROWID);
OCIBindByName($update, ":sal", &$sal, 32);
$sal = 10000;
while (list($empno, $ename) = each($data)) {
OCIExecute($stmt);
OCIExecute($update);
}
这种例子,我弄不成功,update fh set t='$t' where id=5,$t为大数据内容,就以此写语句
OCIBindByName($update, ":rid", &$rowid, -1, OCI_B_ROWID);
OCIBindByName($update, ":sal", &$sal, 32);
$sal = 10000;
while (list($empno, $ename) = each($data)) {
OCIExecute($stmt);
OCIExecute($update);
}
这种例子,我弄不成功,update fh set t='$t' where id=5,$t为大数据内容,就以此写语句
用于现在的在线编辑器,保存html代码用
$stmt = @OCIparse($conn,"UPDATE $table SET content_preview=EMPTY_CLOB() WHERE id='$id' RETURNING content_preview INTO:content_preview");
$clob = @OCINewDescriptor($conn,OCI_D_LOB);
OCIBindByName($stmt,':content_preview',&$clob,"",OCI_B_CLOB);
OCIExecute($stmt,OCI_DEFAULT);
if ($clob->save($content)){
OCICommit($conn);
}else{
echo "UPDATE default!";
}
OCIFreeDesc($clob);
OCIFreeStatement($stmt);