cubrid_num_fields(3) [php man page]

CUBRID_NUM_FIELDS(3)							 1						      CUBRID_NUM_FIELDS(3)

cubrid_num_fields - Return the number of columns in the result set

SYNOPSIS

       int cubrid_num_fields (resource	$result)

DESCRIPTION

	This function returns the number of columns in the result set, on success, or it returns FALSE on failure.

PARAMETERS

	      o $result
		-$result comes from a call to cubrid_execute(3), cubrid_query(3) and cubrid_prepare(3)

RETURN VALUES

	Number of columns, on success.

	-1 if SQL sentence is not SELECT.

       FALSE when process is unsuccessful.

EXAMPLES

       Example #1

	      cubrid_num_fields(3) example

	      <?php
	      $conn = cubrid_connect("localhost", 33000, "demodb");

	      $req = cubrid_execute($conn, "SELECT * FROM code");

	      $row_num = cubrid_num_rows($req);
	      $col_num = cubrid_num_fields($req);

	      printf("Row Num: %d
Column Num: %d
", $row_num, $col_num);

	      cubrid_disconnect($conn);
	      ?>

	      The above example will output:

	      Row Num: 6
	      Column Num: 2

PHP Documentation Group 												      CUBRID_NUM_FIELDS(3)

CUBRID_RESULT(3)							 1							  CUBRID_RESULT(3)

cubrid_result - Return the value of a specific field in a specific row

SYNOPSIS

       string cubrid_result (resource  $result, int  $row, [mixed  $field])

DESCRIPTION

	This function returns the value of a specific field in a specific row from a result set.

PARAMETERS

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

	      o $row
		-The row number from the result that is being retrieved. Row numbers start at 0.

	      o $field
		- The name or offset of the $field being retrieved. It can be the field's offset, the field's name, or the field's table dot field
		name (tablename.fieldname). If the column name has been aliased ('select foo as bar from...'), use the alias instead of the column
		name. If undefined, the first field is retrieved.

RETURN VALUES

	Value of a specific field, on success (NULL if value if null).

       FALSE on failure.

EXAMPLES

       Example #1

	      cubrid_result(3) example

	      <?php
	      $conn = cubrid_connect("localhost", 33000, "demodb");

	      $req = cubrid_execute($conn, "SELECT * FROM code");

	      $result = cubrid_result($req, 0);
	      var_dump($result);

	      $result = cubrid_result($req, 0, 1);
	      var_dump($result);

	      $result = cubrid_result($req, 5, "f_name");
	      var_dump($result);

	      cubrid_close_request($req);
	      cubrid_disconnect($conn);
	      ?>

	      The above example will output:

	      string(1) "X"
	      string(5) "Mixed"
	      string(4) "Gold"

PHP Documentation Group 													  CUBRID_RESULT(3)