Oracle 5.0, Reference Manual

Page: 2286 / 3232

Original MySQL API (
Mysql
)
2266
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.
Parameters
result
The result resource that is being evaluated. This result comes from
a call to
mysql_query
.
Return Values
An array of lengths on success or
FALSE
on failure.
Examples
Example 20.44. 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
)
See Also
mysql_field_len
mysql_fetch_row
strlen
20.7.2.5.17.
mysql_fetch_object
Copyright 1997-2012 the PHP Documentation Group. [2230]
•
mysql_fetch_object
Fetch a result row as an object
Warning
This extension is deprecated as of PHP 5.5.0, and will be removed in the
future. Instead, the
MySQLi or PDO_MySQL extension should be used. See