Você procurou por: ocifetchinto (Italiano - Chinês (simplificado))

ocifetchinto() estrae la prossima tupla (nelle istruzioni select) ponendola nell 'array result.
description

?php / * ocibindbypos example thies@thieso.net (980221) inserisce 3 tuple in emp, e usa rowid per aggiornare le tuple subito dopo l'inserimento. * / $conn = ocilogon("scott" ,"tiger"); $stmt = ociparse($conn ,"insert into emp (empno, ename) ". "values (:empno,:ename)". "returning rowid into :rid"); $data = array(1111 = "larry", 2222 = "bill", 3333 = "jim"); $rowid = ocinewdescriptor($conn,oci_d_rowid); ocibindbyname($stmt ,":empno", $empno,32); ocibindbyname($stmt ,":ename", $ename,32); ocibindbyname($stmt ,":rid", $rowid,-1,oci_b_rowid); $update = ociparse($conn ,"update emp set sal = :sal where rowid = :rid"); ocibindbyname($update ,":rid", $rowid,-1,oci_b_rowid); ocibindbyname($update ,":sal", $sal,32); $sal = 10000; while (list($empno,$ename) = each($data)) {ociexecute($stmt); ociexecute($update);} $rowid - free(); ocifreestatement($update); ocifreestatement($stmt); $stmt = ociparse($conn ,"select * from emp where empno in (1111,2222,3333)"); ociexecute($stmt); while (ocifetchinto($stmt, $arr,oci_assoc)) {var_dump($arr);} ocifreestatement($stmt); / * delete our "junk "from the emp table.... * / $stmt = ociparse($conn ,"delete from emp where empno in (1111,2222,3333)"); ociexecute($stmt); ocifreestatement($stmt); ocilogoff($conn);?
?php /* ocibindbypos example thies@thieso.net (980221) inserts 3 records into emp, and uses the rowid for updating the records just after the insert. */ $conn = ocilogon("scott","tiger"); $stmt = ociparse($conn,"insert into emp (empno, ename) ". "values (:empno,:ename) ". "returning rowid into :rid"); $data = array(1111 = "larry", 2222 = "bill", 3333 = "jim"); $rowid = ocinewdescriptor($conn,oci_d_rowid); ocibindbyname($stmt,":empno", $empno,32); ocibindbyname($stmt,":ename", $ename,32); ocibindbyname($stmt,":rid", $rowid,-1,oci_b_rowid); $update = ociparse($conn,"update emp set sal = :sal where rowid = :rid"); ocibindbyname($update,":rid", $rowid,-1,oci_b_rowid); ocibindbyname($update,":sal", $sal,32); $sal = 10000; while (list($empno,$ename) = each($data)) {ociexecute($stmt); ociexecute($update);} $rowid- free(); ocifreestatement($update); ocifreestatement($stmt); $stmt = ociparse($conn,"select * from emp where empno in (1111,2222,3333)"); ociexecute($stmt); while (ocifetchinto($stmt, $arr,oci_assoc)) {var_dump($arr);} ocifreestatement($stmt); /* delete our "junk" from the emp table.... */ $stmt = ociparse($conn,"delete from emp where empno in (1111,2222,3333)"); ociexecute($stmt); ocifreestatement($stmt); ocilogoff($conn);?