有时候我们拿到别人的数据库，却没有数据字典，这个php小程序帮你轻松解决。
代码是网上找到的，当然，这段代码也仅仅是生成了数据字典，视图，存储过程等等是木有的哦。
<?php
/**
* 生成mysql数据字典
*/
//配置数据库
$dbserver = "127.0.0.1";
$dbusername = "root";
$dbpassword = "";
$database = "";
//其他配置
$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);
$html = "";
//循环所有表
foreach ($tables AS $k=>$v) {
//$html .= "<p><h2 id="v-TABLE-COMMENT">". $v["TABLE_COMMENT"] . " </h2>";
$html .= "<table border="1" cellspacing="0" cellpadding="0" align="center">";
$html .= "<caption>" . $v["TABLE_NAME"] ." ". $v["TABLE_COMMENT"]. "</caption>";
$html .= "<tr><th>字段名</th><th>数据类型</th><th>默认值</th>
<th>允许非空</th>
<th>自动递增</th><th>备注</th></tr>";
$html .= "";
foreach ($v["COLUMN"] AS $f) {
$html .= "<tr><td class="c1">" . $f["COLUMN_NAME"] . "</td>";
$html .= "<td class="c2">" . $f["COLUMN_TYPE"] . "</td>";
$html .= "<td class="c3"> " . $f["COLUMN_DEFAULT"] . "</td>";
$html .= "<td class="c4"> " . $f["IS_NULLABLE"] . "</td>";
$html .= "<td class="c5">" . ($f["EXTRA"]=="auto_increment"?"是":" ") . "</td>";
$html .= "<td class="c6"> " . $f["COLUMN_COMMENT"] . "</td>";
$html .= "</tr>";
}
$html .= "</table></p>";
}
//输出
echo "<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:#efefef;}
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:26px; font-size:12px; border:1px solid #CCC;}
table td{height:20px; font-size:12px; border:1px solid #CCC;background-color:#fff;}
.c1{ width: 120px;}
.c2{ width: 120px;}
.c3{ width: 70px;}
.c4{ width: 80px;}
.c5{ width: 80px;}
.c6{ width: 270px;}
</style>
</head>
<body>";
echo "<h1 id="title">".$title."</h1>";
echo $html;
echo "</body></html>";
?>
Hot AI Tools
Undresser.AI Undress
AI-powered app for creating realistic nude photos
AI Clothes Remover
Online AI tool for removing clothes from photos.
Undress AI Tool
Undress images for free
Clothoff.io
AI clothes remover
AI Hentai Generator
Generate AI Hentai for free.
Hot Article
Hot Tools
Safe Exam Browser
Safe Exam Browser is a secure browser environment for taking online exams securely. This software turns any computer into a secure workstation. It controls access to any utility and prevents students from using unauthorized resources.
WebStorm Mac version
Useful JavaScript development tools
SAP NetWeaver Server Adapter for Eclipse
Integrate Eclipse with SAP NetWeaver application server.
MinGW - Minimalist GNU for Windows
This project is in the process of being migrated to osdn.net/projects/mingw, you can continue to follow us there. MinGW: A native Windows port of the GNU Compiler Collection (GCC), freely distributable import libraries and header files for building native Windows applications; includes extensions to the MSVC runtime to support C99 functionality. All MinGW software can run on 64-bit Windows platforms.
Atom editor mac version download
The most popular open source editor
