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代码如下：

<?php
 mysql_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
)

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