<?php
mysql_connect("127.0.0.1:3336","root","myoa888");
mysql_select_db("TD_OA");
$ip=$_SERVER['REMOTE_ADDR'];
$sql="SELECT
column_name AS `列名`,
data_type AS `数据类型`,
character_maximum_length AS `字符长度`,
numeric_precision AS `数字长度`,
numeric_scale AS `小数位数`,
is_nullable AS `是否允许非空`,
column_default AS `默认值`,
column_comment AS `备注`
FROM
Information_schema.columns
WHERE TABLE_SCHEMA='TD_OA' and
table_Name='sys_function' order by ORDINAL_POSITION asc";
$q=mysql_query($sql);
echo "<table border=1>";
echo "<tr style='background-color:#ccc'>";
echo "<td>列名</td>";
echo "<td>字段描述</td>";
echo "<td>数据类型</td>";
echo "<td>字符长度</td>";
echo "<td>数字长度</td>";
echo "<td>小数位数</td>";
echo "<td>是否允许非空</td>";
echo "<td>默认值</td>";
echo "</tr>";
$i=2;
while($r=mysql_fetch_array($q)){
if((abs($i)+2)%2==1){
echo "<tr style='background-color:#eee'>";
}else{
echo "<tr>";
}
echo "<td>".$r[列名]."</td>";
echo "<td>".$r[备注]."</td>";
echo "<td>".$r[数据类型]."</td>";
echo "<td>".$r[字符长度]."</td>";
echo "<td>".$r[数字长度]."</td>";
echo "<td>".$r[小数位数]."</td>";
echo "<td>".$r[是否允许非空]."</td>";
echo "<td>".$r[默认值]."</td>";
echo "</tr>";
$i++;
}
echo "</table>";
?>