使用codeigniter，需要使用oci8获取下一个查询的最后一个自动递增id的id

2 回答

• 0

  看这里：

  Get the auto-generated ID after an insert

  $data = array("value1","value2","value3");
  $db = OCILogon("user","password");
  $stmt = OCIParse($db,"insert into mytable values (myid.nextval,:myfield) returning id into :id");
  
  OCIBindByName($stmt,":ID",$id,32);
  OCIBindByName($stmt,":MYFIELD",$myfield,32);
  
  while (list(,$myfield) = each($data)) {
  OCIExecute($stmt);
   echo "$myfieldgot id:$id\n";
  }
  

  您还可以查看使用类似PDO的数据库接口层

  回复于 2024-05-04T10:48:14+08:00
• 0

  获取下一个序列号怎么样？

  选择'|| cTableName ||来自双重的_seq.currval

  ？

  回复于 2024-05-04T10:48:14+08:00