/** * Method to fetch favorite record * * @param $favouriteBO */ public function getallfavourite($favouriteBO) { try { $connection = new ConnectionManager(); $link = $connection->getConnection(); // select query for favourite table $email_id = $favouriteBO->getEmailId(); $query = "SELECT tutorial_id FROM favourite WHERE email_id='{$email_id}' ORDER BY id ASC"; $result = mysql_query($query, $link) or die(mysql_error()); $favouritesArray = array(); while ($success = mysql_fetch_object($result)) { $favourites = new FavouriteBO(); $favourites->setTutorialId($success->tutorial_id); $favourites->getTutorialId(); //storing the objects in an array $favouritesArray[] = $favourites; } return $favouritesArray; // } catch (Exception $e) { throw new Exception("MESSAGE:" . $e->getMessage()); } }
/** * Method for fetching favourites * * @param email * @return boolean * @throws Exception */ public function getallfavourite() { try { $data = json_decode($_REQUEST['data'], 'true'); $validArray = array('email_id' => ''); if (empty($data)) { $error = array('status_code' => ERR_DATA_CODE, 'result_object' => '', 'status_message' => MSG_DATA_NOT_PROVIDED); echo json_encode($error); exit; } else { $this->checkData($validArray, $data); $favouriteBL = new FavouriteBL(); $favouriteBO = new FavouriteBO(); $emailId = $data['email_id']; $favouriteBO = new FavouriteBO(); $favouriteBO->setEmailId($emailId); $success = $favouriteBL->getallfavourite($favouriteBO); if (is_array($success) && count($success) > 0) { foreach ($success as $favObject) { $response['favourites'][]['tutorial_id'] = $favObject->getTutorialId(); } $error = array('status_code' => ERRCODE_RESULT_SUCCESS, 'result_object' => $response, 'status_message' => MSG_RESULT_SUCCESS); echo json_encode($error); exit; } else { $response['favourites'] = $success; $error = array('status_code' => ERRCODE_RESULT_SUCCESS, 'result_object' => $response, 'status_message' => MSG_RESULT_SUCCESS); echo json_encode($error); exit; } } } catch (Exception $e) { throw new Exception($e->getMessage()); } }