| @@ 67-77 (lines=11) @@ | ||
| 64 | return $this->checkAndGetNote((int) $this->database->lastInsertId()); |
|
| 65 | } |
|
| 66 | ||
| 67 | public function updateNote($note) |
|
| 68 | { |
|
| 69 | $query = 'UPDATE `notes` SET `name` = :name, `description` = :description WHERE `id` = :id'; |
|
| 70 | $statement = $this->database->prepare($query); |
|
| 71 | $statement->bindParam(':id', $note->id); |
|
| 72 | $statement->bindParam(':name', $note->name); |
|
| 73 | $statement->bindParam(':description', $note->description); |
|
| 74 | $statement->execute(); |
|
| 75 | ||
| 76 | return $this->checkAndGetNote((int) $note->id); |
|
| 77 | } |
|
| 78 | ||
| 79 | public function deleteNote(int $noteId) |
|
| 80 | { |
|
| @@ 81-91 (lines=11) @@ | ||
| 78 | return $user; |
|
| 79 | } |
|
| 80 | ||
| 81 | public function create($user) |
|
| 82 | { |
|
| 83 | $query = 'INSERT INTO `users` (`name`, `email`, `password`) VALUES (:name, :email, :password)'; |
|
| 84 | $statement = $this->database->prepare($query); |
|
| 85 | $statement->bindParam('name', $user->name); |
|
| 86 | $statement->bindParam('email', $user->email); |
|
| 87 | $statement->bindParam('password', $user->password); |
|
| 88 | $statement->execute(); |
|
| 89 | ||
| 90 | return $this->getUser((int) $this->database->lastInsertId()); |
|
| 91 | } |
|
| 92 | ||
| 93 | public function update($user) |
|
| 94 | { |
|
| @@ 93-103 (lines=11) @@ | ||
| 90 | return $this->getUser((int) $this->database->lastInsertId()); |
|
| 91 | } |
|
| 92 | ||
| 93 | public function update($user) |
|
| 94 | { |
|
| 95 | $query = 'UPDATE `users` SET `name` = :name, `email` = :email WHERE `id` = :id'; |
|
| 96 | $statement = $this->database->prepare($query); |
|
| 97 | $statement->bindParam('id', $user->id); |
|
| 98 | $statement->bindParam('name', $user->name); |
|
| 99 | $statement->bindParam('email', $user->email); |
|
| 100 | $statement->execute(); |
|
| 101 | ||
| 102 | return $this->getUser((int) $user->id); |
|
| 103 | } |
|
| 104 | ||
| 105 | public function delete(int $userId): string |
|
| 106 | { |
|