/** * Fügt einen neuen User der Person hinzu. * @param string $username * @param string $password * @param string $surname * @param string $name * @param string $mail * @return array|false|null */ public function insert(string $username, string $password, string $surname, string $name, string $mail) { $loginModel = new LoginModel(); $user = $loginModel->load($username); //User already exists if ($user != null) { return false; } $connection = Database::getConnection(); $hashedPassword = password_hash($password, PASSWORD_BCRYPT); $query = "INSERT INTO person(username, password, surname, name, mail) VALUES(?, ?, ?, ?, ?); SELECT SCOPE_IDENTITY() as ID;"; //Execute Query $stmt = sqlsrv_query($connection, $query, array($username, $hashedPassword, $surname, $name, $mail)); if (sqlsrv_errors()) { http_response_code(500); } //Select next Result (SCOPE_IDENTITY) sqlsrv_next_result($stmt); $res = sqlsrv_fetch_array($stmt); //Load inserted Row $query = 'SELECT * FROM person WHERE id_person = ' . $res['ID']; $stmt = sqlsrv_query($connection, $query); return sqlsrv_fetch_array($stmt); }