|
|
mysqli_num_fields (PHP 5) mysqli_num_fields (no version information, might be only in CVS) result->field_count --
Get the number of fields in a result
DescriptionProcedural style: int mysqli_num_fields ( object result) Object oriented style (property): class result { int field_count }
mysqli_num_fields() returns the number of fields from specified result set.
Return valuesThe number of fields from a result set ExampleExample 1. Object oriented style |
<?php
$mysqli = new mysqli("localhost", "my_user", "my_password", "world");
if (mysqli_connect_errno()) {
printf("Connect failed: %s\n", mysqli_connect_error());
exit();
}
if ($result = $mysqli->query("SELECT * FROM City ORDER BY ID LIMIT 1")) {
$field_cnt = $result->field_count;
printf("Result set has %d fields.\n", $field_cnt);
$result->close();
}
$mysqli->close();
?>
|
|
Example 2. Procedural style |
<?php
$link = mysqli_connect("localhost", "my_user", "my_password", "world");
if (mysqli_connect_errno()) {
printf("Connect failed: %s\n", mysqli_connect_error());
exit();
}
if ($result = mysqli_query($link, "SELECT * FROM City ORDER BY ID LIMIT 1")) {
$field_cnt = mysqli_num_fields($result);
printf("Result set has %d fields.\n", $field_cnt);
mysqli_free_result($result);
}
mysqli_close($link);
?>
|
|
The above examples would produce the following output:
Copyright © 2001-2004 The PHP Group
All rights reserved.
|
|
|
