mysqli_num_fields()

<?Php
require "config.php";// Database connection file.

if ($result = $connection->query("SELECT * FROM student")) {
    
$field_no = $result->field_count;
echo " Total Number of Fields ".$field_no;
 $result->close();
}
?>

Total Number of Fields 5

$result_set->field_count;

mysqli_num_fields($result_set)

MySQLI database connection file

<?Php
require "config.php";// Database connection file.

if ($result = $connection->query("SELECT * FROM student")) {
    
$field_no = $result->field_count;
echo " Total Number of Fields ".$field_no;
 $result->close();
}
?>

Total Number of Fields 5

MySQL SELECT Query

<?Php
require "config.php";// Database connection file.

if ($result_set = mysqli_query($connection,$query)) {
echo "Total No. of fields :".mysqli_num_fields($result_set);
    mysqli_free_result($result_set);
}
?>

Total No. of fields :5

MySQL DUMP of student table

Subhendu Mohapatra

Author

🎥 Join me live on YouTube

Passionate about coding and teaching, I publish practical tutorials on PHP, Python, JavaScript, SQL, and web development. My goal is to make learning simple, engaging, and project‑oriented with real examples and source code.

← Subscribe to our YouTube Channel here