PHP mysqli_num_fields() Function

PHP mysqli_num_fields() function returns the number of fields or columns in a result set.

Syntax

int mysqli_num_fields(result);

mysqli_num_fields() Function Parameter

Parameter	Description
result :	Required parameter. The result resource that is being evaluated. This result comes from a call to mysql_query().

mysqli_num_fields() Function Return Value

Return Values :	Returns the number of fields in the result set or FALSE on failure.

mysqli_num_fields() Function Example

<?php
$con = mysqli_connect("localhost","user","password","db");

if (mysqli_connect_errno())
{
	echo "Failed to connect to MySQL: " . mysqli_connect_error();
}

$sql = "SELECT fname,lname FROM employee";
$result = mysqli_query($con, $sql);

echo mysql_num_fields($result);
mysqli_free_result($result);

mysqli_close($con);
?>

« Previous