<option value="5">Spring/Fall</option> <option value="6">Any Season</option> </select> What season is the item for? <p></p> <input type="submit" name="Upload Item"> </form> <?php if (!empty($_FILES['newphoto']) && !empty($_POST['season']) && !empty($_POST['url']) && !empty($_POST['Header']) && !empty($_POST['Description']) && !empty($_POST['sub_category']) && !empty($_POST['gender'])) { $newFile = $_FILES['newphoto']; $originalName = $newFile['name']; if ($newFile['error'] == 0) { $tempName = $newFile['tmp_name']; move_uploaded_file($tempName, "../pictures/{$originalName}"); $_SESSION['photos'][] = $originalName; print "The file {$originalName} was uploaded successfully.\n"; item_table_query($originalName); } else { print "Error: The file {$originalName} was not uploaded.\n"; } } function item_table_query($img_URL) { require_once '../includes/config.php'; $mysqli = new mysqli(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME); $result = $mysqli->query("SELECT MAX(item_ID) FROM item"); $itemID = 0; while ($row = $result->fetch_row()) { $itemID = $row[0] + 1; } $img_URL = "pictures/" . $img_URL; $URL = $_POST['url'];
<option value="3">Unisex</option> </select> What gender is the item for? <p></p> <select name="season"> <option value="1">Spring</option> <option value="2">Summer</option> <option value="3">Fall</option> <option value="4">Winter</option> <option value="5">Spring/Fall</option> <option value="6">Any Season</option> </select> What season is the item for? <p></p> <input type="submit" name="UploadItem"> </form> <?php } if (isset($_POST['UploadItem'])) { item_table_query(); } function item_table_query() { require_once '../includes/config.php'; $mysqli = new mysqli(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME); $item_ID = $_SESSION['item_ID']; print $item_ID; unset($_SESSION['item_ID']); $result = $mysqli->query("SELECT * FROM item WHERE item_id = {$item_ID};"); while ($row = $result->fetch_row()) { $temp = $row; } if (!empty($_POST['url'])) { $URL = $_POST['url']; } else {