PHP生成Mysqlデータ辞書
4744 ワード
$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_COMMENT'] . '
';
$html .= '';
$html .= '';
$html .= '';
$html .= '';
$i = 1;
foreach ($v['COLUMN'] AS $f) {
$td = $i % 2 ? 'td2' : 'td1';
$i++;
$html .= "';
$html .= "';
$html .= "';
$html .= "';
$html .= "';
$html .= "';
$html .= "";
}
$html .= '' . $v['TABLE_NAME'] . ' ' . $v['TABLE_COMMENT'] . '
" . $f['COLUMN_NAME'] . ' " . $f['COLUMN_TYPE'] . ' " . $f['COLUMN_DEFAULT'] . ' " . $f['IS_NULLABLE'] . ' " . ($f['EXTRA'] == 'auto_increment' ? ' ' : ' ') . ' " . $f['COLUMN_COMMENT'] . '
';
}
//
echo '
' . $title . '
';
echo '' . $title . '';
echo $html;
echo '';