ora_numcols

Example 894. Display column information

// open a connection
if (!$db = @ora_logon("dev@ORCL","dev")) {
   $error = ora_error();
   printf("There was an error connecting. Error was: %s", $error);
   die();
}

// open a cursor
$curs = ora_open($db);

// check that SQL is OK
if (!@ora_parse($curs,"SELECT * FROM xphone_numbers")) {
   echo "Error in parse. Error was :", ora_error($curs);
} else {
   ora_exec($curs);

  // get the number of columns from the query
   $ncols = ora_numcols($curs);

   echo "<table>\n";
   echo "<tr><th>Name</th><th>Type</th></tr>\n";

   // loop through the returned columns and show column type
   for ( $i = 0; $i < $ncols; $i++ ) {
      print"<tr>";
      printf("<td>%s</td>", ora_columnname($curs,$i));
      printf("<td>%s</td>", ora_columntype($curs,$i));
      print"</tr>";
   }
}

ora_close($curs);
ora_logoff($db);