📄 repair.htm

📁 程序安装简便容易
💻 HTM
字号:
<!--
<?php
include_once template('head','admin');
print <<<EOT
-->
<body background-color: #9EB6D8 text="#000000" leftmargin="10" topmargin="10">
<!--
EOT;
if(empty($_GET['do'])) {
print <<<EOT
-->
<br>
<table cellspacing="1" cellpadding="4" width="90%" align="center" class="tableborder">
<tr class="header"><td>提示信息</td></tr>
<tr bgcolor="#F8F8F8"><td>
<br><ul><li>修复表 : 此操作可修复数据库在进行查询，删除，更新等操作时产生的错误</ul>
<ul><li>优化表 : 此操作可去除数据文件中的碎片，使记录排列紧密，提高读写速度</ul>
</td></tr></table>

<br>
<table cellspacing="1" cellpadding="4" width="90%" align="center" class="tableborder">
<form method="post" action="admin.php?job=repair&do=do">
<tr align="center" class="header">
<td>选择</td><td>数据表</td><td>类型</td><td>记录数</td>
<td>数据</td><td>索引</td><td>碎片</td></tr>
<!--
EOT;
foreach($catedb as $cate) {
	$checked=$cate['Type']=='MyISAM' ? 'checked' : 'disabled';
	$totalsize+=$cate['Data_length']+$cate['Index_length'];
print <<<EOT
-->
<tr>
<td bgcolor="#F8F8F8" align="center"><input type="checkbox" name="tabledb[]" value="{$cate['Name']}" {$checked}></td>
<td bgcolor="#FFFFFF" align="center">{$cate['Name']}</td>
<td bgcolor="#F8F8F8" align="center">{$cate['Type']}</td>
<td bgcolor="#FFFFFF" align="center">{$cate['Rows']}</td>
<td bgcolor="#F8F8F8" align="center">{$cate['Data_length']}</td>
<td bgcolor="#FFFFFF" align="center">{$cate['Index_length']}</td>
<td bgcolor="#F8F8F8" align="center">{$cate['Data_free']}</td>
</tr>
<!--
EOT;
}
print <<<EOT
-->
<tr class="header"><td colspan="7" align="right">尺寸{$totalsize}K</td></tr>

</table>
<center>
<input type="radio" name="action" value="repair">修复表
<input type="radio" name="action" value="optimize" checked>优化表<br><br>
<input type="button" value="全 选" onclick="CheckAll(this.form)">
<input type='submit' value='提 交'>
</center>
</form>
<script language=JavaScript>
function CheckAll(form){
	for (var i=0;i<form.elements.length;i++){
		var e = form.elements[i];
		e.checked == true ? e.checked = false : e.checked = true;
	}
}
</script>
<!--
EOT;
} elseif($_GET['do']=='do') {
print <<<EOT
-->
<table cellspacing="1" cellpadding="4" width="90%" align="center" class="tableborder">
<tr class="header">
<td colspan="3">数据库优化信息</td>
</tr>
<tr>
<td width="20%" bgcolor="#F8F8F8" align="center">数据库表</td><td bgcolor="#FFFFFF" width="20%" align="center">操作</td><td width="60%" bgcolor="#F8F8F8" align="center">信息</td>
</tr>
<!--
EOT;
foreach($msgdb as $msg){
print <<<EOT
-->
<tr>
<td width="20%" bgcolor="#F8F8F8" align="center">{$msg['Table']}</td><td bgcolor="#FFFFFF" width="20%" align="center">{$msg['Op']}</td><td width="60%" bgcolor="#F8F8F8">{$msg['Msg_type']}：{$msg['Msg_text']}</td>
</tr>
<!--
EOT;
}
print <<<EOT
-->
</table>
<!--
EOT;
}
include_once template('foot','admin');
?>
-->
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -