php实现小说字典功能_用php生成数据字典

}else{$database = $_GET['db'];

}$mysql_conn = @mysql_connect("{$dbserver}","{$dbusername}","{$dbpassword}") or die("Mysql connect is error.");mysql_select_db($database,$mysql_conn);$result = mysql_query('show tables',$mysql_conn);mysql_query('SET NAMES utf8',$mysql_conn);//取得所有表名

while($row = mysql_fetch_array($result)){$tables[]['TABLE_NAME'] = $row[0];

}//循环取得所有表的备注及表中列消息

foreach($tables as $k=>$v){$sql = 'SELECT * FROM ';$sql .= 'INFORMATION_SCHEMA.TABLES ';$sql .= 'WHERE ';$sql .= "table_name = '{$v['TABLE_NAME']}' AND table_schema = '{$database}'";$table_result = mysql_query($sql,$mysql_conn);while($t = mysql_fetch_array($table_result)){$tables[$k]['TABLE_COMMENT'] = $t['TABLE_COMMENT'];

}$sql = 'SELECT * FROM ';$sql .= 'INFORMATION_SCHEMA.COLUMNS ';$sql .= 'WHERE ';$sql .= "table_name = '{$v['TABLE_NAME']}' AND table_schema = '{$database}'";$fields = array();$field_result = mysql_query($sql,$mysql_conn);while($t = mysql_fetch_array($field_result)){$fields[] = $t;

}$tables[$k]['COLUMN'] = $fields;

}mysql_close($mysql_conn);$html = '';//循环所有表

foreach($tables as $k=>$v){$html .='

'.$v['TABLE_NAME'] .' '.$v['TABLE_COMMENT'] .'

字段名	数据类型	默认值	允许非空	自动递增	备注

}$html .='

';

}echo '

自动生成数据字典

body,td,th {font-family:"宋体"; font-size:12px;}

table{border-collapse:collapse;border:1px solid #CCC;background:#efefef;}

table caption{text-align:left; background-color:#fff; line-height:2em; font-size:14px; font-weight:bold; }

table th{text-align:left; font-weight:bold;height:26px; line-height:26px; font-size:12px; border:1px solid #CCC;}

table td{height:20px; font-size:12px; border:1px solid #CCC;background-color:#fff;}

.c1{ width: 120px;}

.c2{ width: 120px;}

.c3{ width: 70px;}

.c4{ width: 80px;}

.c5{ width: 80px;}

.c6{ width: 270px;}

'.$title.'

';echo $html;echo '';?>