php8.5
Home/ Manual/ cubrid / cubridmysql/ cubrid_fetch_lengths

cubrid_fetch_lengths

PHP function Edit on GitHub ✎

(PECL CUBRID >= 8.3.0)

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

Description

cubrid_fetch_lengths(resource $result): array

This function returns a 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().

Parameters

result

result comes from a call to cubrid_execute()

Return Values

A numeric array, when process is successful.

false on failure.

Examples

cubrid_fetch_lengths() example

php
<?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:

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
)

Source: reference/cubrid/cubridmysql/cubrid-fetch-lengths.xml · from the official PHP manual (php/doc-en)