What is mysqli_result::fetch_column? fetch_column is a new method added to the mysqli_result class in PHP 8.1. It is used to directly obtain the values ​​of a single column in the result set and avoid additional array access. It has a simple syntax and is similar to fetchColumn in PDO. Examples of use are as follows:

When operating MySQL databases in PHP, the mysqli extension provides a variety of methods to obtain query results, among which mysqli_result::fetch_column and mysqli_fetch_assoc are commonly used methods to read data. But many developers are wondering whether these two can be used together? Can they be combined to play a more flexible role? This article will describe their differences and combination usage in detail with examples.