《PHP实现猎取并生成数据库字典的方法_.docx》由会员分享，可在线阅读，更多相关《PHP实现猎取并生成数据库字典的方法_.docx（7页珍藏版）》请在三一文库上搜索。
1、PHP实现猎取并生成数据库字典的方法_ 本文实例讲解并描述了PHP实现猎取并生成数据库字典的方法。分享给大家供大家参考，具体如下： ?php /* * 生成mysql数据字典 */ header(Content-type:text/html;charset=utf-8); / 配置数据库 $database = array(); $databaseDB_HOST = localhost; $databaseDB_NAME = test; $databaseDB_USER = root; $databaseDB_PWD = ; $mysql_conn = mysql_connect($datab
2、aseDB_HOST, $databaseDB_USER, $databaseDB_PWD) or die(Mysql connect is error.); mysql_select_db($databaseDB_NAME, $mysql_conn); $result = mysql_query(show tables, $mysql_conn); mysql_query(set names utf8); / 取得全部表名 while ($row = mysql_fetch_array($result) $tablesTABLE_NAME = $row0; / 循环取得全部表的备注及表中列消
3、息 foreach($tables as $k = $v) $sql = SELECT * FROM ; $sql .= information_schema.TABLES ; $sql .= WHERE ; $sql .= table_name = $vTABLE_NAME AND table_schema = $databaseDB_NAME; $table_result = mysql_query($sql, $mysql_conn); while ($t = mysql_fetch_array($table_result) $tables$kTABLE_COMMENT = $tTABL
4、E_COMMENT; $sql = SELECT * FROM ; $sql .= information_schema.COLUMNS ; $sql .= WHERE ; $sql .= table_name = $vTABLE_NAME AND table_schema = $databaseDB_NAME; $fields = array(); $field_result = mysql_query($sql, $mysql_conn); while ($t = mysql_fetch_array($field_result) $fields = $t; $tables$kCOLUMN
5、= $fields; mysql_close($mysql_conn); $html = ; / 循环全部表 /print_r($tables); foreach($tables as $k = $v) $html .= table border=1 cellspacing=0 cellpadding=0 align=center; $html .= caption表名： . $vTABLE_NAME . . $vTABLE_COMMENT . /caption; $html .= tbodytrth字段名/thth数据类型/thth默认值/thth允许非空/thth自动递增/thth备注/t
6、h/tr; $html .= ; foreach($vCOLUMN AS $f) $html .= td class=c1 . $fCOLUMN_NAME . /td; $html .= td class=c2 . $fCOLUMN_TYPE . /td; $html .= td class=c3 . $fCOLUMN_DEFAULT . /td; $html .= td class=c4 . $fIS_NULLABLE . /td; $html .= td class=c5 . ($fEXTRA = auto_increment?是: ) . /td; $html .= td class=c
7、6 . $fCOLUMN_COMMENT . /td; $html .= /tr; $html .= /tbody/table/p; /* 生成word */ /header ( Content-type:application/vnd.ms-word ); /header ( Content-Disposition:attachment;filename=$databaseDB_NAME数据字典.doc ); /* 生成excel*/ /header ( Content-type:application/vnd.ms-excel ); /header ( Content-Dispositio
8、n:attachment;filename=$databaseDB_NAME数据字典.xls ); / 输出 echo html meta charset=utf-8 title自动生成数据字典/title style body,td,th font-family:宋体; font-size:12px; table,h1,pwidth:960px;margin:0px auto; tableborder-collapse:collapse;border:1px solid #CCC;background:#efefef; table captiontext-align:left; backgr
9、ound-color:#fff; line-height:2em; font-size:14px; font-weight:bold; table thtext-align:left; font-weight:bold;height:26px; line-height:26px; font-size:12px; border:1px solid #CCC;padding-left:5px; table tdheight:20px; font-size:12px; border:1px solid #CCC;background-color:#fff;padding-left:5px; .c1
10、width: 150px; .c2 width: 150px; .c3 width: 80px; .c4 width: 100px; .c5 width: 100px; .c6 width: 300px; /style body; echo h1 style=text-align:center;.$databaseDB_NAME.数据字典/h1; echo p style=text-align:center;margin:20px auto;生成时间： . date(Y-m-d H:i:s) . /p; echo $html; echo p style=text-align:left;margin:20px auto;总共： . count($tables) . 个数据表/p; echo /body/html; ? 盼望本文所述对大家PHP程序设计有所关心。 .