public function add(User $user) { // If Empty user submit throw Exception. if ($getUser = $this->getUserByUsername($user->GetUsername())) { throw new DbUserExistException(); } try { $db = $this->connection(); $sql = "INSERT INTO " . self::$dbTable . " (" . self::$userName . ", " . self::$password . ") VALUES (?, ?)"; $params = array($user->GetUsername(), $user->GetPassword()); $query = $db->prepare($sql); $query->execute($params); } catch (\PDOException $e) { throw new \Exception(); } }
public function Add(\model\User $user) { if ($this->GetRegistrationsForHour() > self::$MAX_REGISTRATIONS_PER_HOUR) { throw new \Exception("Max number of registrations per hour reached. Please try again in 30-60 minutes."); } // Throw exception if username is taken if ($this->GetUserByUsername($user->GetUserName())) { throw new \Exception(self::$DB_USERNAME_EXISTS); } try { // Prepare db statement $statement = self::$db->prepare('INSERT INTO ' . self::$DB_TABLE_NAME . '(user_id, user_name, user_password, date_time)' . ' VALUES ' . '(NULL, :userName, :password, NOW())'); // Prepare input array $inputArray = ['userName' => $user->GetUserName(), 'password' => $user->GetPassword()]; // Execute db statement $statement->execute($inputArray); // Check if db insertion was successful return $statement->rowCount() == 1; } catch (\Exception $exception) { throw new \Exception(self::$DB_INSERT_ERROR); } }