Example #1
0
 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());
 }