How to generate mysql data dictionary in php

Generate a data dictionary from the mysql database, which can be used directly to view database tables and fields. It is necessary to make a data dictionary. This article mainly introduces the relevant information of PHP to generate mysql data dictionary in detail. Interested friends can refer to it. I hope to be helpful.

The following code can be used by simply changing the configuration, and the style is also very good.

 
 
 
 
 
 

 
 
 
  '.APPNAME.'--数据字典 
 
（注：共'.$tab_count.'张表，按ctrl+F查找关键字）
'."\n"; 
for($i=0;$i<$tab_count;$i++){ 
echo '
'."\n"; 
echo ' 
'; 
echo ($i+1).'、表名：[' . $array[$i]['Name'] . ']   注释：' . $array[$i]['Comment']; 
echo '
'."\n"; 
//查询数据库字段信息 
$tab_name = $array[$i]['Name']; 
$sql_tab='show full fields from `' . $array[$i]['Name'].'`'; 
$tab_result=mysql_query($sql_tab); 
$tab_array=array(); 
  
while($r=mysql_fetch_assoc($tab_result)){ 
  $tab_array[]=$r; 
} 
//show keys 
$keys_result=mysql_query("show keys from `".$array[$i]['Name'].'`',$conn); 
$arr_keys=mysql_fetch_array($keys_result); 
  echo '
'; 
  echo ''; 
  for($j=0;$j'."\n"; 
    echo '     '."\n"; 
    echo '     '."\n"; 
    echo '     '."\n"; 
    echo '     '."\n"; 
    echo '     '."\n"; 
    echo '     '."\n"; 
    echo '     '."\n"; 
    echo '    '."\n"; 
  } 
  echo ' 
 
    
字段
 
    
类型
 
    
为空
 
    
额外
 
    
默认
 
    
整理
 
    
备注
' . $tab_array[$j]['Field'] . '
' . $tab_array[$j]['Type'] . '
' . ($key_value!=''?$key_value:$tab_array[$j]['Null']) . '
' . $tab_array[$j]['Extra'] . '
' . $tab_array[$j]['Default'] . '
' . $tab_array[$j]['Collation'] . '
' . ($key_value!=''?$key_name:$tab_array[$j]['Comment']) . '
'."\n"; 
  echo '
'."\n"; 
  
} 
echo ''."\n"; 
echo ''."\n";

Related recommendations:

php mysql PDO query operation example introduction

php mysqli extension preprocessing example detailed explanation

php mysql connection topic: the most complete PHP connection mysql database tutorial summary

The above is the detailed content of How to generate mysql data dictionary in php. For more information, please follow other related articles on the PHP Chinese website!