adding the collection for the security questions for a user

1 files changed, 24 insertions, 0 deletions

diff --git a/src/Psecio/Gatekeeper/SecurityQuestionCollection.php b/src/Psecio/Gatekeeper/SecurityQuestionCollection.php
new file mode 100644
index 0000000..b424236
--- /dev/null
+++ b/src/Psecio/Gatekeeper/SecurityQuestionCollection.php
@@ -0,0 +1,24 @@
+<?php
+
+namespace Psecio\Gatekeeper;
+
+class SecurityQuestionCollection extends \Psecio\Gatekeeper\Collection\Mysql
+{
+	/**
+	 * Find the security questions for the given user ID
+	 *
+	 * @param integer $userId User ID
+	 */
+	public function findByUserId($userId)
+	{
+		$data = array('userId' => $userId);
+		$sql = 'select * from security_questions where user_id = :userId';
+
+		$results = $this->getDb()->fetch($sql, $data);
+
+        foreach ($results as $result) {
+            $question = new SecurityQuestionModel($this->getDb(), $result);
+            $this->add($question);
+        }
+	}
+}
\ No newline at end of file