PHP/MySQL Database/Table MetaData
Содержание
Get column data type
<source lang="html4strict">
<?php
mysql_connect("mysql153.secureserver.net","wbex","password"); mysql_select_db("wbex"); $query = "SELECT id as Employee_ID FROM Employee"; $result = mysql_query($query); $row = mysql_fetch_row($result); echo mysql_field_type($result, 0);
?>
</source>
Get column name, type and max length
<source lang="html4strict">
<?php
mysql_connect("mysql153.secureserver.net","wbex","password"); mysql_select_db("wbex"); $query = "SELECT * FROM Employee LIMIT 1"; $result = mysql_query($query); $fields = mysql_num_fields($result); for($count=0;$count<$fields;$count++) { $field = mysql_fetch_field($result,$count);echo "
$field->name $field->type ($field->max_length)
";}
?>
</source>
Get field length
<source lang="html4strict">
<?php
mysql_connect("mysql153.secureserver.net","wbex","password"); mysql_select_db("wbex"); $query = "SELECT FirstName FROM Employee "; $result = mysql_query($query); $row = mysql_fetch_row($result); echo mysql_field_len($result, 0);
?>
</source>
Get table column flag
<source lang="html4strict">
<?php
mysql_connect("mysql153.secureserver.net","wbex","password"); mysql_select_db("wbex"); $query = "SELECT id as Employee_ID FROM Employee"; $result = mysql_query($query); $row = mysql_fetch_row($result); echo mysql_field_flags($result, 0);
?>
</source>
Total number of fields in a table
<source lang="html4strict">
<?php
mysql_connect("mysql153.secureserver.net","wbex","password"); mysql_select_db("wbex");// databasename $fields = mysql_list_fields("wbex","Employee");// databasename and tablename echo "Total number of fields returned: ".mysql_num_fields($fields).".
";
?>
</source>