$sortBy = "id"; } if (isset($_GET["sortOrder"])) { if (trim(strtolower($_GET["sortOrder"])) === "asc") { $sortOrder = "asc"; } else { $sortOrder = "desc"; } } else { $sortOrder = "desc"; } // determine which group to display items from if (isset($_GET["display"])) { $displayGroup = trim(ucwords(strtolower($_GET["display"]))); // check if display group exists if (WishlistGroup::doesGroupExist($user->id, $displayGroup)) { $display = $displayGroup; $showAllItems = false; $sql = 'SELECT wishlistitems.id as id, item, price, groupID, groupName FROM wishlistitems INNER JOIN wishlistgroups ON wishlistitems.groupID = wishlistgroups.id'; $sql .= ' WHERE wishlistitems.userID = ? AND groupName = ?'; $sql .= ' ORDER BY ' . $sortBy . ' ' . $sortOrder; $paramArray = array($user->id, $displayGroup); $wishlistItems = WishlistItem::findBySql($sql, $paramArray); } } if ($showAllItems) { $display = "All Items"; // fetch all items $sql = 'SELECT wishlistitems.id as id, item, price, groupID, groupName'; $sql .= ' FROM wishlistitems INNER JOIN wishlistgroups ON wishlistitems.groupID = wishlistgroups.id'; $sql .= ' WHERE wishlistitems.userID = ?';
<?php if (isset($_POST["saveGroup"])) { if (!isset($_POST["groupName"])) { $processGroupError = true; } else { $groupName = trim(ucwords(strtolower($_POST["groupName"]))); $groupError = false; if (!WishlistGroup::isValidGroupName($groupName)) { $groupError = true; } if (WishlistGroup::doesGroupExist($user->id, $groupName)) { if (!isset($wishlistGroup) || isset($wishlistGroup) && $groupName !== $wishlistGroup->groupName) { $groupError = true; $groupExists = true; } } if (!$groupError) { if ($groupName !== $wishlistGroup->groupName) { $newWishlistGroup = new WishlistGroup(); $newWishlistGroup->userID = $user->id; $newWishlistGroup->groupName = $groupName; if (isset($wishlistGroup)) { $newWishlistGroup->id = $wishlistGroup->id; } $newWishlistGroup->save(); } header("Location: " . BASE_URL . "planner/?manageGroups"); exit; } else { $processGroupError = true;