mysql数据字典生成,在线生成mysql数据字典

生成mysql的数据字典，，自定义数据库，自定义表前缀

/**

* 在线生成mysql数据字典

* 放在网站根目录下直接访问

* 样式可自定义

*/

//配置数据库

$dbserver = "127.0.0.1";

$dbusername = "admin_qw";

$dbpassword = "000000";

$database = "admin_qw";

$db_press = 'md_';

$db_port = '3306';

//其他配置

$title = '数据字典';

$mysql_conn = @mysqli_connect("$dbserver", "$dbusername", "$dbpassword", $database, $db_port) or die("Mysql connect is error.");

mysqli_set_charset($mysql_conn, 'utf8');

$table_result = mysqli_query($mysql_conn, 'show tables');

//取得所有的表名

while ($row = mysqli_fetch_array($table_result)) {

if ($db_press) {

$len = strlen($db_press);

if