dropdown("InventoryLocationID", $inventoryLocation); dropdown("InventoryOwnerID", $inventoryOwner); echo "<br />Picture 1 File Path: <input type='text' name='Picture1Location' id='Picture1Location' value='{$picture1}'/><a href='{$picture1}'><img src='{$picture1}' alt='Picture 1' height='100px' width='100px' /></a>"; echo "<br />Picture 2 File Path: <input type='text' name='Picture2Location' id='Picture2Location' value='{$picture2}'/><a href='{$picture2}'><img src='{$picture2}' alt='Picture 2' height='200px' width='200px' /></a>"; echo "<br />Date Sold: <input type='text' name='DateSold' id='DateSold' value='{$dateSold}' placemarker='dd-mmm-yyyy' />"; dropdown("InventoryConditionID", $inventoryCondition); echo "<br />UPC: <input type='text' name='upc' id='upc' value='{$upc}'/>"; echo "<br />Custm ID: <input type='text' name='customID' id='customID' value='{$customID}' />"; echo "<input type='submit' name='update' value='update' />"; echo "</form>"; break; case "edit": $fields = "InventoryDescription, InventoryTypeID,\tPurchasePrice,\tPurchaseLocation,\tInventoryLocationID,\tInventoryOwnerID, Picture1Location, Picture2Location,\tDateSold, InventoryConditionID, UPC, CustomID"; foreach ($fields as $field) { $newValue = $POST_[$field]; $oldValue = getReturnValue("tInventory", $field, $newValue); if ($oldValue != $newValue) { $editQuery = "UPDATE tInventory SET {$field}='{$newValue}' Where InventoryID='{$id}'"; if (!($result = mysql_query($editQuery))) { echo "<p class='error'>Could not edit {$value} " . mysql_error() . "</p>"; } else { echo "<p class='debug'>{$field} updated from {$oldValue} to {$newValue}</p>"; } } } break; } $fields = "InventoryDescription, InventoryTypeID,\tPurchasePrice,\tPurchaseLocation,\tInventoryLocationID,\tInventoryOwnerID, Picture1Location, Picture2Location,\tDateSold, InventoryConditionID, UPC, CustomID"; function filterDropDown() { dropdownFields($fields, "Filter By", "filterBy", $filterBy);
<?php include_once './panels/getVariables.php'; $userID = getUser(); include_once './panels/menu.php'; echo "<div class='box'>"; $MenuID = $MenuName = $PagePath = $Sequence = $RequiresAuthentication = $ParentItem = $Color = $QueryString = ""; $MenuID = getPost('MenuID'); $MenuName = getPost('MenuName'); $PagePath = getPost('PagePath'); $Sequence = getPost('Sequence'); $RequiresAuthentication = getPost('RequiresAuthentication'); $ParentItem = getPost('ParentItem'); $Color = getPost('Color'); $QueryString = getPost('QueryString'); include_once './panels/dbFunction.php'; $returnID = getReturnValue("tMenu", "MenuName", $MenuName, "MenuID"); if ($returnID == null or $returnID == 0) { include_once './panels/dbMenuItem.php'; addMenuItem($MenuName, $PagePath, $Sequence, $RequiresAuthentication, $ParentItem, $Color, $QueryString); echo "<form method='post' name='getList' action='editMenu.php?u={$userID}' autocomplete='on'>"; echo "<input type='hidden' name='userid' value='{$userID}' />"; echo "<input type='submit' value='Request Services'/>"; echo "</form>"; } else { echo "<p class='error'>{$value} already exists</p>"; echo "<form method='post' name='getList' action='newMenu.php?u={$userID}' autocomplete='on'>"; echo "<input type='hidden' name='userid' value='{$userID}' />"; echo "<input type='submit' value='Request Services'/>"; echo "</form>"; } ?>