PHPキーを使用してMySQLデータベース辞書を生成

header('content-type:text/html;charset=utf-8'); 
define('DB_HOST','localhost'); 
define('DB_USER','root'); 
define('DB_PASS',''); 
define('DB_NAME','youer'); 
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 'br> "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> 
 
 
 
 
 
 
 
 
 
'.APPNAME.'--     
  
( :'.$tab_count.'テーブル、ctrl+Fでキーワードを  )'."n";for($i=0;$iecho''."n";echo';echo($i+1).',  :'.$Array[$i.']     :'.$array$i; echo '  '."n";//データベースフィールド  $tab_のクエリーname = $array$i; $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'."
"; 
    echo '          '."
"; 
    echo '          '."
"; 
    echo '          '."
"; 
    echo '          '."
"; 
    echo '          '."
"; 
    echo '          '."
"; 
    echo '          '."
"; 
    echo '        '."
"; 
} 
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']) . '
'."
"; 
echo ''."
"; 
  
} echo ''."n"; echo ''."n";