Explanation of implementation techniques for obtaining the number of fields in PHP_PHP Tutorial

We can count the number of all fields in the table to be queried through the

mysql_num_fields() function. The syntax format of this function is as follows:

int mysql_num_fields (resource $result)

The parameter result is the result set returned after the mysql_query() function is executed. The sample code for getting the number of fields in PHP using the mysql_num_fields() function is as follows:

1. < ?php
2. $connection=mysql_connect("localhost",
   "root","root") or die("Failed to connect to server");
3. mysql_select_db("sunyang",$connection)
   or die("Failed to select database");
4. $query="select * from employee";
5. $result=mysql_query($query) or
   die("Query data failed"); / /Execute query
6. echo mysql_num_fields($result);
   //Number of output fields
7. mysql_free_result($result);
8. mysql_close();
9. ?> >The above is an introduction to the relevant implementation methods of obtaining the number of fields in PHP.