mysqli_fetch_field to get meta data of all fields of column of result set

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

$query="select * from student ";
if ($result_set = mysqli_query($connection,$query)) {
while ($field_details = mysqli_fetch_field($result_set)) {

echo "<br> <b>Name</b>  ".$field_details->name;
echo "<br> <b>Data Type</b>  ".$field_details->type;
echo "<br> <b>Max Length</b>  ".$field_details->max_length;
echo "<br> <b>Length</b>  ".$field_details->length;
echo "<br> <b>Flags</b>  ".$field_details->flags;
echo "<br> <b>Table</b>  ".$field_details->table;
echo "<br><br>";    
}
}
?>

Name id
Data Type 3
Max Length 2
Flags 32769
Table student

Name name
Data Type 253
Max Length 11
Flags 1
Table student

Name class
Data Type 253
Max Length 5
Flags 1
Table student

Name mark
Data Type 3
Max Length 3
Flags 32769
Table student

Name sex
Data Type 253
Max Length 6
Flags 1
Table student

$result_set->fetch_field;

mysqli_fetch_field

The input parameter $result_set is the output of result set identifier of mysqli_query(), mysqli_store_result() or mysqli_use_result().

The output is an object array containing all field defination information, returns FALSE if not available.

MySQLI database connection file

MySQL SELECT Query

Procedural style

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

if ($result = $connection->query("SELECT * FROM student")) {
    
while ($field_details = $result->fetch_field()) {
echo "<br> <b>Name</b>  ".$field_details->name;
echo "<br> <b>Data Type</b>  ".$field_details->type;
echo "<br> <b>Max Length</b>  ".$field_details->max_length;
echo "<br> <b>Flags</b>  ".$field_details->flags;
echo "<br> <b>Table</b>  ".$field_details->table;
echo "<br><br>";
}
 $result->close();
}
?>

MySQL DUMP of student table

MYSQLI Functions mysqli_num_rows() Number of rows in result set SELECT query UPDATE query mysqli_fetch_field_direct(): Field meta data

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

mysqli_fetch_field() : All field details

Subhendu Mohapatra