PHP 忒聊
綴豖
ヶ輛
OCIFetchStatement
(PHP 3 = 3.0.8, PHP 4)
Description
OCIFetchStatement() fetches all the rows from a result into a user-defined array. OCIFetchStatement() returns the number of rows fetched.
瞰赽 1. OCIFetchStatement
?php /* OCIFetchStatement example mbritton@verinet.com (990624) */ $conn = OCILogon("scott","tiger"); $stmt = OCIParse($conn,"select * from emp"); OCIExecute($stmt); $nrows = OCIFetchStatement($stmt,$results); if ($nrows 0) {print "TABLE BORDER=\"1\" \n"; print" TR \n"; while (list( $key, $val) = each( $results)) {print "TH $key /TH \n";} print" /TR \n"; for ($i = 0; $i $nrows; $i++) {reset($results); print "TR \n"; while ($column = each($results)) {$data = $column['value']; print" TD $data[$i] /TD \n";} print "/TR \n";} print" /TABLE \n";} else {echo "No data found BR \n";} print "$nrows Records Selected BR \n"; OCIFreeStatement($stmt); OCILogoff($conn);?
綴豖
れ萸
ヶ輛
OCIFetchInto
奻珨撰
OCIFreeCollection