php mysql获取表字段名称和字段信息的三种方法

php mysql获取表字段名称和字段信息的三种方法
先给出本实例中使用的表的信息：

使用desc获取表字段信息
php代码如下：

<?php mysql_connect（"localhost","root",""）;mysql_select_db（"test"）;$query = "desc student";$result = mysql_query（$query）;while（$row=mysql_fetch_assoc（$result））{ print_r（$row）;}?>

运行结果：

Array（[Field] => student_id[Type] => int（4）[Null] => NO[Key] => PRI[Default] => [Extra] => auto_increment）Array（[Field] => student_name[Type] => varchar（50）[Null] => NO[Key] => [Default] => [Extra] => ）Array（[Field] => class_id[Type] => int（4）[Null] => NO[Key] => [Default] => [Extra] => ）Array（[Field] => total_score[Type] => int（4）[Null] => NO[Key] => [Default] => [Extra] => ）

使用SHOW FULL FIELDS获取表字段信息
php代码如下：

<?php mysql_connect（"localhost","root",""）;mysql_select_db（"test"）;$query = "SHOW FULL COLUMNS FROM student";$result = mysql_query（$query）;while（$row=mysql_fetch_assoc（$result））{ print_r（$row）;}?>

运行结果：

Array（[Field] => student_id[Type] => int（4）[Collation] => [Null] => NO[Key] => PRI[Default] => [Extra] => auto_increment[Privileges] => select,insert,update,references[Comment] => ）Array（[Field] => student_name[Type] => varchar（50）[Collation] => latin1_swedish_ci[Null] => NO[Key] => [Default] => [Extra] => [Privileges] => select,insert,update,references[Comment] => ）Array（[Field] => class_id[Type] => int（4）[Collation] => [Null] => NO[Key] => [Default] => [Extra] => [Privileges] => select,insert,update,references[Comment] => ）Array（[Field] => total_score[Type] => int（4）[Collation] => [Null] => NO[Key] => [Default] => [Extra] => [Privileges] => select,insert,update,references[Comment] => ）

使用mysql_fetch_field方法获取表字段信息
php代码如下：

<?phpmysql_connect（"localhost","root",""）;mysql_select_db（"test"）;$query = "SELECT * FROM student LIMIT 1";$result = mysql_query（$query）;$fields = mysql_num_fields（$result）;for（$count=0;$count<$fields;$count++）{ $field = mysql_fetch_field（$result,$count）;print_r（$field）;}?>

运行结果如下：

stdClass Object（[name] => student_id[table] => student[def] => [max_length] => 1[not_null] => 1[primary_key] => 1[multiple_key] => 0[unique_key] => 0[numeric] => 1[blob] => 0[type] => int[unsigned] => 0[zerofill] => 0）stdClass Object（[name] => student_name[table] => student[def] => [max_length] => 5[not_null] => 1[primary_key] => 0[multiple_key] => 0[unique_key] => 0[numeric] => 0[blob] => 0[type] => string[unsigned] => 0[zerofill] => 0）stdClass Object（[name] => class_id[table] => student[def] => [max_length] => 1[not_null] => 1[primary_key] => 0[multiple_key] => 0[unique_key] => 0[numeric] => 1[blob] => 0[type] => int[unsigned] => 0[zerofill] => 0）stdClass Object（[name] => total_score[table] => student[def] => [max_length] => 3[not_null] => 1[primary_key] => 0[multiple_key] => 0[unique_key] => 0[numeric] => 1[blob] => 0[type] => int[unsigned] => 0[zerofill] => 0）

感谢阅读，希望能帮助到大家，谢谢大家对本站的支持！