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_data_seek(3) - php
mysql_fetch_object(3) - php
mysql_field_type(3) - php
mysql_free_result(3) - php
mysql_list_dbs(3) - php
Similar Topics in the Unix Linux Community
UNIX for Dummyes
PHP quote question
Parsing delimited file
Extract length wise sequences from fastq file
awk to sum column field from duplicate row/lines