public function update(DomainObject $page) { $id = $page->getId(); $title = $page->getTitle(); $content = $page->getContent(); $sql = 'UPDATE page SET title = ?, content = ? WHERE id = ?'; $this->database->connect(); $this->database->query($sql)->execute(array($title, $content, $id)); $this->database->close(); }
public function find(DomainObject $user) { $id = $user->getId(); $username = $user->getUsername(); $sql = 'SELECT id, username, password FROM user'; if ($id) { $sql .= ' WHERE id = ?'; $parameters = array($id); } else { if ($username) { $sql .= ' WHERE username = ?'; $parameters = array($username); } } $this->database->connect(); $this->database->query($sql)->execute($parameters, PDO::FETCH_INTO, $user)->fetch(); $this->database->close(); }