PHP.nl

mysql_fetch_lengths

mysql_fetch_lengths

Get the length of each output in a result

Waarschuwing: > mysqli_fetch_lengths``PDOStatement::getColumnMeta

 **mysql_fetch_lengths** resource $result

Returns an array that corresponds to the lengths of each field in the last row fetched by MySQL.

stores the lengths of

each result column in the last row returned by , , , and in an array, starting at offset 0. mysql_fetch_lengths``mysql_fetch_row``mysql_fetch_assoc``mysql_fetch_array``mysql_fetch_object

An of lengths on successreturn.falseforfailure. array

Voorbeeld: A 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);
?>
Array
(
    [id] => 42
    [email] => user@example.com
)
Array
(
    [0] => 2
    [1] => 16
)

mysql_field_len``mysql_fetch_row``strlen