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)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 5Procedural style
<?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 :5MYSQLI Functions mysqli_fetch_field_direct() mysqli_num_rows() Number of rows in result set SELECT query UPDATE query
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
