function security_questions_question_load_multiple in Security Questions 7.2
Same name and namespace in other branches
- 6.2 security_questions.module \security_questions_question_load_multiple()
Fetch multiple questions from the database.
Parameters
$conditions: (optional) An array of query conditions as field => value pairs. If omitted, all questions in the database will be returned.
$any: (optional) By default, the result set includes only questions that match all of the $conditions. If this parameter is set to TRUE, the result set will instead include questions that match any of the $conditions.
Return value
An empty array if no questions match the conditions; otherwise, an array of question objects indexed by sqid.
3 calls to security_questions_question_load_multiple()
- security_questions_get_question_list in ./
security_questions.module - Fetch a user's available questions from the database.
- security_questions_list_form in ./
security_questions.admin.inc - Questions list page with add form.
- security_questions_question_load in ./
security_questions.module - Fetch a specific question from the database.
File
- ./
security_questions.module, line 775 - Main module file for security_questions.
Code
function security_questions_question_load_multiple($conditions = array(), $any = FALSE) {
$select = db_select('security_questions', 'q');
$select
->fields('q');
if (!empty($conditions)) {
$clause = $any ? db_or() : db_and();
foreach ($conditions as $field => $value) {
$clause
->condition($field, $value);
}
$select
->condition($clause);
}
return $select
->execute()
->fetchAllAssoc('sqid');
}