Get the number of fields in a result (original) (raw)

mysqli_result::$field_count

mysqli_num_fields

(PHP 5, PHP 7)

mysqli_result::$field_count -- mysqli_num_fields — Get the number of fields in a result

Description

Object oriented style

intmysqli_result->field_count;

Procedural style

Return Values

The number of fields from a result set.

Examples

Example #1 Object oriented style

`<?php
$mysqli = new mysqli("localhost", "my_user", "my_password", "world");/* check connection */
if (mysqli_connect_errno()) {
printf("Connect failed: %s\n", mysqli_connect_error());
exit();
}

if ( result=result = result=mysqli->query("SELECT * FROM City ORDER BY ID LIMIT 1")) {/* determine number of fields in result set / fieldcnt=field_cnt = fieldc​nt=result->field_count;printf("Result set has %d fields.\n", $field_cnt);/ close result set /
$result->close();
}/ close connection */
$mysqli->close();
?> `

Example #2 Procedural style

`<?php
$link = mysqli_connect("localhost", "my_user", "my_password", "world");/* check connection */
if (mysqli_connect_errno()) {
printf("Connect failed: %s\n", mysqli_connect_error());
exit();
}

if ( result=mysqliquery(result = mysqli_query(result=mysqliq​uery(link, "SELECT * FROM City ORDER BY ID LIMIT 1")) {/* determine number of fields in result set / fieldcnt=mysqlinumfields(field_cnt = mysqli_num_fields(fieldc​nt=mysqlin​umf​ields(result);printf("Result set has %d fields.\n", $field_cnt);/ close result set /
mysqli_free_result($result);
}/ close connection */
mysqli_close($link);
?> `

The above examples will output: