echo "<select name='database_switch'>";
 for ($i = 0; $i < sizeof($databases); $i++) {
     if ($databases[$i] == $DBFilename) {
         echo "<option value='" . $databases[$i] . "' selected='selected'>" . $databases[$i] . "</option>";
     } else {
         echo "<option value='" . $databases[$i] . "'>" . $databases[$i] . "</option>";
     }
 }
 echo "</select> ";
 echo "<input type='submit' value='Go'>";
 echo "</form>";
 echo "</fieldset>";
 echo "<fieldset style='margin:15px;'><legend><a href='" . PAGE . "'>" . $DBFilename . "</a></legend>";
 //Display list of tables
 $query = "SELECT name FROM sqlite_master WHERE type='table' ORDER BY name";
 $result = $db->selectArray($query);
 $j = 0;
 for ($i = 0; $i < sizeof($result); $i++) {
     if (substr($result[$i]['name'], 0, 7) != "sqlite_" && $result[$i]['name'] != "") {
         echo "<a href='" . PAGE . "?table=" . $result[$i]['name'] . "'>" . $result[$i]['name'] . "</a><br/>";
         $j++;
     }
 }
 if ($j == 0) {
     echo "No tables in database.";
 }
 echo "</fieldset>";
 echo "<div style='text-align:center;'>";
 echo "<form action='" . PAGE . "' method='post'/>";
 echo "<input type='submit' value='Log Out' name='logout'/>";
 echo "</form>";
Example #2
0
         $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":
     $completed = "";
     $num = $_POST['numRows'];
     $fields = explode(":", $_POST['fields']);
     $z = 0;
     $query = "PRAGMA table_info(" . $db->quote_id($target_table) . ")";
     $result = $db->selectArray($query);
     for ($i = 0; $i < $num; $i++) {
         if (!isset($_POST[$i . ":ignore"])) {
             $query_cols = "";
             $query_vals = "";
             $all_default = true;
             for ($j = 0; $j < sizeof($fields); $j++) {
                 if ($result[$j]['name'] != $fields[$j]) {
                     die($lang['err'] . ' - schema missmatch');
                 }
                 $null = isset($_POST[$i . ":" . $j . "_null"]);
                 if (!$null) {
                     $value = $_POST[$i . ":" . $j];
                 } else {
                     $value = "";
                 }
 echo "<select name='database_switch'>";
 for ($i = 0; $i < sizeof($databases); $i++) {
     if ($i == $_SESSION['currentDB']) {
         echo "<option value='" . $i . "' selected='selected'>" . $databases[$i]['name'] . "</option>";
     } else {
         echo "<option value='" . $i . "'>" . $databases[$i]['name'] . "</option>";
     }
 }
 echo "</select> ";
 echo "<input type='submit' value='Go'>";
 echo "</form>";
 echo "</fieldset>";
 echo "<fieldset style='margin:15px;'><legend><a href='" . PAGE . "'>" . $currentDB['name'] . "</a></legend>";
 //Display list of tables
 $query = "SELECT name FROM sqlite_master WHERE type='table' ORDER BY name";
 $result = $db->selectArray($query);
 $j = 0;
 for ($i = 0; $i < sizeof($result); $i++) {
     if (substr($result[$i]['name'], 0, 7) != "sqlite_" && $result[$i]['name'] != "") {
         echo "<a href='" . PAGE . "?action=row_view&table=" . $result[$i]['name'] . "'>" . $result[$i]['name'] . "</a><br/>";
         $j++;
     }
 }
 if ($j == 0) {
     echo "No tables in database.";
 }
 echo "</fieldset>";
 echo "<div style='text-align:center;'>";
 echo "<form action='" . PAGE . "' method='post'/>";
 echo "<input type='submit' value='Log Out' name='logout'/>";
 echo "</form>";