How to obtain the field name and detailed information of a mysql data table using PHP?

This article describes how to obtain the field name and detailed information of a mysql data table by using PHP. This article also describes how to obtain the data table structure and list database data tables, you can refer to the following SQL statements for querying MySQL database/table information:

The code is as follows:

Show databases // list MySQL Server DATABASES.
Show tables [FROM db_name] // Lists Database data TABLES.
Show create tables tbl_name // export the data table structure.
Show table status [FROM db_name] // lists data tables and table status information.
Show columns from tbl_name [FROM db_name] // list data table fields
Show fields from tbl_name [FROM db_name], DESCRIBE tbl_name [col_name].
Show full columns from tbl_name [FROM db_name] // list fields and details
Show full fields from tbl_name [FROM db_name] // list the complete attributes of a field
Show index from tbl_name [FROM db_name] // list table indexes.
Show status // list the STATUS of the DB Server.
Show variables // list MySQL system environment VARIABLES.
Show processlist // list the execution commands.
Show grants for user // list permissions of a user

From the preceding SQL statement, we can use SHOW FULL COLUMNS to list fields and details. the sample code is as follows:

The code is as follows:

$ Rescolumns = mysql_query ("show full columns from". TB_NAME ."");
While ($ row = mysql_fetch_array ($ rescolumns )){
// Echo 'field name :'. $ row ['field']. '-data type :'. $ row ['type']. '-Note :'. $ row ['comment'];
// Echo'

';
Print_r ($ row );
}

Print result:

The code is as follows:

Array ([0] => id [Field] => id [1] => char (2) [Type] => char (2) [2] => utf8_general_ci [Collation] => utf8_general_ci [3] => NO [Null] => NO [4] => PRI [Key] => PRI [5] => [Default] => [6] => [Extra] => [7] => select, insert, update, references [Privileges] => select, insert, update, references [8] => [Comment] =>)

Array ([0] => title [Field] => title [1] => char (50) [Type] => char (50) [2] => utf8_general_ci [Collation] => utf8_general_ci [3] => YES [Null] => YES [4] => [Key] => [5] => [default] => [6] => [Extra] => [7] => select, insert, update, references [Privileges] => select, insert, update, references [8] => recommended storage: title, name, and other information [Comment] => recommended storage: title, name, and other information)

Array ([0] => des [Field] => des [1] => varchar (255) [Type] => varchar (255) [2] => utf8_general_ci [Collation] => utf8_general_ci [3] => YES [Null] => YES [4] => [Key] => [5] => [default] => [6] => [Extra] => [7] => select, insert, update, references [Privileges] => select, insert, update, references [8] => [Comment] =>)

............

Additional information:

Of course, you can also use mysql_list_fields-to list fields in MySQL results. Mysql_list_fields () obtains the information of the given table name. The parameter is the database name and table name, and a result pointer is returned.

However, the mysql_list_fields () function is out of date. It is better to use mysql_query () to issue an SQL statement of SHOW COLUMNS FROM table [LIKE 'name. For details, refer to the PHP help documentation: PHP: mysql_list_fields-Manua