(PHP 4, PHP 5)
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, theMySQLi orPDO_MySQL extension should be used.See alsoMySQL: choosing an API guide.Alternatives to this function include:
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 bymysql_fetch_row(),mysql_fetch_assoc(),mysql_fetch_array(), andmysql_fetch_object() in an array, starting at offset 0.
resultThe resultresource thatis being evaluated. This result comes from a call tomysql_query().
Example #1 Amysql_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 outputsomething similar to:
Array( [id] => 42 [email] => user@example.com)Array( [0] => 2 [1] => 16)