PHP mysqli_fetch_lengths() Function

Object oriented style

array $mysqli_result->lengths;

Procedural style

array mysqli_fetch_lengths ( mysqli_result $result )

The mysqli_fetch_lengths() function returns an array containing the lengths of every column of the current row within the result set.The mysqli_fetch_lengths() function returns the length of the fields in the result set.

Examples -

Object oriented style

Procedural style

The above examples will output:

Field 1 has Length 3, Field 2 has Length 5, Field 3 has Length 13, Field 4 has Length 9, Field 5 has Length 6, Field 6 has Length 1, Field 7 has Length 6, Field 8 has Length 4, Field 9 has Length 6, Field 10 has Length 6, Field 11 has Length 5, Field 12 has Length 44, Field 13 has Length 7, Field 14 has Length 3, Field 15 has Length 2

ParameterDescription
resultProcedural style only: A result set identifier returned by mysqli_query(), mysqli_store_result() or mysqli_use_result().

Return Values

An array of integers representing the size of each column (not including any terminating null characters). FALSE if an error occurred.

mysqli_fetch_lengths() is valid only for the current row of the result set. It returns FALSE if you call it before calling mysqli_fetch_row/array/object or after retrieving all rows in the result.