public function editUser(User $user) { $db = Database::getInstance('app'); $result = $db->prepare("UPDATE users SET password = ?, username = ? WHERE id = ?"); $result->execute([$user->getPass(), $user->getUsername(), $user->getId()]); return $result->rowCount() > 0; }
private static function insert(User $model) { $db = Database::getInstance('app'); $query = "INSERT INTO users (username,password,gold,food,grass) VALUES (:username, :password, :gold, :food, :grass);"; $result = $db->prepare($query); $result->execute([':username' => $model->getUsername(), ':password' => $model->getPassword(), ':gold' => $model->getGold(), ':food' => $model->getFood(), ':grass' => $model->getGrass()]); $model->setId($db->lastId()); }