public function DeleteSeries($series_id) { //DELETE ENTRY FROM POOL SERIES TABLE: $query = new DB_Queries(); $delete_array = $this->CreateArrayFromDB_QueryInputs('Pool Series', 'Series ID', $series_id); $return_variable = $query->DeleteFromDB($delete_array); return $return_variable; //NOTE, MAY WANT TO WRITE ADDITIONAL CODE IN THIS METHOD TO DELETE POOLS ASSOCIATED WITH SERIES? MAY NOT WANT TO AS WELL... LEAVING THIS FOR NOW (9/7/14) }
public function GetFriends($user_id) { include_once 'inc/class.pool.inc.php'; $query = new DB_Queries(); $pool = new Pool(); $users_pools_query = "SELECT `Pool ID` FROM `Pool Membership` WHERE `User ID` = '{$user_id}';"; $result = mysqli_query($this->cxn, $users_pools_query); $return_array = array(); while ($row = mysqli_fetch_assoc($result)) { //for each pool that a user is in: $pool_id = $row['Pool ID']; $pool_member_query = "SELECT `User ID` FROM `Pool Membership` WHERE `Pool ID` = '{$pool_id}';"; $result2 = mysqli_query($this->cxn, $pool_member_query); while ($row_user_id = mysqli_fetch_assoc($result2)) { //for each user that is in the given pool $user_id = $row_user_id['User ID']; $select_array3 = $pool->CreateArrayFromDB_QueryInputs('Email Address', 'TABLE:', 'User', 'User ID', $user_id); $email_array = $query->SelectFromDB($select_array3); $return_array[$user_id] = $email_array['Email Address']; } } return $return_array; }
public function GetPoolsInSeries($series_id, $ended = NULL) { $query = new DB_Queries(); //new instance of the DB_Queries object $select_array = $this->CreateArrayFromDB_QueryInputs('*', 'TABLE:', 'Pool', 'Series ID', $series_id); if (!is_null($ended)) { //if the $ended parameter was passed to the method, we add a "WHERE 'Pool Ended?' = " parameter onto the SQL statement: $select_array[] = 'Pool ended?'; if ($ended == 0) { //if we want to pull only pools that have not already ended: $select_array[] = 0; } else { //if we want to pull only pools that have ended $select_array[] = 1; } } $result = $query->SelectFromDB($select_array); $list_of_pools = array(); $result_type = gettype($result); if ($result_type == "array") { //if only one pool series is found (meaning $result is just an associative array for the single pool series and not a mysqli object) $list_of_pools[$result['Pool ID']] = $result; //store pool series data in list_of_series variable with the series ID as the array key } else { //if more than one pool series is found (meaning $result is a mysqli object, not an associative array) //store all of the found series info in list_of_series array: while ($row = mysqli_fetch_assoc($result)) { $pool_id = $row['Pool ID']; //get info of pool for given series id: $select_pool_info_array = $this->CreateArrayFromDB_QueryInputs('*', 'TABLE:', 'Pool', 'Pool ID', $pool_id); $result2 = $query->SelectFromDB($select_pool_info_array); $list_of_pools[$pool_id] = $result2; //store series info into the list_of_series array } } return $list_of_pools; }