php man page for mysql_fetch_lengths

Query: mysql_fetch_lengths

OS: php

Section: 3

Format: Original Unix Latex Style Formatted with HTML and a Horizontal Scroll Bar

MYSQL_FETCH_LENGTHS(3)							 1						    MYSQL_FETCH_LENGTHS(3)

mysql_fetch_lengths - Get the length of each output in a result

SYNOPSIS
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 also MySQL: choosing an API guide and related FAQ for more information. Alternatives to this function include: omysqli_fetch_lengths(3) o PDOStatement::getColumnMeta array mysql_fetch_lengths (resource $result)
DESCRIPTION
Returns an array that corresponds to the lengths of each field in the last row fetched by MySQL. mysql_fetch_lengths(3) stores the lengths of each result column in the last row returned by mysql_fetch_row(3), mysql_fetch_assoc(3), mysql_fetch_array(3), and mysql_fetch_object(3) in an array, starting at offset 0. o $ result -The result resource that is being evaluated. This result comes from a call to mysql_query(3). An array of lengths on success or FALSE on failure. Example #1 A mysql_fetch_lengths(3) 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(3), mysql_fetch_row(3), strlen(3). PHP Documentation Group MYSQL_FETCH_LENGTHS(3)
Related Man Pages
mysql_list_tables(3) - php
mysql_data_seek(3) - php
mysql_fetch_object(3) - php
mysql_field_flags(3) - php
mysql_list_dbs(3) - php
Similar Topics in the Unix Linux Community
Array and Selection
Send email for each row in a result set
PHP quote question
Parsing delimited file
awk to sum column field from duplicate row/lines