PHP mysqli_num_fields() function

Returns the number of fields (columns) in the result set:

 <?php // Assume database username: root, password: 123456, database: CODERCTO $con=mysqli_connect("localhost","root","123456","CODERCTO"); if (mysqli_connect_errno($con)) { echo "Failed to connect to MySQL: " . mysqli_connect_error(); } $sql = "SELECT name,url FROM websites ORDER BY alexa;";if ($result=mysqli_query($con,$sql)){ // Return the number of fields in the result set $fieldcount=mysqli_num_fields($result); printf("There are %d fields in the result set . ",$fieldcount); // Release the result set mysqli_free_result($result);}mysqli_close($con);?>

Definition and usage

The mysqli_num_fields() function returns the number of fields (columns) in the result set.

grammar

 mysqli_num_fields( result ) ;

technical details