optimize.php

来自「极限网络智能办公系统 - Office Automation 2.8 100% 」· PHP 代码 · 共 21 行

PHP
21
字号
<?php

include_once( "inc/auth.php" );
echo "\r\n<html>\r\n<head>\r\n<title>数据库优化</title>\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=gb2312\">\r\n</head>\r\n\r\n<body class=\"bodycolor\" topmargin=\"5\">\r\n\r\n";
$connection = openconnection( );
$TABLE_NAME_STR = "";
$TABLE_COUNT = 0;
$TABLE_ARRAY = mysql_list_tables( $MYSQL_DB );
while ( $TABLE = mysql_fetch_row( $TABLE_ARRAY ) )
{
	++$TABLE_COUNT;
	$TABLE_NAME_STR .= "`".$TABLE[0]."`,";
}
$TABLE_NAME_STR = substr( $TABLE_NAME_STR, 0, -1 );
$query = "OPTIMIZE TABLE {$TABLE_NAME_STR}";
exequery( $connection, $query );
message( "提示", "数据库优化完成!" );
button_back( );
echo "\r\n</body>\r\n</html>\r\n";
?>

⌨️ 快捷键说明

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