嗨,我是Oracle的新手。
我试图在PHP中使用oracle将记录插入表中。 但它不起作用,也没有抛出任何错误。
以下是我的代码。 请告诉我我做错了什么。
$insertSQL= "INSERT INTO GL_USR_MAIL_FOLDER(FK_GLUSR_USR_ID, GL_USR_MAIL_FOLDER_NAME) VALUES (:USERDET,:FOLDERNAME) RETURNING GL_USR_MAIL_FOLDER_ID INTO :FOLDER_ID";
try{
// echo "try 111LL:L";
$stid = oci_parse($dbh, $insertSQL);
$e = oci_error($stid); // For oci_execute errors pass the statement handle
print htmlentities($e['message']);
}catch (Exception $ex) {
GlobalFunc::print_oracle_error(__CLASS__, __FILE__, __LINE__, "Parsing of Query couldn't take place ","Parsing of Query couldn't take place for Query : \n $sql", $ex,0);
}
try{
//echo "try bindd";
oci_bind_by_name($stid, ":USERDET", $postData['glusrid']);
oci_bind_by_name($stid, ":FOLDERNAME", $postData['foldername']);
oci_bind_by_name($stid, ":FOLDER_ID", $folderid, 8, OCI_B_INT);
$e = oci_error($stid); // For oci_execute errors pass the statement handle
print htmlentities($e['message']);
} catch (Exception $ex) {
GlobalFunc::print_oracle_error(__CLASS__, __FILE__, __LINE__, "Binding of Query couldn't take place ","Binding of Query couldn't take place for Query : \n $sql", $ex,0);
}
try{
$s = oci_execute($stid);
if(!$s){
$e = oci_error($stid);
print htmlentities($e['message']);
}
print_r($s);echo "after execute";
oci_commit($dbh);
}catch(Exception $ex){
GlobalFunc::print_oracle_error(__CLASS__, __FILE__, __LINE__, "Execution of Query couldn't take place ","Execution of Query couldn't take place for Query : \n $sql", $ex,0);
}
如果觉得《php oracle 无查询结果 php - Oracle Insert查询不起作用 也不会抛出任何错误 - 堆栈内存溢出...》对你有帮助,请点赞、收藏,并留下你的观点哦!