$tbl = new Table($Server); $tbl->setOwner($User); $tbl->setName($Tablename); if (!$tbl->Truncate()) { $html .= "<P><B>Table truncating failed.</B></P>"; } } elseif ($TRUNCATE == "no") { $html .= "<P><B>Table truncating cancelled.</B></P>"; } case "drop2": $DROP = getData("DROP"); if ($DROP == "yes") { $tbl = new Table($Server); $tbl->setOwner($User); $tbl->setName($Tablename); if (!$tbl->Drop()) { $html .= "<P><B>Table dropping failed.</B></P>"; } } elseif ($DROP == "no") { $html .= "<P><B>Table dropping cancelled.</B></P>"; } default: $html .= "<P>Execute SQL Statement:<br>" . "<form action=\"tbl_detail.php\" method=\"post\" enctype=\"application/x-www-form-urlencoded\">" . "<input type=\"hidden\" name=\"Tablename\" value=\"{$Tablename}\">" . "<input type=\"hidden\" name=\"Server\" value=\"{$Server}\">" . "<input type=\"hidden\" name=\"User\" value=\"{$User}\">" . "<input type=\"hidden\" name=\"mode\" value=\"main\">" . "<input type=\"hidden\" name=\"submode\" value=\"execute\">" . "<textarea name=\"statement\" cols=\"80\" rows=\"5\" wrap=\"VIRTUAL\" style=\"width: 400px\"></textarea><br>" . "<input type=\"Submit\" name=\"BUTTON\" value=\"Execute\">"; $html .= "</form></td></tr></table></p>"; } // end submode content break; default: } // end switch mode $page = new Page("Table Management - " . $User . "." . $Tablename);