SHOW COLUMNS FROM conn
SHOW FIELDS FROM conn
DESCRIBE conn
SHOW FULL COLUMNS FROM conn
SHOW FULL FIELDS FROM conn
DESC conn
以上6行SQL语句均可用,其中部分语句获取详情更详细。附上完整PHP代码如下:
<style>
table{border:3px solid #0180CF; margin:0 auto;width:92%;}
table td{border:1px solid #a2c6d3;word-wrap:break-word;word-break:break-all;}
.tt{background:#e5f2fa;line-height:150%;}
</style>
<?php
//列出数据库各个表格字段信息
$dbname = "www_12391_net"; //数据库名称
$dbuser = "www_12391_net"; //数据库账号
$dbpass = "www@12391@net"; //数据库密码
$mysqli = new mysqli("localhost",$dbuser,$dbpass,$dbname);
$result = $mysqli->query('SHOW TABLES');//输出此数据库中表结构
while($arr = $result->fetch_assoc()){
$biaoge = $arr['Tables_in_'.$dbname];
$resuls = $mysqli->query('DESCRIBE '.$biaoge);
echo "\r\n<table cellspacing=\"0\">\r\n";
echo "\r\n<caption><h1>表 $biaoge</h1></caption>\r\n";
$ii = 0; $ti=""; $vi = "";
while($err = $resuls->fetch_assoc()){
$ii ++; $vi .= "\r\n<tr>";
foreach ($err as $key=>$val){
if($ii==1) $ti .= "<td>$key</td>";
$vi .= "<td>$val</td>";
}
$vi .= "</tr>";
}
echo "<tr class='tt'>$ti</tr>$vi\r\n</table>";
}