/font><br>";
}
}
echo "成功执行{$i}个SQL语句!<br><br>";
echo $nerrCode;
}
else
{
$dsql->ExecuteNoneQuery($sqlquery);
$nerrCode = trim($dsql->GetError());
echo "成功执行1个SQL语句!<br><br>";
echo $nerrCode;
}
exit();
}
if($dopost=="view")
{
;echo ''<html>
<head>
<meta http-equiv=\''Content-Type\'' content=\''text/html; charset=gb2312\''>
<title>SQL命令行工具</title>
<link href=\''img/base.css\'' rel=\''stylesheet\'' type=\''text/css\''>
</head>
<body background=\''img/allbg.gif\'' leftmargin=\''8\'' topmargin=\''8\''>
<table width="98%" border="0" align="center" cellpadding="3" cellspacing="1" bgcolor="#D1DDAA">
<tr>
<td height="19" background="img/tbg.gif">
<table width="96%" border="0" cellspacing="1" cellpadding="1">
<tr>
<td width="24%"><strong>SQL命令运行器:</strong></td>
<td width="76%" align="right"> <b><a href="sys_data.php"><u>数据备份</u></a></b>
| <b><a href="sys_data_revert.php"><strong><u>数据还原</u></strong></a></b>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td height="200" bgcolor="#FFFFFF" valign="top">
<table width="100%" border="0" cellspacing="4" cellpadding="2">
<form action="" method="post" name="infoform" target="stafrm">
<input type=\''hidden\'' name=\''dopost\'' value=\''viewinfo\'' />
<tr bgcolor="#F3FBEC">
<td width="15%" height="24" align="center">系统的表信息:</td>
<td>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="35%">
<select name="tablename" id="tablename" style="width:100%" size="6">
'';
$dsql->SetQuery("Show Tables");
$dsql->Execute(''t'');
while($row = $dsql->GetArray(''t'',MYSQL_BOTH))
{
$dsql->SetQuery("Select count(*) From ".$row[0]);
$dsql->Execute(''n'');
$row2 = $dsql->GetArray(''n'',MYSQL_BOTH);
$dd = $row2[0];
echo " <option value=''".$row[0]."''>".$row[0]."(".$dd.")</option>\r\n";
}
;echo '' </select>
</td>
<td width="2%"> </td>
<td width="63%" valign="bottom">
<div style="float:left;margin-right:20px;">
<input type="Submit" name="Submit1" value="优化选中表" class="coolbg np" onClick="this.form.dopost.value=\''opimize\'';" />
<br />
<input type="Submit" name="Submit2" value="修复选中表" class="coolbg np" onClick="this.form.dopost.value=\''repair\'';" style="margin-top:6px;" />
<br />
<input type="Submit" name="Submit3" value="查看表结构" class="coolbg np" onClick="this.form.dopost.value=\''viewinfo\'';" style="margin-top:6px;" />
</div>
<div style="float:left">
<input type="Submit" name="Submit5" value="优化全部表" class="coolbg np" onClick="this.form.dopost.value=\''opimizeAll\'';" />
<br />
<input type="Submit" nam