当前位置: 首页 > 网络学院 > 服务端脚本教程 > PHP > mysql_fetch_lengths() 函数
The mysql_fetch_lengths() function returns the length of the contents of each field in a row.
mysql_fetch_lengths()函数的作用是:返回结果集中每个字段内容的长度。
The row is retrieved by mysql_fetch_array(), mysql_fetch_assoc(), mysql_fetch_object(), or mysql_fetch_row().
这个结果集可以通过mysql_fetch_array(), mysql_fetch_assoc(), mysql_fetch_object(), 或mysql_fetch_row()获得。
This function returns a numeric array on success, or FALSE on failure or when there are no more rows.
如果函数成功执行,将返回一个数值型数组;如果执行失败或没有任何结果返回将返回False。
mysql_fetch_lengths(data) |
Parameter 参数 | Description 描述 |
---|---|
data | Required. Specifies which data pointer to use. The data pointer is the result from the mysql_query() function 必要参数。指定需要使用的数据指针[data pointer]。该数据指针是通过请求mysql_query()函数返回的。 |
<?php $con = mysql_connect("localhost", "peter", "abc123"); if (!$con) { die('Could not connect: ' . mysql_error()); } $db_selected = mysql_select_db("test_db",$con); $sql = "SELECT * from Person WHERE Lastname='Refsnes'"; $result = mysql_query($sql,$con); print_r(mysql_fetch_row($result)); print_r(mysql_fetch_lengths($result)); mysql_close($con); ?> |
The output of the code above could be:
上述代码将返回下面的结果:
Array ( [0] => Refsnes [1] => Kai Jim [2] => Taugata 2 [3] => 22 ) Array ( [0] => 7 [1] => 7 [2] => 9 [3] => 2 ) |