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 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;
}