Open Source RDBMS - Seamless, Scalable, Stable and Free

한국어 | Login |Register

Versions available for this page: CUBRID 8.3.0 |  CUBRID 8.3.1 |  CUBRID 8.4.0 |  CUBRID 8.4.1 | 



cubrid_fetch_lengths

Description

The cubrid_fetch_lengths function returns the length of each field value in the last row fetched in array. If it fails, FALSE is returned.

Syntax

array cubrid_fetch_lengths (resource $result)

  • result : The result handle that is being evaluated. This result comes from a call to cubrid_execute().

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

Return Value
  • Success : Array in which the length of each filed value in the last row fetched is stored.
  • After getting the last row : FALSE
  • Failure : FALSE
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] => 9

)