📄 database.php
字号:
<?php
session_start();
include "../include/query.php";
include "../include/functions.php";
if($_SESSION["administrator"]=="")
{
header("location:../notice.php?id=".admin_only);
exit;
}
timer();
$db = new db_query;
$db->connect();
?>
<html>
<head>
<title>
<?=getConfig("chatroom_name")?> -- 数据库管理
</title>
<META http-equiv="Content-Type" content="text/html;charset=gb2312">
<link rel="StyleSheet" type="text/css" href="../styles/admin.css">
<Script language=javascript>
function selectAll(fm)
{
for(var i=0;i<fm.elements.length;i++)
{
var e = fm.elements[i];
if(e.name=="table[]")
{
e.checked = fm.sl.checked;
}
}
}
</script>
</head>
<body bgcolor="<?=getConfig("page_bgcolor")?>">
<?php
include "menu.php";
?>
<table width=700 align="center" cellspacing=0 cellpadding=0 class="messagebox">
<tr>
<td class="messagetitle">
数据库管理
</td>
</tr>
<tr>
<td class="messageright">
<table width=700>
<form name="dbForm" method="post" action="saveconfig.php?w=database">
<input type="hidden" name="act">
<tr>
<td colspan=2 align="center">
<table width=600 cellpadding=3 cellspacing=1 bgcolor="black">
<tr>
<td bgcolor="#6699ff" align="center" colspan=7><b>数据库基本信息</b></td>
</tr>
<tr>
<td width=100 bgcolor="buttonface" align="center"><b>表名</b></td>
<td width=80 bgcolor="buttonface" align="center"><b>总行数</b></td>
<td width=80 bgcolor="buttonface" align="center"><b>总大小</b></td>
<td width=80 bgcolor="buttonface" align="center"><b>多余数据</b></td>
<td width=80 bgcolor="buttonface" align="center"><b>数据大小</b></td>
<td width=80 bgcolor="buttonface" align="center"><b>索引大小</b></td>
<td width=100 bgcolor="buttonface" align="center"><b><input type="checkbox" onclick="selectAll(document.dbForm)" name="sl"></b></td>
</tr>
<?php
//show database
$dbResult = $db->query("show table status from ".$DbName);
while($dbRow = $db->fetchArray($dbResult))
{
$actions = "<a href='saveconfig.php?w=database&act=repair&databasename={$dbRow["Name"]}'>修复</a>";
if($dbRow["Data_free"])
{
$actions.=" <a href='saveconfig.php?w=database&act=optimize&databasename={$dbRow["Name"]}'>优化</a>";
}
?>
<tr>
<td width=100 bgcolor="white" align="center"><?=$dbRow["Name"]?></td>
<td width=60 bgcolor="white" align="center"><?=number_format($dbRow["Rows"])?></td>
<td width=60 bgcolor="white" align="center"><?=number_format($dbRow["Index_length"]+$dbRow["Data_length"]+$dbRow["Data_free"])?></td>
<td width=80 bgcolor="white" align="center"><?=number_format($dbRow["Data_free"])?></td>
<td width=80 bgcolor="white" align="center"><?=number_format($dbRow["Data_length"])?></td>
<td width=80 bgcolor="white" align="center"><?=number_format($dbRow["Index_length"])?></td>
<td width=100 bgcolor="white" align="center"><input type="checkbox" name="table[]" value="<?=$dbRow["Name"]?>"</td>
</tr>
<?php
}
?>
</table>
</td>
</tr>
<tr>
<td colspan=2 align="center">
以上数据单位为Bytes ， 当聊天室运行不正常时，请修复所有表。
<input type="button" onclick="act.value='repair';dbForm.submit()" value="修复表">
<input type="button" onclick="act.value='optimize';dbForm.submit()" value="优化表">
</form>
</td>
</tr>
</table>
</td>
</tr>
</table>
<br>
<?php
include "../include/copyrights.php";
?>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -