PHP-ORACLE: take the autogenerated ID after an insert

Question

i have a Oracle Express 10g database, i have a table with an autogenerated id, i whold like to know how can i know it in php after an insert.

Answer 1

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"; 
}

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