示例#1
0
 /**
  * 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());
 }