sys_sql_info.php
4.91 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
<?php
/**
* 数据表信息查看
*
* @version $Id: sys_sql_info.php 1 22:28 2010年7月20日Z tianya $
* @package DedeCMS.Administrator
* @copyright Copyright (c) 2007 - 2010, DesDev, Inc.
* @license http://help.dedecms.com/usersguide/license.html
* @link http://www.dedecms.com
*/
require(dirname(__FILE__)."/config.php");
CheckPurview('sys_Data');
if(empty($dopost)) $dopost = "";
$dbdoc = new MakeDBDocument;
$dbdoc->show();
class MakeDBDocument
{
var $dsql;
function __construct()
{
global $dsql;
$this->dsql = $dsql;
}
//分析具体表
function analyse_table(&$tableinfo, $tablename)
{
$flines = explode("\n", $tableinfo);
$addinfo = $tbinfo = $tb_comment = '';
$fields = array();
foreach($flines as $line)
{
$line = trim($line);
if( $line=='' ) continue;
if( preg_match('/CREATE TABLE/i', $line) ) continue;
if( !preg_match('/`/', $line) )
{
$arr = '';
preg_match("/ENGINE=([a-z]*)(.*)DEFAULT CHARSET=([a-z0-9]*)/i", $line, $arr);
$tbinfo = "ENGINE=".$arr[1].'/CHARSET='.$arr[3];
$arr = '';
preg_match("/comment='([^']*)'/i", $line, $arr);
if( isset($arr[1]) )
{
$tb_comment = $arr[1];
}
continue;
}
if( preg_match('/KEY/', $line) )
{
$addinfo .= $line."<br />\n";
}
else
{
$arr = '';
$nline = preg_replace("/comment '([^']*)'/i", '', $line);
preg_match("/`([^`]*)` (.*)[,]{0,1}$/U", $nline, $arr);
$f = $arr[1];
$fields[ $f ][0] = $arr[2];
$fields[ $f ][1] = '';
$arr = '';
preg_match("/comment '([^']*)'/i", $line, $arr);
if( isset($arr[1]) )
{
$fields[ $f ][1] = $arr[1];
}
}
}
$tablehtml = " <table width=\"960\" align=\"center\" border=\"0\" cellpadding=\"5\" cellspacing=\"1\" bgcolor=\"#C1D1A3\" style=\"font-size:14px;margin-bottom:10px\">
<tr>
<td height=\"34\" colspan=\"3\" bgcolor=\"#DDEDA5\">
<a name=\"{$tablename}\"></a>
<table width=\"90%\" border=\"0\" cellspacing=\"1\" cellpadding=\"1\">
<tr>
<td width=\"29%\"><strong>表名：{$tablename}</strong> <br />($tbinfo)</td>
<td width=\"71%\">说明：{$tb_comment}</td>
</tr>
</table></td>
</tr>
<tr>
<td width=\"20%\" height=\"28\" bgcolor=\"#F7FDEA\">字段名</td>
<td width=\"28%\" bgcolor=\"#F7FDEA\">说明描述</td>
<td bgcolor=\"#F7FDEA\">具体参数</td>
</tr>\n";
foreach($fields as $k=>$v)
{
$tablehtml .= " <tr height=\"24\" bgcolor=\"#FFFFFF\">
<td><b>{$k}</b></td>
<td>{$v[1]}</td>
<td>{$v[0]}</td>
</tr>\n";
}
$tablehtml .= " <tr>
<td height=\"28\" colspan=\"3\" bgcolor=\"#F7FDEA\">
<b>索引：</b><br />
{$addinfo}
</td>
</tr>
</table>";
return $tablehtml;
}
//列出数据库的所有表
function show( $type='' )
{
$namehtml = $tablehtml = '';
$this->dsql->Execute('me', ' SHOW TABLES; ');
while( $row = $this->dsql->GetArray('me', MYSQL_NUM) )
{
// print_r($row);exit;
$this->dsql->Execute('dd', " Show CREATE TABLE `{$row[0]}` ");
$row2 = $this->dsql->GetArray('dd', MYSQL_NUM);
if( $type=='' )
{
if( preg_match("/^cms_/", $row[0]) ) continue;
}
else
{
if( !preg_match("/^".$type."_/", $row[0]) ) continue;
}
$namehtml .= "<a href='#{$row[0]}'>{$row[0]}</a> | ";
$tablehtml .= $this->analyse_table( $row2[1], $row[0]);
}
$htmlhead = "<!DOCTYPE html PUBLIC \"-//W3C//DTD XHTML 1.0 Transitional//EN\" \"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd\">
<html xmlns=\"http://www.w3.org/1999/xhtml\">
<head>
<meta http-equiv=\"Content-Type\" content=\"text/html; charset={$cfg_soft_lang}\" />
<link href=\"css/base.css\" rel=\"stylesheet\" type=\"text/css\">
<style>
* {
font-size:14px;
font-family:Arial, \"宋休\", \"Courier New\";
}
a {
text-decoration:none;
}
</style>
<title>数据库说明文档</title>
</head>
<body background='images/allbg.gif' leftmargin='8' topmargin='8'>";
echo $htmlhead;
echo "<table align='center' width='960' style='margin-bottom:8px' ><tr><td>".$namehtml."</td></tr></table>";
echo $tablehtml;
echo "</body>\n</html>";
exit();
}//end show
}