在插入后获取自动生成的ID [英] Get the auto-generated ID after an insert

问题描述

我有一个Oracle Express 10g数据库。在我的表中，我有一个自动生成的ID，我想知道如何在插入后发现生成的ID是什么。我目前正在使用PHP。

I have an Oracle Express 10g database. In my table I have an auto-generated ID and I would like to know how I can find what the generated ID is after an insert happens. I am currently using PHP.

推荐答案

您可以将返回的id转换为变量。例如，此代码：

You can get the returning id into a variable. For example, this code:

$data = array("larry","bill","steve");
$db = OCILogon("scott","tiger");
$stmt = OCIParse($db,"insert into names values (myid.nextval,:name) returning id into :id");

OCIBindByName($stmt,":ID",$id,32);
OCIBindByName($stmt,":NAME",$name,32);

while (list(,$name) = each($data))
{
     OCIExecute($stmt);
     echo "$name got id:$id\n"; 
}

这样就可以得到 $ name 以变量 $ id 的形式。相应地更改您的SQL。

This gives you the ID got by $name in form of the variable $id. Change your SQL accordingly.

这篇关于在插入后获取自动生成的ID的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！