cubrid_fetch_lengths(3) [php man page]

CUBRID_FETCH_LENGTHS(3) 						 1						   CUBRID_FETCH_LENGTHS(3)

cubrid_fetch_lengths - Return an array with the lengths of the values of each field from the current row

SYNOPSIS

       array cubrid_fetch_lengths (resource  $result)

DESCRIPTION

	This  function	returns an numeric array with the lengths of the values of each field from the current row of the result set or it returns
       FALSE on failure.

       Note

	       If field data type is BLOB/CLOB, you should get its length by using cubrid_lob_size(3).

PARAMETERS

	      o $result
		-$result comes from a call to cubrid_execute(3)

RETURN VALUES

	An numeric array, when process is successful.

       FALSE on failure.

EXAMPLES

       Example #1

	      cubrid_fetch_lengths(3) example

	      <?php
	      $conn = cubrid_connect("localhost", 33000, "demodb");
	      $result = cubrid_execute($conn, "SELECT * FROM game WHERE host_year=2004 AND nation_code='AUS' AND medal='G'");

	      $row = cubrid_fetch_row($result);
	      print_r($row);

	      $lens = cubrid_fetch_lengths($result);
	      print_r($lens);

	      cubrid_disconnect($conn);
	      ?>

	      The above example will output:

	      Array
	      (
		  [0] => 2004
		  [1] => 20085
		  [2] => 15118
		  [3] => 30134
		  [4] => AUS
		  [5] => G
		  [6] => 2004-8-20
	      )
	      Array
	      (
		  [0] => 4
		  [1] => 5
		  [2] => 5
		  [3] => 5
		  [4] => 3
		  [5] => 1
		  [6] => 10
	      )

PHP Documentation Group 												   CUBRID_FETCH_LENGTHS(3)

CUBRID_FIELD_NAME(3)							 1						      CUBRID_FIELD_NAME(3)

cubrid_field_name - Return the name of the specified field index

SYNOPSIS

       string cubrid_field_name (resource  $result, int  $field_offset)

DESCRIPTION

	This function returns the name of the specified field index on success or it returns FALSE on failure.

PARAMETERS

	      o $result
		-$result comes from a call to cubrid_execute(3)

	      o $field_offset
		-  The numerical field offset. The $field_offset starts at 0. If $field_offset does not exist, an error of level E_WARNING is also
		issued.

RETURN VALUES

	Name of specified field index, on success.

       FALSE on failure.

EXAMPLES

       Example #1

	      cubrid_field_name(3) example

	      <?php
	      $conn = cubrid_connect("localhost", 33000, "demodb");
	      $result = cubrid_execute($conn, "SELECT * FROM game WHERE host_year=2004 AND nation_code='AUS' AND medal='G'");

	      $col_num = cubrid_num_cols($result);

	      printf("%-30s %s
", "Field Name", "Field Flags");
	      for($i = 0; $i < $col_num; $i++) {
		  printf("%-30s %s
", cubrid_field_name($result, $i), cubrid_field_flags($result, $i));
	      }

	      cubrid_disconnect($conn);
	      ?>

	      The above example will output:

	      Field Name		     Field Flags
	      host_year 		     not_null primary_key unique_key
	      event_code		     not_null primary_key unique_key foreign_key
	      athlete_code		     not_null primary_key unique_key foreign_key
	      stadium_code		     not_null
	      nation_code
	      medal
	      game_date

PHP Documentation Group 												      CUBRID_FIELD_NAME(3)