<?php /** ?* 生成mysql数据字典 ?* ?* @version $id$ ?* @author niming<287384795@qq.com> ?*/$tableName = isset($_GET[‘table‘]) ? $_GET[‘table‘] : "windshield"; $name = $tableName; $dbserver = ‘localhost‘; $dbusername = "root"; $dbpassword = "root"; // if($_GET[‘dbs‘]){ // ???$dbserver = $_GET[‘dbs‘]; // } // if($_GET[‘dbname‘]){ // ???$dbusername = $_GET[‘dbname‘]; // } // if($_GET[‘dbpwd‘]){ // ???$dbpassword = $_GET[‘dbpwd‘]; // } //配置数据库 $database ??= $name; //其他配置 $title = ‘系统数据字典‘; $mysqli = new mysqli("$dbserver", "$dbusername", "$dbpassword","$name");//只能用函数来判断是否连接成功if(mysqli_connect_errno()){ ???echo mysqli_connect_error();}mysqli_query($mysqli,‘SET NAMES utf8‘);$table_result = mysqli_query($mysqli, ‘show tables‘);while ($row = mysqli_fetch_array($table_result)) { ???$tables[][‘TABLE_NAME‘] = $row[0];}// echo "<Pre>";// print_r($tables);// echo "</Pre>";// exit();// ?$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];// ?}// ?echo "<Pre>";// ?print_r($tables);// ?echo "</Pre>"; //循环取得所有表的备注 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 = mysqli_query($mysqli,$sql); ????while ($t = mysqli_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 = mysqli_query($mysqli,$sql); ????while ($t = mysqli_fetch_array($field_result) ) { ????????$fields[] = $t; ????} ????$tables[$k][‘COLUMN‘] = $fields; } mysqli_close($mysqli); $html = ‘‘; //循环所有表 foreach ($tables AS $k=>$v) { ????//$html .= ‘<p style="text-align:left; "><h2>‘. $v[‘TABLE_COMMENT‘] . ‘ </h2>‘; ????$html .= ‘<table ?border="1" cellspacing="0" cellpadding="0" align="center">‘; ????$html .= ‘<caption><span style="font-size:20px;">‘ .$v[‘TABLE_COMMENT‘]."</span> <span style=\"color:red;font-size:20px;\">".$v[‘TABLE_NAME‘].‘</span></caption>‘; ????//$html .= ‘<caption style="color:red;">‘ . $v[‘TABLE_NAME‘] . ‘</caption>‘; ????$html .= ‘<tbody><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 .= ‘</tbody></table></p>‘; } header(‘Content-Type:text/html; charset=utf-8‘); //输出 echo ‘<html> <head> <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 ‘<center><h1>‘ . $title . ‘</h1></center>‘; echo $html; echo ‘</body></html>‘;查看数据结构图table.php
原文地址：https://blog.51cto.com/itafei/2364557