pg_field_name(3) [php man page]

PG_FIELD_NAME(3)														  PG_FIELD_NAME(3)

pg_field_name - Returns the name of a field

SYNOPSIS

       string pg_field_name (resource  $result, int  $field_number)

DESCRIPTION

       pg_field_name(3)  returns the name of the field occupying the given $field_number in the given PostgreSQL $result resource. Field numbering
       starts from 0.

       Note

	       This function used to be called pg_fieldname(3).

PARAMETERS

	      o $result
		- PostgreSQL query result resource, returned by pg_query(3), pg_query_params(3) or pg_execute(3) (among others).

	      o $field_number
		- Field number, starting from 0.

RETURN VALUES

	The field name, or FALSE on error.

EXAMPLES

       Example #1

	      Getting information about fields

	      <?php
		$dbconn = pg_connect("dbname=publisher") or die("Could not connect");

		$res = pg_query($dbconn, "select * from authors where author = 'Orwell'");
		$i = pg_num_fields($res);
		for ($j = 0; $j < $i; $j++) {
		    echo "column $j
";
		    $fieldname = pg_field_name($res, $j);
		    echo "fieldname: $fieldname
";
		    echo "printed length: " . pg_field_prtlen($res, $fieldname) . " characters
";
		    echo "storage length: " . pg_field_size($res, $j) . " bytes
";
		    echo "field type: " . pg_field_type($res, $j) . " 

";
		}
	      ?>

	      The above example will output:

	      column 0
	      fieldname: author
	      printed length: 6 characters
	      storage length: -1 bytes
	      field type: varchar

	      column 1
	      fieldname: year
	      printed length: 4 characters
	      storage length: 2 bytes
	      field type: int2

	      column 2
	      fieldname: title
	      printed length: 24 characters
	      storage length: -1 bytes
	      field type: varchar

SEE ALSO

       pg_field_num(3).

PHP Documentation Group 													  PG_FIELD_NAME(3)

MSSQL_FETCH_FIELD(3)													      MSSQL_FETCH_FIELD(3)

mssql_fetch_field - Get field information

SYNOPSIS

       object mssql_fetch_field (resource  $result, [int  $field_offset = -1])

DESCRIPTION

       mssql_fetch_field(3) can be used in order to obtain information about fields in a certain query result.

PARAMETERS

	      o $result
		- The result resource that is being evaluated. This result comes from a call to mssql_query(3).

	      o $field_offset
		-  The numerical field offset. If the field offset is not specified, the next field that was not yet retrieved by this function is
		retrieved. The $field_offset starts at 0.

RETURN VALUES

	Returns an object containing field information.

	The properties of the object are:

	      o name - column name. if the column is a result of a function, this property is set to computed#N, where #N is a serial number.

	      o column_source - the table from which the column was taken

	      o max_length - maximum length of the column

	      o numeric - 1 if the column is numeric

	      o type - the column type.

EXAMPLES

       Example #1

	      mssql_fetch_field(3) example

	      <?php
	      // Connect to MSSQL and select the database
	      mssql_connect('MANGOSQLEXPRESS', 'sa', 'phpfi');
	      mssql_select_db('php');

	      // Send a select query to MSSQL
	      $query = mssql_query('SELECT * FROM [php].[dbo].[persons]');

	      // Construct table
	      echo '<h3>Table structure for 'persons'</h3>';
	      echo '<table border="1">';

	      // Table header
	      echo '<thead>';
	      echo '<tr>';
	      echo '<td>Field name</td>';
	      echo '<td>Data type</td>';
	      echo '<td>Max length</td>';
	      echo '</tr>';
	      echo '</thead>';

	      // Dump all fields
	      echo '<tbody>';

	      for ($i = 0; $i < mssql_num_fields($query); ++$i) {
		  // Fetch the field information
		  $field = mssql_fetch_field($query, $i);

		  // Print the row
		  echo '<tr>';
		  echo '<td>' . $field->name . '</td>';
		  echo '<td>' . strtoupper($field->type) . '</td>';
		  echo '<td>' . $field->max_length . '</td>';
		  echo '</tr>';
	      }

	      echo '</tbody>';
	      echo '</table>';

	      // Free the query result
	      mssql_free_result($query);
	      ?>

SEE ALSO

       mssql_field_seek(3).

PHP Documentation Group 												      MSSQL_FETCH_FIELD(3)