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 ( mysqli_result result ) Object oriented style (property): class mysqli_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 ExamplesExample 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 example will output:
 add a note
User Contributed Notes
mysqli_num_fields
There are no user contributed notes for this page.
|
|
mysqli_next_result
