?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);?
?php / * exemple ociFetchStatement par 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 "Rien n'a été trouvé br \n";} print "$nrows Records Selected br \n"; ociFreeStatement($stmt); ociLogoff($conn);?