function security_questions_answer_save in Security Questions 6.2

Same name and namespace in other branches

1. 7.2 security_questions.module \security_questions_answer_save()

Saves a user's answer to the database.

Parameters

$uid: The user's ID.

$sqid: The security question ID.

$answer: The answer text.

1 call to security_questions_answer_save()

security_questions_user_answers_save in ./security_questions.module

Saves a full set of answers and custom questions for a user.

File

./security_questions.module, line 714

Main module file for security_questions.

Code

function security_questions_answer_save($uid, $sqid, $answer) {
  $existing = security_questions_get_answer_list($uid, $sqid);
  if (empty($existing)) {
    $query = "INSERT INTO {security_questions_answers} (answer, uid, sqid) VALUES ('%s', %d, %d)";
  }
  else {
    $query = "UPDATE {security_questions_answers} SET answer = '%s' WHERE uid = %d AND sqid = %d";
  }
  db_query($query, array(
    $answer,
    $uid,
    $sqid,
  ));
}