首頁 > 開發者 > MySQL

PHP MYSQL資料字典

來源：互聯網
上載者：User
創建阿里雲帳戶，並獲得超過 40 款產品的免費試用版；而企業帳戶則可以享有總值 $1200 的免費試用版。立即註冊！

標籤：

<?php$dbserver = "localhost";    $dbusername="root";    $dbpassword="root";    $title = ‘資料字典‘;    if(!isset($_GET[‘db‘])){        $database = "mydb";    }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 NAME 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 .=‘<table border="1" cellspacing="0" cellpadding="0" align="center">‘;        $html .=‘<caption>‘.$v[‘TABLE_NAME‘] .‘ ‘.$v[‘TABLE_COMMENT‘] .‘</caption>‘;        $html .=‘<tbody><tr><th>欄位名</th><th>資料類型</th><th>預設值</th><th>允許非空</th><th>自動遞增</th><th>備忘</th></tr>‘;        $html .=‘‘;                foreach($v[‘COLUMN‘] AS $f){            $html .=‘<td class="c1">‘.$f[‘COLUMN_NAME‘].‘</td>‘;            $html .=‘<td class="c2">‘.$f[‘COLUMN_TYPE‘].‘</td>‘;            $html .=‘<td class="c3">‘.$f[‘COLUMN_DEFAULT‘].‘</td>‘;            $html .=‘<td class="c4">‘.$f[‘IS_NULLABLE‘].‘</td>‘;            $html .=‘<td class="c5">‘.($f[‘EXTRA‘]==‘auto_increment‘?‘是‘:‘ ‘).‘</td>‘;            $html .=‘<td class="c6">‘.$f[‘COLUMN_COMMENT‘].‘</td>‘;            $html .= ‘</tr>‘;        }        $html .=‘</tbody></table></p>‘;    }    echo ‘<html>            <meta charset="gbk">            <title>自動產生資料字典</title>            <style>                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;}            </style>            <body>‘;    echo ‘<h1 style="text-align:center;">‘.$title.‘</h1>‘;    echo $html;    echo ‘</body></html>‘;?>

 

PHP MYSQL資料字典

本文章原先以中文撰寫並發佈於 aliyun.com，亦設英文版本，僅作資訊用途。本網站不對文章的準確性，完整性或可靠性或其任何翻譯作出任何明示或暗示的陳述或保證。如對該文章有任何疑慮或投訴，請傳送電郵至 info-contact@alibabacloud.com 並提供相關疑慮或投訴的詳細說明。職員會於 5 個工作天內與您聯絡，一經驗證之後，即會刪除該侵權內容。

聯繫我們

該頁面正文內容均來源於網絡整理，並不代表阿里雲官方的觀點，該頁面所提到的產品和服務也與阿里云無關，如果該頁面內容對您造成了困擾，歡迎寫郵件給我們，收到郵件我們將在5個工作日內處理。

如果您發現本社區中有涉嫌抄襲的內容，歡迎發送郵件至： info-contact@alibabacloud.com 進行舉報並提供相關證據，工作人員會在 5 個工作天內聯絡您，一經查實，本站將立刻刪除涉嫌侵權內容。

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

Get Started for Free

  • Sales Support

    1 on 1 presale consultation

    Chat Contact Sales

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

    Open a Ticket

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.

    Learn More