/** * Retrieves the message corresponding to a give id. * * @param {integer/string} id The message code. * @return {string} The message corresponding to the provided * id if it exists, "Message: <id>" otherwise. */ public function getMessage($id) { parent::verifyTypes($id, array("integer", "string")); $id = intval($id); $table = DataAccessConfig::messageData(); $values = array($table->messageText); $target = array($table->messageId => $id); $result = $this->selectRows($table->tableName, $values, $target); if (count($result) != 1) { return "Message ID: " . $id; } return $result[0][$table->messageText]; }
public static function mapResult($result) { $config = DataAccessConfig::userData(); $userId = (int) $result[$config->id]; $email = $result[$config->email]; $pin = $result[$config->pin]; $name = $result[$config->name]; $birthday = new DateTime($result[$config->birthday]); $user = new User($email, $pin); $user->setUserId($userId); $user->setPin($pin); $user->setName($name); $user->setBirthday($birthday); return $user; }
private function usernameExists($email) { parent::verifyType($email, "string"); $table = DataAccessConfig::userData(); $values = array($table->userId); $target = array($table->email => "'" . $email . "'"); $result = $this->selectRows($table->tableName, $values, $target); return count($result) == 1; }
public static function joinTables($table1, $table2, $table3, $joinCondition1, $joinCondition2) { $join = DataAccessConfig::joinTable($table1, $table2, $joinCondition1); return DataAccessConfig::joinTable($join, $table3, $joinCondition2); }