Example #1
0
     //- 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 = "&amp;action=row_view&amp;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 = "";
         $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();
 }