MySQL and PHP
Copyright 1997-2021 the PHP Documentation Group.
mysql_fetch_lengths
Get the length of each output in a result
This extension was deprecated in PHP 5.5.0, and it was removed in PHP 7.0.0. Instead, the MySQLi or PDO_MySQL extension should be used. See also MySQL: choosing an API guide and related FAQ for more information. Alternatives to this function include:
mysqli_fetch_lengths
|
PDOStatement::getColumnMeta
|
array|false mysql_fetch_lengths(resource result);Returns an array that corresponds to the lengths of each field in the last row fetched by MySQL.
mysql_fetch_lengths
stores the lengths of each result column in the last row
returned by
mysql_fetch_row,
mysql_fetch_assoc,
mysql_fetch_array,
and
mysql_fetch_object
in an array, starting at offset 0.
result
The result resource that is being
evaluated. This result comes from a call to
mysql_query.
An array of lengths on success or
false on failure.
Example 6.23 A
mysql_fetch_lengths
example
<?php
$result = mysql_query("SELECT id,email FROM people WHERE id = '42'");
if (!$result) {
echo 'Could not run query: ' . mysql_error();
exit;
}
$row = mysql_fetch_assoc($result);
$lengths = mysql_fetch_lengths($result);
print_r($row);
print_r($lengths);
?>
The above example will output something similar to:
Array
(
[id] => 42
[email] => user@example.com
)
Array
(
[0] => 2
[1] => 16
)
mysql_field_len
|
mysql_fetch_row
|
strlen
|