PHP 手冊
前一頁 |  | 下一頁

# mysql_fetch_lengths

(PHP 3, PHP 4 , PHP 5)

mysql_fetch_lengths -- Get the length of each output in a result

## Description

array mysql_fetch_lengths ( resource result )

Returns an array that corresponds to the lengths of each field in the last row fetched by mysql_fetch_row(), or `FALSE` on error.

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.

範例 1. 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(), and strlen().

前一頁 | 內容 | 下一頁
mysql_fetch_field | 上一層 | mysql_fetch_object