public function insertIntoUserInfo($objUserInfo) { $objResult = new Result(); $query = "INSERT INTO user_info(user_info_id, user_id, name, location, sex, age, contact) values(:USER_INFO_ID, :USER_ID, :NAME, :LOCATION, :SEX, :AGE, :CONTACT)"; try { $dbconn = $this->getConnection(); $stmt = $dbconn->prepare($query); $stmt->bindValue(':USER_INFO_ID', ''); $stmt->bindValue(':USER_ID', $objUserInfo->getUserId()); $stmt->bindValue(':NAME', $objUserInfo->getName()); $stmt->bindValue(':LOCATION', $objUserInfo->getLocation()); $stmt->bindValue(':SEX', $objUserInfo->getSex()); $stmt->bindValue(':AGE', $objUserInfo->getAge()); $stmt->bindValue(':CONTACT', $objUserInfo->getContact()); $stmt->execute(); $insertId = $dbconn->lastInsertId(); if ($insertId) { $objResult->setResultType(Result::SUCCESS); $objResult->setResponse($insertId); } else { $objResult->setResultType(Result::FAILURE); } } catch (Exception $ex) { $this->throwPDOException($ex); } return $objResult; }
public function displayLoggedInContent($arrParams) { $objResult = new Result(); $fullName = $this->objUserCredentialsManager->getFullNameByUserId($arrParams[Constants::USER_ID]); $name = explode(" ", $fullName); if (count($name) == 0) { $name[0] = Constants::USER; } $content = $this->templater->render("AppBundle::homepage.html.tpl", array("loggedIn" => "yes", "tag" => "home", "name" => $name[0])); $objResult->setResponse($content); return $objResult; }
public function saveUserCredentials($objUserDetails) { $objResult = new Result(); try { $conn = $this->getConnection(); $saveQuery = "INSERT INTO user_login(user_id, email, password) VALUES (:USER_ID, :EMAIL, :PASSWORD)"; $q = $conn->prepare($saveQuery); $q->bindParam(":USER_ID", $objUserDetails->getUserId()); $q->bindParam(":EMAIL", $objUserDetails->getEmail()); $q->bindParam(":PASSWORD", $objUserDetails->getPassword()); $q->execute(); $insertId = $conn->lastInsertId(); if ($insertId) { $objResult->setResponse($insertId); $objResult->setResultType(Result::SUCCESS); } else { $objResult->setResultType(Result::FAILURE); } } catch (PDOException $e) { echo 'exception ' . $e->getMessage(); die; } return $objResult; }