This time to give you a PHP implementation to generate data dictionary steps, PHP implementation to generate data dictionary considerations, the following is the actual case, together to see.
Recent time is urgent, there is no time to blog, while now a bit of time to share a knowledge point. When we do the development, perhaps often encountered on the database analysis, to do a data dictionary, then now the benefits come, everyone just need to focus on the link I sent to help you to solve the data dictionary design, no longer do you download data dictionary that tool, as a developer, Just a few lines of code should be able to take care of this knowledge, then now nonsense I don't say more, we look at the code below, we just need to change your database account and password and then run it.
Effect Show:
Having said so much nonsense, I finally began to write the code:
<?php/*** generate MySQL data dictionary *///config database $dbserver = "127.0.0.1"; $dbusername = "Account"; $dbpassword = "password"; $database = "database";//Other configuration $title = ' data dictionary '; $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);//Get all the table names while ($row = mysql_fetch_array ($table _result)) {$tables [] [' table_name '] = $row [0] ;} Loop through all table notes and column messages in the table 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 = ";//Loop All tables foreach ($tables as $k = $v) {//$html. = ' <p>
Believe that you have read the case of this article you have mastered the method, more exciting please pay attention to the PHP Chinese network other related articles!
Recommended reading:
How to implement ADODB transaction processing in PHP
How to use thinkphp5+uploadify for file uploads