PHP数据库字典[markdown版]

PHP数据库字典[markdown版]
请在抬头直接填写;用户名,密码等信息

注意:需要mysql_li扩展

<?php//mysql配置$mysql_conf = array('host' => 'localhost:3306', 'db' => 'dbname', 'db_user' => 'user', 'db_pwd' => 'pwd',);//创建mysqli对象$mysqli = new mysqli($mysql_conf['host'], $mysql_conf['db_user'], $mysql_conf['db_pwd']);if (!$mysqli) {    //诊断连接错误    die("could not connect to the database:\n" . $mysqli->error);} else {    echo "mysql connected\n";}//选择数据库$select_db = $mysqli->select_db($mysql_conf['db']);if (!$select_db) {    die("could not connect to the db:\n" . $mysqli->error);} else {    echo "database selected\n";}//当前脚本地址$path = dirname(__FILE__);//Markdown文件保存地址，防止中文目录乱码$markdownFile = "markdown";$markdownDir  = iconv("UTF-8", "GBK", $path . '/' . $markdownFile . '/' . $mysql_conf['db']);if (!file_exists($markdownDir)) {    //创建目录    if (mkdir($markdownDir, 0777, true)) {        echo "create file " . $markdownFile . " success\n";    } else {        die("create file " . $markdownFile . " failed\n");    }} else {    echo "file " . $markdownFile . " is exist\n";}//数据库概览$overviewFile = $mysql_conf['db'] . ".md";//创建md文件$file = fopen($markdownDir . '/' . $overviewFile, "w+") or die("create file " . $overviewFile . " failed\n");//文本内容$content = <<<markdown# {$mysql_conf['db']}\n-------------------\n[TOC]### overview|   TABLE_NAME  | TABLE_COMMENT   |   ENGINE    | ROW_FORMAT    | TABLE_ROWS    | AVG_ROW_LENGTH| DATA_LENGTH   |   MAX_DATA_LENGTH |    INDEX_LENGTH   |   DATA_FREE   |  AUTO_INCREMENT   | CREATE_TIME   |    UPDATE_TIME|    TABLE_COLLATION|| :--------     | :--------       |  :--------  | :--------     |   --------:   |    --------:  |  --------:    |   --------:       |   --------:       |   --------:   |   --------:       |   --------:   |   --------:   |   --------:       |\nmarkdown;$result = $mysqli->query("SELECT * FROM information_schema.TABLES WHERE TABLE_SCHEMA = '{$mysql_conf['db']}'");while ($overview = $result->fetch_array()) {    $content .= <<<markdown|{$overview['TABLE_NAME']}|{$overview['TABLE_COMMENT']}|{$overview['ENGINE']}|{$overview['ROW_FORMAT']}|{$overview['TABLE_ROWS']}|{$overview['AVG_ROW_LENGTH']}|{$overview['DATA_LENGTH']}|{$overview['MAX_DATA_LENGTH']}|{$overview['INDEX_LENGTH']}|{$overview['DATA_FREE']}|{$overview['AUTO_INCREMENT']}|{$overview['CREATE_TIME']}|{$overview['UPDATE_TIME']}|{$overview['TABLE_COLLATION']}|\nmarkdown;}if (fwrite($file, $content)) {    echo $overviewFile . " success\n";} else {    echo $overviewFile . " failed\n";}//获取所有表，循环获取列信息$tableResult = $mysqli->query("SHOW TABLES");while ($table = $tableResult->fetch_row()) {    //表名    $table   = $table[0];    $content = '';    //文本内容    $content .= <<<markdown\n\n-------------------\n### {$table}\n|   COLUMN_NAME |   COLUMN_DEFAULT|  IS_NULLABLE| COLUMN_TYPE       |    COLUMN_KEY |   EXTRA       | CHARACTER_MAXIMUM_LENGTH  | CHARACTER_OCTET_LENGTH| CHARACTER_SET_NAME|   COLLATION_NAME  |  PRIVILEGES   | COLUMN_COMMENT|| :--------     | :--------       |  :--------  | :--------         |   :--------   |   :--------   |   --------:               |    --------:          |  :--------        |   :--------       |   :--------   |   :--------   |\nmarkdown;    //当前表的列    $clumnResult = $mysqli->query("SELECT * FROM information_schema.COLUMNS WHERE table_name = '{$table}' AND table_schema = '{$mysql_conf['db']}';");    while ($column = $clumnResult->fetch_array()) {        $content .= <<<markdown|{$column['COLUMN_NAME']}|{$column['COLUMN_DEFAULT']}|{$column['IS_NULLABLE']}|{$column['COLUMN_TYPE']}|{$column['COLUMN_KEY']}|{$column['EXTRA']}|{$column['CHARACTER_MAXIMUM_LENGTH']}|{$column['CHARACTER_OCTET_LENGTH']}|{$column['CHARACTER_SET_NAME']}|{$column['COLLATION_NAME']}|{$column['PRIVILEGES']}|{$column['COLUMN_COMMENT']}|\nmarkdown;    }    //写入文件    if (fwrite($file, $content)) {        echo $table . " success\n";    } else {        echo $table . " failed\n";    }}fclose($file);$mysqli->close();

朋友空闲写的,只是搬运过来:https://heimo.space/?p=166