PHP MySQLi mysqli_field_count()

mysqli_field_count()

The mysqli_field_count() function returns the number of columns for the most recent query on a specific connection. This is useful when you want to dynamically check how much data you have received.

EXAMPLE

<?php
$server = "localhost";
$username = "root";
$password = "";
$database = "mysqli_database";

$connection = mysqli_connect($server, $username, $password, $database);
$query = "SELECT * FROM mysqli_table";

mysqli_query($connection, $query);

// Output the number of columns
// NOTE: The mysqli_field_count() function checks the last executed 
// query on this connection and counts how many columns are involved. 
// Since our mysqli_table contains 4 columns, the function will output the number 4.
printf("Number of columns in the selected table: %d", mysqli_field_count($connection));

mysqli_close($connection);
?>

RESULT

The result will be displayed here...

It returns an integer representing the number of fields.

It is used directly on the connection object ($connection).

Useful for the automated generation of HTML tables.