//- Drop view (=view_drop) //- Drop view (=view_drop) case "view_drop": $query = "DROP VIEW " . $db->quote_id($_POST['viewname']); $result = $db->query($query); if ($result === false) { $error = true; } $completed = $lang['view'] . " '" . htmlencode($_POST['viewname']) . "' " . $lang['dropped'] . "."; $backlinkParameters = ""; break; //- Rename table (=table_rename) //- Rename table (=table_rename) case "table_rename": $query = "ALTER TABLE " . $db->quote_id($_POST['oldname']) . " RENAME TO " . $db->quote($_POST['newname']); if ($db->getVersion() == 3) { $result = $db->query($query, true); } else { $result = $db->query($query, false); } if ($result === false) { $error = true; } $completed = $lang['tbl'] . " '" . htmlencode($_POST['oldname']) . "' " . $lang['renamed'] . " '" . htmlencode($_POST['newname']) . "'.<br/><span style='font-size:11px;'>" . htmlencode($query) . "</span>"; $backlinkParameters = "&action=row_view&table=" . urlencode($_POST['newname']); break; //- Row actions //- Create row (=row_create) //- Row actions //- Create row (=row_create) case "row_create":
/** * Returns the mysql version. * * @return string */ public function getVersion() { $result = $this->getFirstRow('SELECT VERSION() AS version'); if (isset($result['version'])) { return $result['version']; } return parent::getVersion(); }
$error = true; } $completed = "Table '" . $_POST['tablename'] . "' has been emptied.<br/><span style='font-size:11px;'>" . $query . "</span>"; break; /////////////////////////////////////////////// drop table /////////////////////////////////////////////// drop table case "table_drop": $query = "DROP TABLE " . $_POST['tablename']; $db->query($query); $completed = "Table '" . $_POST['tablename'] . "' has been dropped."; break; /////////////////////////////////////////////// rename table /////////////////////////////////////////////// rename table case "table_rename": $query = "ALTER TABLE " . $_POST['oldname'] . " RENAME TO " . $_POST['newname']; if ($db->getVersion() == 3) { $result = $db->query($query, true); } else { $result = $db->query($query, false); } if (!$result) { $error = true; } $completed = "Table '" . $_POST['oldname'] . "' has been renamed to '" . $_POST['newname'] . "'.<br/><span style='font-size:11px;'>" . $query . "</span>"; break; //row actions /////////////////////////////////////////////// create row //row actions /////////////////////////////////////////////// create row case "row_create": $completed = "";
echo "class='tab'"; } echo ">Structure</a>"; echo "<a href='" . PAGE . "?view=sql' "; if ($view == "sql") { echo "class='tab_pressed'"; } else { echo "class='tab'"; } echo ">SQL</a>"; echo "<div style='clear:both;'></div>"; echo "<div id='main'>"; if ($view == "structure") { echo "<b>Database Name</b>: " . $db->getName() . "<br/>"; echo "<b>Path to Database</b>: " . $db->getPath() . "<br/>"; echo "<b>Database Version</b>: " . $db->getVersion() . "<br/>"; echo "<b>PHP Extension Used</b>: " . $db->getType() . "<br/><br/>"; $dbView->generateTableList(); } else { if ($view == "sql") { $dbView->generateSQL(); } } echo "</div>"; } } } } echo "</div>"; echo "<br/>"; $endTimeTot = microtime(true);
/** * Returns the PostgreSQL version. * * @return string */ public function getVersion() { $version = pg_parameter_status($this->linkID, 'server_version'); if (!empty($version)) { return $version; } return parent::getVersion(); }