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_COLUMN_TYPES(3)							 1						    CUBRID_COLUMN_TYPES(3)

cubrid_column_types - Get column types in result

SYNOPSIS

       array cubrid_column_types (resource  $req_identifier)

DESCRIPTION

	The cubrid_column_types(3) function gets column types of query results by using $req_identifier.

PARAMETERS

	      o $req_identifier
		-Request identifier.

RETURN VALUES

	Array of string values containing the column names, when process is successful.

       FALSE, when process is unsuccessful.

EXAMPLES

       Example #1

	      cubrid_column_types(3) example

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

	      $column_names = cubrid_column_names($result);
	      $column_types = cubrid_column_types($result);

	      printf("%-30s %-30s %-15s
", "Column Names", "Column Types", "Column Maxlen");
	      for($i = 0, $size = count($column_names); $i < $size; $i++) {
		  $column_len = cubrid_field_len($result, $i);
		  printf("%-30s %-30s %-15s
", $column_names[$i], $column_types[$i], $column_len);
	      }

	      cubrid_disconnect($conn);
	      ?>

	      The above example will output:

	      Column Names		     Column Types		    Column Maxlen
	      host_year 		     integer			    11
	      event_code		     integer			    11
	      athlete_code		     integer			    11
	      stadium_code		     integer			    11
	      nation_code		     char			    3
	      medal			     char			    1
	      game_date 		     date			    10

SEE ALSO

       cubrid_column_names(3), cubrid_prepare(3), cubrid_execute(3).

PHP Documentation Group 												    CUBRID_COLUMN_TYPES(3)