How PHP generates MySQL data dictionary

It is necessary to generate a data dictionary from MySQL database, which can be used to easily view database tables, fields and make a data dictionary. This article mainly for you in detail the PHP generated MySQL data dictionary of the relevant information, interested in small partners can refer to. We hope to help you.

The following code is simple to change the configuration can be used, the style is also very good.

<?php header (' Content-type:text/html;charset=utf-8 '); Define (' db_host ', ' localhost '); Define (' Db_user ', ' root '); Define (' Db_pass ', ' root '); Define (' db_name ', ' test '); Define (' Db_port ', 3306); Define (' Db_char ', ' UTF8 '); Define (' APPNAME ', '); $conn =mysql_connect (db_host. ': '). Db_port,db_user,db_pass); mysql_select_db (db_name); mysql_query (' Set names '). Db_char); $sql = "SHOW TABLE STATUS from". db_name; $result =mysql_query ($sql); $array =array (); while ($rows =mysql_fetch_assoc ($result)) {$array []= $rows;}//Table count $tab _count = count ($array); Echo ' <! DOCTYPE HTML PUBLIC "-//W3C//DTD XHTML 1.0 transitional//en" "Http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd "> 
Related recommendations:

PHP MySQL PDO query Operation example Introduction

PHP mysqli Extension preprocessing examples

PHP MySQL Connection topic: The most complete PHP connection MySQL Database tutorial summary