In this article, we will focus on the mysqli_fetch_field_direct() function in PHP, which is used to fetch meta-data for a single column by index from a result set. We will provide you with an overview of the function, how it works, and examples of its use.

Introduction to the mysqli_fetch_field_direct() function

The mysqli_fetch_field_direct() function is a built-in function in PHP that is used to fetch metadata for a single column from a MySQLi result set by index. This function is useful when you need to obtain information about a specific column in a MySQLi query result set by its index position.

How to use the mysqli_fetch_field_direct() function

Using the mysqli_fetch_field_direct() function is very simple. You just need to call the function on a valid MySQLi result set and pass in the index of the column you want to fetch metadata for. Here is an example:

$mysqli = mysqli_connect("localhost", "username", "password", "database");

$query = "SELECT * FROM my_table";
$result = mysqli_query($mysqli, $query);

if ($result) {
    $field = mysqli_fetch_field_direct($result, 1);
    printf("Name: %s\n", $field->name);
    printf("Type: %s\n", $field->type);
    printf("Length: %d\n", $field->length);


In this example, we call the mysqli_connect() function to connect to a MySQL database with a username and password. We then execute a query using the mysqli_query() function to select all columns from a table. We store the result in a variable and check if there was a result using the $result variable. If there was a result, we call the mysqli_fetch_field_direct() function to fetch the metadata for the second column in the result set by passing in the $result variable and the index of the column (1-based indexing). We then output the name, type, and length of the column.


In conclusion, the mysqli_fetch_field_direct() function is a useful tool for obtaining metadata about a specific column in a MySQLi query result set by its index position. By understanding how to use the function, you can take advantage of this feature to create powerful and flexible MySQLi queries.

Practice Your Knowledge

What does the fetch_field_direct() function in PHP do?

Quiz Time: Test Your Skills!

Ready to challenge what you've learned? Dive into our interactive quizzes for a deeper understanding and a fun way to reinforce your knowledge.

Do you find this helpful?