⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 admin_options_optimize_database.php

📁 三國好好 子
💻 PHP
字号:
🔍 
<html>
<head>
<title>WoP Admin Panel - Optimize SQL Database</title>
<link href="..\styles\phaos.css" rel="stylesheet" type="text/css">
</head>
<body>
<center>
<?php

require_once("../config_settings.php");
include "aup.php";

$sql = array();
$sql['host'] = $mysql_server;
$sql['user'] = $mysql_user;
$sql['pass'] = $mysql_password;
$sql['db']   = $mysql_database;
    
mysql_connect($sql['host'], $sql['user'], $sql['pass']) or die ("Can't connect, check the login info!\n");
mysql_select_db($sql['db']) or die ("Can't connect to the database, check the login info!\n");

function optimaliseer()
{
    global $sql;
    $tabellen = mysql_list_tables($sql['db']);
    $totaal = 0;
    
    echo "Size of the Tables:<br /><br />
        <table width=\"600\" border=\"0\" cellspacing=\"2\" cellpadding=\"0\">
        <tr>
            <td width=\"200\"><strong>TABLE</strong></td>
            <td width=\"200\"><strong>BEFORE</STRONG></td>
            <td width=\"200\"><strong>AFTER</strong></td>
        </tr>";
    
    while($tabel_naam = mysql_fetch_row($tabellen))
    {
        $grootte1 = 0;
        $grootte2 = 0;
        
        $query1 = mysql_query("SHOW TABLE STATUS FROM ".$sql['db']." LIKE '".$tabel_naam[0]."'") or die(mysql_error());
        mysql_query("OPTIMIZE TABLE ".$tabel_naam[0]) or die(mysql_error());
        $query2 = mysql_query("SHOW TABLE STATUS FROM ".$sql['db']." LIKE '".$tabel_naam[0]."'") or die(mysql_error());
        
        while($data1 = mysql_fetch_assoc($query1))
            $grootte1 = $grootte1 + floatval($data1["Data_length"]) + floatval($data1["Index_length"]);
        
        while($data2 = mysql_fetch_assoc($query2))
            $grootte2 = $grootte2 + floatval($data2["Data_length"]) + floatval($data2["Index_length"]);
        
        echo "<tr><td>".$tabel_naam[0]."</td>";
        echo "<td>".$grootte1." bytes</td>";
        echo "<td>".$grootte2." bytes</td></tr>";
        
        $totaal += $grootte1 - $grootte2;
        mysql_free_result($query1);
        mysql_free_result($query2);
    }
    
    echo "</tr></table><br /><br />";
    echo "Space Saved ".$totaal." bytes.";
}

optimaliseer();
?>
<form><input type='button' onClick="parent.location='index.php'" value='Back To Admin Panel'></form>
</center>
</body>
</html>

⌨️ 快捷键说明

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