PHP to generate MySQL data dictionary _php tips

The MySQL database to generate a data dictionary, directly available to view database tables, fields, make a data dictionary is very necessary, the following simply to change the configuration can be used, the style is very good.

<?php header (' Content-type:text/html;charset=utf-8 '); 
Define (' db_host ', ' localhost '); 
Define (' Db_user ', ' root '); 
Define (' Db_pass ', ' root '); 
Define (' db_name ', ' test '); 
Define (' Db_port ', 3306); 
Define (' Db_char ', ' UTF8 '); 
Define (' APPNAME ', '); $conn =mysql_connect (db_host. ': '. 
Db_port,db_user,db_pass); 
mysql_select_db (db_name); mysql_query (' Set names '. 
Db_char); $sql = "Show TABLE STATUS from". 
db_name; 
$result =mysql_query ($sql); 
$array =array (); 
while ($rows =mysql_fetch_assoc ($result)) {$array []= $rows; 
}//Table count $tab _count = count ($array); Echo ' <! DOCTYPE HTML PUBLIC "-//W3C//DTD XHTML 1.0 transitional//en" "Http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd ">  

The above is the entire content of this article, I hope to help you learn, but also hope that we support the cloud habitat community.