php oracle update oci_execute,如何使用ORACLE（OCI）在SQL / PHP中執行更新查詢

I'm new to Oracle and using OCI with PHP. I've been doing ok until I've tried to do an update statement.

我是Oracle的新手,並且使用OCI和PHP。在我嘗試做更新聲明之前,我一直沒事。

include("ORCLconfig.php");

$updateTitleInserted = oci_parse($conn, "UPDATE insured SET INSURED_TITLE=

'$updateTitle' WHERE INSURED_ID='$INSURED_ID'");

oci_execute($updateTitleInserted, OCI_COMMIT_ON_SUCCESS);

oci_free_statement($updateTitleInserted);

oci_close($conn);

All I'm trying to do is and update statement so the user can change the Title of a person. I am using AJAX to do this asynchronously and when the user attempts to change the title to the current value it processes the function fine but if the new value is different it gets stuck at the update statement and no change is made.

我所要做的就是更新語句,以便用戶可以更改一個人的標題。我正在使用AJAX異步執行此操作,當用戶嘗試將標題更改為當前值時,它會正常處理函數,但如果新值不同,則會卡在update語句中並且不會進行任何更改。

1 个解决方案

#1

4

$c = oci_connect($userName, $password, "(DESCRIPTION=(ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST =$serverName)(PORT = 1521)))(CONNECT_DATA=(SID=$databaseName)))");

$strQuery = "UPDATE table SET field = :xx WHERE ID = 123"

$stmt = OCIParse($c, $strQuery);

OCIBindByName($stmt, ':xx', $fieldval);

$ok = OCIExecute($stmt);

try this