mysqli_num_fields(): Count Result Fields
Count fields in a result set
field_count reports the number of columns contained in the result set.
<?php
$result = $connection->query('SELECT id, name, mark FROM student LIMIT 1');
echo 'Fields: ' . $result->field_count;
?>Current example first; the detailed examples below are retained for additional learning and comparison.
<?php
require "config.php";// Database connection file.
if ($result = $connection->query("SELECT * FROM student")) {
$field_no = $result->field_count;
<span class='text-danger'>echo " Total Number of Fields ".$field_no;</span>
$result->close();
}
?>Total Number of Fields 5$result_set->field_count;mysqli_num_fields($result_set)The output is number of fields present in the result set.
MySQLI database connection file
Example : Object Oriented Style<?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<?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
Subhendu Mohapatra
Author & Instructor at plus2net
I write and maintain practical tutorials on Python, PHP, SQL, JavaScript, HTML, jQuery, and web development at plus2net. The tutorials focus on clear explanations, working examples, and code that readers can test and adapt while learning.
Connect:
Subscribe to our YouTube Channel here
This article is written by plus2net.com team.
https://www.plus2net.com
