<?php

echo "<pre>\n";

$conn = OCILogon("scott", "tiger");

$stmt = OCIParse($conn, "select * from emp");

OCIExecute($stmt);

while (OCIFetch($stmt)){

echo "\n";

$ncols = OCINumCols($stmt);

for ($i = 1; $i <= $ncols; $i++){

$column_name = OCIColumnName($stmt, $i);

$column_value = OCIResult($stmt, $i);

echo $column_name . ': ' . $column_value . "\n";

}

echo "\n";

}

OCIFreeStatement($stmt);

OCILogoff($conn);

echo "</pre>";

?>