require_once "config.php";
require_once $config->getIncludeURL(Config::INCLUDES_PATH, "common_includes.php.inc");
$dbConnection = null;
$memberID = null;
$memberBands = null;
$error = false;
$errorCode = 0;
try {
$dbConnection = DatabaseUtilities::getDatabaseConnection();
//Get the current user's ID and details.
$memberID = LoginController::getLoggedInMemberID($dbConnection);
if ($memberID == null) {
header("Location: login.php");
exit;
} else {
$memberDetails = MemberDao::selectMemberDetails($memberID, $dbConnection);
//If member details cannot be obtained, error
if ($memberDetails == null) {
$error = true;
$errorCode = 1;
} else {
require_once $config->getIncludeURL(Config::INCLUDES_PATH, "views%musicians%search_musicians_view.php");
}
}
} catch (Exception $ex) {
$error = true;
$errorCode = 1;
}
$dbConnection = null;
if ($error == true) {
ErrorUtilities::errorRedirect($errorCode);
$errorCode = 0;
try {
$dbConnection = DatabaseUtilities::getDatabaseConnection();
//Get the current user's ID and details.
$memberID = LoginController::getLoggedInMemberID($dbConnection);
if ($memberID == null) {
header("Location: login.php");
exit;
} else {
if (isset($_GET['memberID'])) {
$viewMemberID = $_GET['memberID'];
} else {
$viewMemberID = $memberID;
}
if ($viewMemberID != null) {
$memberDetails = MemberDao::selectMemberDetails($viewMemberID);
//Encrypt the ID so it can be used for submissions.
$memberIDEncrypted = EncryptionUtilities::encryptString($viewMemberID);
if ($memberDetails != null && $memberIDEncrypted != null) {
if ($viewMemberID == $memberID) {
$editable = true;
}
$memberInstruments = MemberInstrumentController::getMemberInstruments($viewMemberID, false, $dbConnection);
$memberPurposes = MemberPurposeDao::selectMemberPurpose($viewMemberID, $dbConnection);
$memberGenres = MemberGenreDao::selectMemberGenres($viewMemberID, $dbConnection);
$processed = true;
} else {
$errorCode = 1;
}
}
}
private function createMemberAccount($memberID, $facebook)
{
$success = false;
try {
$param = array('method' => 'users.getinfo', 'uids' => $memberID, 'fields' => FacebookConstants::FB_FIRST_NAME . ',' . FacebookConstants::FB_LAST_NAME . ',' . FacebookConstants::FB_MUSIC . ',' . FacebookConstants::FB_BIRTHDATE . ',' . FacebookConstants::FB_GENDER . ',' . FacebookConstants::FB_HOMETOWN_LOCATION . ',' . FacebookConstants::FB_CURRENT_LOCATION . ',' . FacebookConstants::FB_PROFILE_PIC, 'callback' => '');
$userDetails = $facebook->api($param);
if ($userDetails != null) {
$countryName = null;
$stateName = null;
$cityName = null;
if ($userDetails[0][FacebookConstants::FB_CURRENT_LOCATION] !== null) {
if (isset($userDetails[FacebookConstants::FB_CURRENT_LOCATION][FacebookConstants::FB_CITY])) {
$cityName = $userDetails[FacebookConstants::FB_CURRENT_LOCATION][FacebookConstants::FB_CITY];
}
if (isset($userDetails[FacebookConstants::FB_CURRENT_LOCATION][FacebookConstants::FB_STATE])) {
$stateName = $userDetails[FacebookConstants::FB_CURRENT_LOCATION][FacebookConstants::FB_STATE];
}
if (isset($userDetails[FacebookConstants::FB_CURRENT_LOCATION][FacebookConstants::FB_COUNTRY])) {
$countryName = $userDetails[FacebookConstants::FB_CURRENT_LOCATION][FacebookConstants::FB_COUNTRY];
}
}
if ($userDetails[0][FacebookConstants::FB_HOMETOWN_LOCATION] !== null) {
if ($cityName == null) {
$cityName = $userDetails[0][FacebookConstants::FB_HOMETOWN_LOCATION][FacebookConstants::FB_CITY];
}
if ($stateName == null) {
$stateName = $userDetails[0][FacebookConstants::FB_HOMETOWN_LOCATION][FacebookConstants::FB_STATE];
}
if ($countryName == null) {
$countryName = $userDetails[0][FacebookConstants::FB_HOMETOWN_LOCATION][FacebookConstants::FB_COUNTRY];
}
}
$countryID = LocationUtilities::getCountryID($countryName);
$stateID = LocationUtilities::getStateID($countryID, $stateName);
$cityID = LocationUtilities::getCityID($countryID, $stateID, $cityName);
$regionID = 0;
$memberDetails = new Member();
$memberDetails->setVariable(Member::MEMBER_ID, $memberID);
$memberDetails->setVariable(LocationConstants::COUNTRY_ID, $countryID);
$memberDetails->setVariable(LocationConstants::STATE_ID, $stateID);
$memberDetails->setVariable(LocationConstants::CITY_ID, $cityID);
$memberDetails->setVariable(LocationConstants::REGION_ID, $regionID);
$memberDetails->setVariable(Member::AGE_RANGE_ID, AgeUtilities::getAgeRangeID($userDetails[0][FacebookConstants::FB_BIRTHDATE]));
$memberDetails->setVariable(Member::GENDER_ID, AgeUtilities::getAgeRangeID($userDetails[0][FacebookConstants::FB_GENDER]));
$memberDetails->setVariable(Member::FIRST_NAME, $userDetails[0][FacebookConstants::FB_FIRST_NAME]);
$memberDetails->setVariable(Member::LAST_NAME, $userDetails[0][FacebookConstants::FB_LAST_NAME]);
$memberDetails->setVariable(Member::MUSIC, $userDetails[0][FacebookConstants::FB_MUSIC]);
// $memberDetails->setVariable(Member::EMAIL, $userDetails[0][FacebookConstants::FB_EMAIL]);
$memberDetails->setVariable(Member::PROFILE_PIC, $userDetails[0][FacebookConstants::FB_PROFILE_PIC]);
$success = MemberDao::insertMember($memberDetails, $dbConnection);
}
} catch (Exception $ex) {
$success = false;
}
return $success;
}
public function getMemberDetails($memberID, $dbConnection)
{
$memberDetails = null;
try {
$memberDetails = MemberDao::selectMemberDetails($memberID, $dbConnection);
} catch (Exception $ex) {
$memberDetails = null;
echo 'Caught exception: ', $ex->getMessage(), "\n";
}
return $memberDetails;
}
<?php
$errors = array();
$member = null;
// set defaults
$member = new Member();
//Breaking dry principle, but can be fixed
//netbeans wouldnt work until I added the backslash, not 100% if correct
if (array_key_exists('sign_up', $_POST)) {
$data = array('username' => filter_var($_POST['member']['username'], FILTER_SANITIZE_STRING), 'password' => filter_var($_POST['member']['password'], FILTER_SANITIZE_STRING), 'first_name' => filter_var($_POST['member']['first_name'], FILTER_SANITIZE_STRING), 'last_name' => filter_var($_POST['member']['last_name'], FILTER_SANITIZE_STRING), 'email' => filter_var($_POST['member']['email'], FILTER_SANITIZE_EMAIL));
// map
MemberMapper::map($member, $data);
// validate
// save
$dao = new MemberDao();
$member = $dao->save($member);
// put new user in session
$username = filter_var($_POST['member']['username'], FILTER_SANITIZE_STRING);
$password = filter_var($_POST['member']['password'], FILTER_SANITIZE_STRING);
$user = $dao->findByUsername($username, $password);
$_SESSION['username'] = $user->getUsername();
$_SESSION['user_id'] = $user->getUser_id();
Flash::addFlash('You can now share your thoughts on different items and will recieve our monthly heads up. Awesome!');
// redirect
Utils::redirect('home');
}
<?php
$error = '';
//check if login is valid
//redirect to index if valid
if (isset($_POST['login'])) {
$username = filter_var($_POST['username'], FILTER_SANITIZE_STRING);
$password = filter_var($_POST['password'], FILTER_SANITIZE_STRING);
$dao = new MemberDao();
$user = $dao->findByUsername($username, $password);
if (!$user) {
$error = 'Username or password is incorrect';
} elseif ($user->getUsername() === $username || $user->getPassword() === $password) {
$_SESSION['username'] = $user->getUsername();
$_SESSION['user_id'] = $user->getUser_id();
if ($user->getRole() !== null) {
$_SESSION['role'] = $user->getRole();
}
Utils::redirect('home');
}
}
//logout
if (isset($_GET['logout'])) {
logout();
}
function logout()
{
session_start();
session_destroy();
header('location: index.php');
exit;
public function updateMember($memberDetails, $dbConnection = null)
{
$preparedStatement = null;
$processed = false;
try {
if ($memberDetails->getVariable(Member::MEMBER_ID) !== null) {
if ($dbConnection == null) {
$dbConnection = DatabaseUtilities::getDatabaseConnection();
}
$memberUpdateQuery = MemberDao::getMemberUpdateQuery($memberDetails);
$preparedStatement = MemberDao::getMemberUpdatePreparedStatement($memberUpdateQuery, $memberDetails, $dbConnection);
if ($preparedStatement->execute()) {
$processed = true;
}
$preparedStatement = null;
}
} catch (Exception $ex) {
echo 'Caught exception: ' . $ex->getMessage() . "\n";
$processed = false;
}
return $processed;
}
