<?php
require_once '_common.php';
//テーブル名の一覧取得
$arsTableName = getObjectNameList($sDbHostName, $sDbUserName, $sDbPassword, $sDbName, "TABLE");
?>
<html>
<head>
<title>ＭｙＳＱＬ ＤＢＡ ＳＱＬ ＤＢ情報表示＆メンテ作業用画面</title>
<script language="JavaScript" type="text/javascript">
<!--
function chkConfirm() {
res = confirm("実行してよろしいですか？");
return res;
}
-->
</script>
</head>
<body bgcolor="<?php
setBodyColor($sActCd);
?>
">
<h5>接続先：
<?php
print $sDbSiteName . " : " . $sDbName;
?>
</h5>
<div align="center">
<hr>
<form action="sql_end.php" method="post" name="frmAllTable" target="resultFrame" id="frmAllTable">
<h4><font color="#0000FF">全テーブルに対しての処理</font></h4>
$sObjectKind = $_GET['lstObjectKind'];
if ($sObjectKind == "View") {
$sObjectKind = "VIEW";
} else {
if ($sObjectKind == "Stored Procedure") {
$sObjectKind = "PROCEDURE";
} else {
if ($sObjectKind == "Stored Function") {
$sObjectKind = "FUNCTION";
}
}
}
//オブジェクト名の一覧取得
$iRowCnt = 0;
if (!empty($sObjectKind)) {
$arsObjectName = getObjectNameList($sDbHostName, $sDbUserName, $sDbPassword, $sDbName, $sObjectKind);
$iRowCnt = count($arsObjectName);
}
//オブジェクト情報が取得できた時だけ表示
if ($iRowCnt > 0) {
print "<span class=\"style2\"><span class=\"style1\">※複数選択可能</span></span><br>\n";
print "<select name=\"lstSelectObject[]\" size=\"" . $iRowCnt . "\" multiple id=\"lstSelectObject\">\n";
foreach ($arsObjectName as $value) {
print "<option value=\"" . $value[0] . "\">" . $value[0] . "</option>\n";
}
print "</select>\n";
print "<br><br>\n";
print "<input name=\"btnObjectView\" type=\"submit\" id=\"btnObjectView\" value=\"表示\">\n";
//管理者権限のみ表示
if (isAdminAct($sActCd)) {
print "<input name=\"btnObjectModify\" type=\"submit\" id=\"btnObjectModify\" value=\"編集\">\n";
