首页 > 代码库 > php获取数据库结构
php获取数据库结构
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml"><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8" /><style type="text/css"><!--body,table{font-size:13px;}table{table-layout:fixed;emptyempty-cells:show;border-collapse: collapse;margin:0 auto;border:1px solid #cad9ea;}th{height:22px;font-size:13px;font-weight:bold;background-color:#CCCCCC;text-align:center;}td{height:20px;}.tableTitle{font-size:14px; font-weight:bold;}</style><title>数据库结构</title></head><body><div style="margin:0 auto;width:880px; border:1px #006600 solid; font-size:12px; line-height:20px;"><div style="width:100%;height:30px; font-size:16px; font-weight:bold; text-align:center;">网数据库结构<br /><font style="font-size:14px; font-weight:normal;"><?php echo date("Y-m-d h:i:s"); ?></font></div><?php$host = "localhost";$username = "root";$password = "root";$dbname = "ecsotre";$dbconn=mysql_connect($host, $username,$password);$sqlname="information_schema";mysql_select_db($sqlname,$dbconn);session_start();$sql = "SELECT * FROM tables where table_schema=‘".$dbname."‘ order by TABLE_NAME";$result = mysql_query($sql); while($row=mysql_fetch_array($result)){//print_r($row);?> <div style="margin:0 auto; width:100%; padding-top:10px;"><b class="tableTitle">表名： <?php echo $row["TABLE_NAME"] ?> </b> <br /><?php echo $row["TABLE_COMMENT"] ?></div> <table width="100%" border="1"><thead><th width="70">序号</td><th width="170">字段名</td><th width="140">字段类型</td><th width="80">允许为空</td><th width="70">默认值</td><th>备注</td></thead><?php$sql2 = "SELECT * FROM columns where table_name=‘".$row["TABLE_NAME"]."‘ order by COLUMN_NAME";$result2 = mysql_query($sql2); $num=0;while($row2=mysql_fetch_array($result2)){$num = $num+1;//print_r($row);?> <tr><td align="center"><b><?php echo $num ?></b></td><td><?php echo $row2["COLUMN_NAME"] ?></td><td><?php echo $row2["COLUMN_TYPE"] ?></td><td align="center"><?php echo $row2["IS_NULLABLE"] ?></td><td align="center"><?php echo $row2["COLUMN_DEFAULT"] ?></td><td><?php echo $row2["COLUMN_COMMENT"] ?></td></tr><?php}?></table><?php}mysql_close($dbconn);?></div></body></html>
php获取数据库结构
声明：以上内容来自用户投稿及互联网公开渠道收集整理发布，本网站不拥有所有权，未作人工编辑处理，也不承担相关法律责任，若内容有误或涉及侵权可进行投诉： 投诉/举报 工作人员会在5个工作日内联系你，一经查实，本站将立刻删除涉嫌侵权内容。