/** * Met a jour la base de données * @param DevoirsModel $d * @return boolean */ public static function update(DevoirsModel $d) { $db = DB::Connect(); $query = $db->prepare("UPDATE " . self::TABLE . " SET " . self::NOM_COL . " = :name," . self::GROUPE_COL . " = :groupe," . " WHERE " . self::ID_COL . " = :id"); try { $query->bindValue(":id", $d->getId(), PDO::PARAM_INT); $query->bindValue(":name", $d->getName(), PDO::PARAM_STR); $query->bindValue(":groupe", $d->enGroupe(), PDO::PARAM_BOOL); $db->beginTransaction(); $query->execute(); $db->commit(); } catch (PDOException $e) { $db->rollback(); DB::setError($e->getMessage()); return false; } return self::findById($d->getId()); }