public static function selectAll($inStatus, $inOwner, $inPerformer, $inMFrom, $inMTo, $inPFrom, $inPTo, $inRankFrom, $inRankTo) { global $connection; $query = "SELECT Wishes.Status,\r\n\t\tWishes.WishID, \r\n\t\tWishes.OwnerID, \r\n\t\tUsers.FirstName, \r\n\t\tUsers.LastName, \r\n\t\tUsers.Rank, \r\n\t\tWishes.Description, \r\n\t\tWishes.PriceMoney, \r\n\t\tWishes.PricePoints, \r\n\t\tWishRating.PlusMinus \r\n\t\tFROM (Wishes \r\n\t\tJOIN Users ON Wishes.OwnerID=Users.UserID) \r\n\t\tLEFT JOIN WishRating ON WishRating.WishID = Wishes.WishID AND WishRating.UserID = {$_SESSION['UserID']}"; $conditions = array(); if (isset($inStatus)) { if ($inStatus != '') { $conditions[] = "Wishes.Status={$inStatus}"; } } if (isset($inOwner)) { if ($inOwner != '') { $conditions[] = "Wishes.OwnerID={$inOwner}"; } } if (isset($inPerformer)) { if ($inPerformer != '') { $conditions[] = "Wishes.PerformerID={$inPerformer}"; } } if (isset($inMFrom)) { if ($inMFrom != '') { $conditions[] = "Wishes.PriceMoney >={$inMFrom}"; } } if (isset($inMTo)) { if ($inMTo != '') { $conditions[] = "Wishes.PriceMoney <={$inMTo}"; } } if (isset($inPFrom)) { if ($inPFrom != '') { $conditions[] = "Wishes.PricePoints >={$inPFrom}"; } } if (isset($inPTo)) { if ($inPTo != '') { $conditions[] = "Wishes.PricePoints <={$inPTo}"; } } if (isset($inRFrom)) { if ($inRFrom != '') { $conditions[] = "Users.Rank >={$inRFrom}"; } } if (isset($inRTo)) { if ($inRTo != '') { $conditions[] = "Users.Rank <={$inRTo}"; } } if (count($conditions) > 0) { $query .= " WHERE " . implode(' AND ', $conditions); } $query .= " ORDER BY Wishes.CreateTime LIMIT 0,20"; $result = $connection->select($query); $resultArray = array(); while ($row = $result->fetch_assoc()) { $resultArray[] = wishClass::create($row['WishID'], $row['Status'], $row['OwnerID'], $row['FirstName'], $row['LastName'], $row['Rank'], $row['Description'], $row['PriceMoney'], $row['PricePoints'], $row['PlusMinus']); } return $resultArray; }