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>";
$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": $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>";