table.php

微信扫码关注公众号，代码整理好后第一时间通知你。

<link rel="stylesheet" href="panel/css/bootstrap.min.css"/>
<style>
    table.table.table-bordered{width: 50%;border: none;}
    table.table.table-bordered tr td,table.table.table-bordered tr th{border: none;}
</style>

<?php
header('content-type:text/html;charset=utf8');
include('dashboard/include/config.inc.php');
define('DB_NAME','bussite');
$sql = 'SHOW TABLES FROM '.DB_NAME;
$res = mysql_query($sql);
//$res = mysql_fetch_assoc($res);

while($table = mysql_fetch_assoc($res))
{
   // var_dump($table);
    $tname = $table['Tables_in_bussite'];
    echo '<h1>表'.$tname;
    echo '<table class="table table-bordered">';
    echo '<tr>';
    echo '<th>字段名</th>';
    echo '<th>类型</th>';
    echo '<th>是否为空</th>';
    echo '<th>主键</th>';
    echo '<th>默认值</th>';
    echo '<th>自增长</th>';
    echo '<th>注释</th>';
    echo '</tr>';
    $sql = 'SHOW FULL COLUMNS FROM '.$tname;
    $rem = mysql_query($sql);
    while($col = mysql_fetch_assoc($rem))
    {
        //var_dump($col);
        echo '<tr>';
        echo '<td>'.$col['Field'].'</td>';
        echo '<td>'.$col['Type'].'</td>';
        echo '<td>'.$col['Null'].'</td>';
        echo '<td>'.$col['Key'].'</td>';
        echo '<td>'.$col['Default'].'</td>';
        echo '<td>'.$col['Comment'].'</td>';
        echo '<td></td>';
        echo '</tr>';
    }
    echo '</table>';
}