Created
May 5, 2014 03:20
-
-
Save jk2K/594c0a4d40fcb9e7d1ff to your computer and use it in GitHub Desktop.
php生成mysql数据字典, 根据作者郭剑锋的代码做了一些小改动, 使得可以生成html, 原址链接http://yuncode.net/code/c_533ce5180d50247
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <?php | |
| /** | |
| * 生成mysql数据字典 | |
| */ | |
| header("Content-type: text/html; charset=utf-8"); | |
| // 配置数据库 | |
| $dbserver = "localhost"; | |
| $dbusername = "mysql用户名"; | |
| $dbpassword = "mysql密码"; | |
| $database = "mysql数据库名"; | |
| // 其他配置 | |
| $title = '数据字典'; | |
| $mysql_conn = @mysql_connect("$dbserver", "$dbusername", "$dbpassword") or die("Mysql connect is error."); | |
| mysql_select_db($database, $mysql_conn); | |
| mysql_query('SET NAMES utf8', $mysql_conn); | |
| $table_result = mysql_query('show tables', $mysql_conn); | |
| // 取得所有的表名 | |
| while($row = mysql_fetch_array($table_result)) { | |
| $tables [] ['TABLE_NAME'] = $row [0]; | |
| } | |
| // 循环取得所有表的备注及表中列消息 | |
| foreach($tables as $k => $v){ | |
| $sql = 'SELECT * FROM '; | |
| $sql .= 'INFORMATION_SCHEMA.TABLES '; | |
| $sql .= 'WHERE '; | |
| $sql .= "table_name = '{$v['TABLE_NAME']}' AND table_schema = '{$database}'"; | |
| $table_result = mysql_query($sql, $mysql_conn); | |
| while($t = mysql_fetch_array($table_result)) { | |
| $tables [$k] ['TABLE_COMMENT'] = $t ['TABLE_COMMENT']; | |
| } | |
| $sql = 'SELECT * FROM '; | |
| $sql .= 'INFORMATION_SCHEMA.COLUMNS '; | |
| $sql .= 'WHERE '; | |
| $sql .= "table_name = '{$v['TABLE_NAME']}' AND table_schema = '{$database}'"; | |
| $fields = array(); | |
| $field_result = mysql_query($sql, $mysql_conn); | |
| while($t = mysql_fetch_array($field_result)) { | |
| $fields [] = $t; | |
| } | |
| $tables [$k] ['COLUMN'] = $fields; | |
| } | |
| mysql_close($mysql_conn); | |
| $content = ''; | |
| // 循环所有表 | |
| foreach($tables as $k => $v){ | |
| // $content .= '<p><h2>'. $v['TABLE_COMMENT'] . ' </h2>'; | |
| $content .= '<table border="1" cellspacing="0" cellpadding="0" align="center">'; | |
| $content .= '<caption>' . $v ['TABLE_NAME'] . ' ' . $v ['TABLE_COMMENT'] . '</caption>'; | |
| $content .= '<tbody><tr><th>字段名</th><th>数据类型</th><th>默认值</th> | |
| <th>允许非空</th> | |
| <th>自动递增</th><th>备注</th></tr>'; | |
| $content .= ''; | |
| foreach($v ['COLUMN'] as $f){ | |
| $content .= '<tr><td class="c1">' . $f ['COLUMN_NAME'] . '</td>'; | |
| $content .= '<td class="c2">' . $f ['COLUMN_TYPE'] . '</td>'; | |
| $content .= '<td class="c3"> ' . $f ['COLUMN_DEFAULT'] . '</td>'; | |
| $content .= '<td class="c4"> ' . $f ['IS_NULLABLE'] . '</td>'; | |
| $content .= '<td class="c5">' . ($f ['EXTRA'] == 'auto_increment' ? '是' : ' ') . '</td>'; | |
| $content .= '<td class="c6"> ' . $f ['COLUMN_COMMENT'] . '</td>'; | |
| $content .= '</tr>'; | |
| } | |
| $content .= '</tbody></table></p>'; | |
| } | |
| // 输出 | |
| $date = date('Y-m-d'); | |
| $html = <<<EOT | |
| <html> | |
| <head> | |
| <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> | |
| <title>$title</title> | |
| <style> | |
| body,td,th {font-family:"宋体"; font-size:12px;} | |
| table{border-collapse:collapse;border:1px solid #CCC;background:#6089D4;} | |
| table caption{text-align:left; background-color:#fff; line-height:2em; font-size:14px; font-weight:bold; } | |
| table th{text-align:left; font-weight:bold;height:26px; line-height:25px; font-size:16px; border:3px solid #fff; color:#ffffff; padding:5px;} | |
| table td{height:25px; font-size:12px; border:3px solid #fff; background-color:#f0f0f0; padding:5px;} | |
| .c1{ width: 150px;} | |
| .c2{ width: 130px;} | |
| .c3{ width: 70px;} | |
| .c4{ width: 80px;} | |
| .c5{ width: 80px;} | |
| .c6{ width: 300px;} | |
| </style> | |
| </head> | |
| <body> | |
| <h1 style="text-align:center;">$title<span style="font-size:14px;color: #ccc;margin-left:20px;">(生成日期: $date)</span></h1> | |
| $content | |
| </body> | |
| </html> | |
| EOT; | |
| file_put_contents('db_dict.html', $html); | |
| echo 'success!'; | |
| ?> |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
代码运行截图
