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 '';