敢问路在何方

mysql数据表结构生成(系统数据字典)

<?php

header("Content-type: text/html; charset=utf-8");
//配置数据库
$dbserver   = "127.0.0.1";
$dbusername = "dbusername";   //数据库用户名
$dbpassword = "dbpassword";  //密码
$database   = 'dbname';      //数据库名
$title = '系统数据字典';

//下面是连接数据库
try {
    $dsn = "mysql:host=$dbserver;dbname=$database;charset=utf8";
    $pdo = new PDO($dsn, $dbusername, $dbpassword);
    $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

    $table_result = $pdo->query('SHOW TABLES');
    //取得所有的表名
    while ($row = $table_result->fetch(PDO::FETCH_NUM)) {
        $tables[]['TABLE_NAME'] = $row[0];
    }
} catch (PDOException $e) {
    die("数据库连接失败: " . $e->getMessage());
}
//循环取得所有表的备注
foreach ($tables as $k => $v) {
    if (strpos($v['TABLE_NAME'], 'view_') !== false || strpos($v['TABLE_NAME'], 'std_') !== false) {
        continue;
    }
    $sql  = 'SELECT * FROM ';
    $sql .= 'INFORMATION_SCHEMA.TABLES ';
    $sql .= 'WHERE ';
    $sql .= "table_name = ? AND table_schema = ?";
    $stmt = $pdo->prepare($sql);
    $stmt->execute([$v['TABLE_NAME'], $database]);
    while ($t = $stmt->fetch(PDO::FETCH_ASSOC)) {
        $tables[$k]['TABLE_COMMENT'] = $t['TABLE_COMMENT'];
    }
    $sql  = 'SELECT * FROM ';
    $sql .= 'INFORMATION_SCHEMA.COLUMNS ';
    $sql .= 'WHERE ';
    $sql .= "table_name = ? AND table_schema = ?";
    $fields = array();
    $stmt = $pdo->prepare($sql);
    $stmt->execute([$v['TABLE_NAME'], $database]);
    while ($t = $stmt->fetch(PDO::FETCH_ASSOC)) {
        $fields[] = $t;
    }
    $tables[$k]['COLUMN'] = $fields;
}
// PDO连接会在脚本结束时自动关闭


$html = '';
//循环所有表拼接字符串
foreach ($tables as $k => $v) {
    if (strpos($v['TABLE_NAME'], 'view_') !== false || strpos($v['TABLE_NAME'], 'std_') !== false) {
        continue;
    }
    $html .= '<p><h2 style="text-align:center;">' . $v['TABLE_COMMENT'] . ' </h2>';
    $html .= '<table  border="1" cellspacing="0" cellpadding="0" align="center">';
    $html .= '<caption>' . $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><br>';
}


//打印在页面中
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;padding:0 2px;}
    table td{height:20px; font-size:12px; border:1px solid #CCC;background-color:#fff;}
    .c1{ width: 120px; padding:0 2px;}
    .c2{ width: 120px; padding:0 2px;}
    .c3{ width: 70px; padding:0 2px;}
    .c4{ width: 80px; padding:0 2px;}
    .c5{ width: 80px; padding:0 2px;}
    .c6{ width: 270px; padding:0 2px;}
    </style>
    </head>
    <body>';
echo '<h1 style="text-align:center;">' . $title . '</h1>';
echo $html;
echo '</body></html>';