sys_data.php

来自「这是matlab的一个小程序」· PHP 代码 · 共 102 行

<?php
require_once(dirname(__FILE__)."/config.php");
CheckPurview('sys_Data');
if(empty($dopost))
{
	$dopost = '';
}
if($dopost=="viewinfo") //查看表结构
{
	echo "[<a href='#' onclick='javascript:HideObj(\"_mydatainfo\")'><u>关闭</u></a>]\r\n<xmp>";
	if(empty($tablename))
	{
		echo "没有指定表名！";
	}
	else
	{
		$dsql->SetQuery("SHOW CREATE TABLE ".$dsql->dbName.".".$tablename);
		$dsql->Execute('me');
		$row2 = $dsql->GetArray('me',MYSQL_BOTH);
		$ctinfo = $row2[1];
		echo trim($ctinfo);
	}
	echo '</xmp>';
	exit();
}
else if($dopost=="opimize") //优化表
{
	echo "[<a href='#' onclick='javascript:HideObj(\"_mydatainfo\")'><u>关闭</u></a>]\r\n<xmp>";
	if(empty($tablename))
	{
		echo "没有指定表名！";
	}
	else
	{
		$rs = $dsql->ExecuteNoneQuery("OPTIMIZE TABLE `$tablename` ");
		if($rs)
		{
			echo "执行优化表： $tablename  OK！";
		}
		else
		{
			echo "执行优化表： $tablename  失败，原因是：".$dsql->GetError();
		}
	}
	echo '</xmp>';
	exit();
}
else if($dopost=="repair") //修复表
{
	echo "[<a href='#' onclick='javascript:HideObj(\"_mydatainfo\")'><u>关闭</u></a>]\r\n<xmp>";
	if(empty($tablename))
	{
		echo "没有指定表名！";
	}
	else
	{
		$rs = $dsql->ExecuteNoneQuery("REPAIR TABLE `$tablename` ");
		if($rs)
		{
			echo "修复表： $tablename  OK！";
		}
		else
		{
			echo "修复表： $tablename  失败，原因是：".$dsql->GetError();
		}
	}
	echo '</xmp>';
	exit();
}

//获取系统存在的表信息
$otherTables = Array();
$dedeSysTables = Array();
$channelTables = Array();
$dsql->SetQuery("Select addtable From `#@__channeltype` ");
$dsql->Execute();
while($row = $dsql->GetObject())
{
	$channelTables[] = $row->addtable;
}
$dsql->SetQuery("Show Tables");
$dsql->Execute('t');
while($row = $dsql->GetArray('t',MYSQL_BOTH))
{
	if(ereg("^{$cfg_dbprefix}",$row[0])||in_array($row[0],$channelTables))
	{
		$dedeSysTables[] = $row[0];
	}
	else
	{
		$otherTables[] = $row[0];
	}
}
$mysql_version = $dsql->GetVersion();
include DedeInclude('templets/sys_data.htm');

function TjCount($tbname,&$dsql)
{
	$row = $dsql->GetOne("Select count(*) as dd From $tbname");
	return $row['dd'];
}
?>