Viewing file: editcolumn.php (4.79 KB) -rw-rw-rw- Select action/file-type: (+) | (+) | (+) | Code (+) | Session (+) | (+) | SDB (+) | (+) | (+) | (+) | (+) | (+) |
<?php /*
SQL Buddy - Web based MySQL administration http://www.sqlbuddy.com/
editcolumn.php - edit database table columns
MIT license
2008 Calvin Lough <http://calv.in>
*/
include "functions.php";
loginCheck();
requireDatabaseAndTableBeDefined();
if (isset($db)) $conn->selectDB($db);
if (isset($db)) $structureSql = $conn->query("SHOW FULL FIELDS FROM `$table`");
if (isset($_POST['editParts']) && $conn->isResultSet($structureSql)) { $editParts = $_POST['editParts']; $editParts = explode("; ", $editParts); $totalParts = count($editParts); $counter = 0; $firstField = true; ?> <script type="text/javascript" authkey="<?php echo $requestKey; ?>"> if ($('EDITCOLUMNFIRSTFIELD')) { $('EDITCOLUMNFIRSTFIELD').focus(); } </script> <?php while ($structureRow = $conn->fetchAssoc($structureSql)) { if (in_array($structureRow['Field'], $editParts)) { echo '<form id="editform' . $counter . '" querypart="' . $structureRow['Field'] . '" onsubmit="saveColumnEdit(\'editform' . $counter . '\'); return false;">'; echo '<div class="editcolumn">'; echo '<div class="errormessage" style="margin: 0 7px 13px; display: none"></div>'; echo '<table class="edit" cellspacing="0" cellpadding="0">'; preg_match("/^([a-z]+)(.([0-9]+).)?(.*)?$/", $structureRow['Type'], $matches); $curtype = $matches[1]; $cursizeQuotes = $matches[2]; $cursize = $matches[3]; $curextra = $matches[4]; ?> <tr> <td class="secondaryheader"> <?php echo __("Name:"); ?> </td> <td class="inputarea"> <input type="text" class="text" name="NAME"<?php if ($firstField) echo ' id="EDITCOLUMNFIRSTFIELD"'; ?> value="<?php echo $structureRow['Field']; ?>" style="width: 125px" /> </td> <td class="secondaryheader"> <?php echo __("Type:"); ?> </td> <td class="inputarea"> <select name="TYPE" onchange="toggleValuesLine(this, 'editform<?php echo $counter; ?>')" style="width: 125px"> <?php foreach ($typeList as $type) { echo '<option value="' . $type . '"'; if ($type == $curtype) echo ' selected'; echo '>' . $type . '</option>'; } ?> </select> </td> </tr> <?php echo '<tr class="valueline inputarea"'; if (!($curtype == "enum" || $curtype == "set")) echo ' style="display: none"'; echo '>'; ?> <td class="secondaryheader"> <?php echo __("Values:"); ?> </td> <td class="inputarea"> <input type="text" class="text" name="VALUES" value="<?php if (substr($curextra, 0, 1) == "(" && substr($curextra, -1) == ")") echo $curextra; ?>" style="width: 125px" /> </td> <td colspan="2"> </td> </tr> <tr> <td class="secondaryheader"> <?php echo __("Size:"); ?> </td> <td class="inputarea"> <input type="text" class="text" name="SIZE" value="<?php echo $cursize; ?>" style="width: 125px" /> </td> <td class="secondaryheader"> <?php echo __("Default:"); ?> </td> <td class="inputarea"> <input type="text" class="text" name="DEFAULT" value="<?php echo $structureRow['Default']; ?>" style="width: 125px" /> </td> </tr> <?php if (isset($charsetList) && isset($collationList)) { echo "<tr>"; echo "<td class=\"secondaryheader\">"; echo __("Charset:"); echo "</td>"; echo "<td class=\"inputarea\" colspan=\"3\">"; echo "<select name=\"CHARSET\" style=\"width: 125px\">"; echo "<option></option>"; if ($structureRow['Collation'] != "NULL" && isset($structureRow['Collation'])) { $currentCharset = $collationList[$structureRow['Collation']]; } foreach ($charsetList as $charset) { echo "<option value=\"" . $charset . "\""; if (isset($currentCharset) && $charset == $currentCharset) { echo ' selected="selected"'; } echo ">" . $charset . "</option>"; } echo "</select>"; echo "</td>"; echo "</tr>"; } ?> <tr> <td class="secondaryheader"> <?php echo __("Other:"); ?> </td> <td colspan="3" class="inputarea"> <label><input type="checkbox" name="UNSIGN"<?php if ($curextra == " unsigned") echo " checked"; ?>><?php echo __("Unsigned"); ?></label> <label><input type="checkbox" name="BINARY"<?php if ($curextra == " binary") echo " checked"; ?>><?php echo __("Binary"); ?></label> <label><input type="checkbox" name="NOTNULL"<?php if ($structureRow['Null'] != "YES") echo " checked"; ?>><?php echo __("Not Null"); ?></label> </td> </tr> <?php $firstField = false; ?> <tr> <td style="padding: 5px 0 15px" colspan="4"> <input type="submit" class="inputbutton" value="<?php echo __("Submit"); ?>" /> <a onclick="cancelEdit('editform<?php echo $counter; ?>')"><?php echo __("Cancel"); ?></a> </td> </tr> </table> </div> </form> <?php $counter++; } } }
?>
|