public static function setMarkOnFilm($idFilm, $login, $mark) { if (Etoile::notRankedByUser($idFilm, $login)) { $res = SingletonRequete::getBase()->requeteParam("INSERT INTO Mark(mov_id, user_login, mark_value) VALUES (?,?,?)", array($idFilm, $login, $mark)); } else { $res = SingletonRequete::getBase()->requeteParam("UPDATE Mark SET mark_value=? WHERE mov_id=? AND user_login=?", array($mark, $idFilm, $login)); } }
public static function supprimerUtilisateur($login) { SingletonRequete::getBase()->requeteParam("DELETE FROM User WHERE user_login=?", array($login)); }
public static function setDefaultCategorie($nomCat, $id) { $t = SingletonRequete::getBase()->requeteParam("UPDATE Movie SET mov_category=? WHERE mov_id=?", array($nomCat, $id)); }
public static function modifierCategorie($nouv, $ancien) { SingletonRequete::getBase()->requeteParam("UPDATE Category SET category_name=? WHERE category_name=?", array($nouv, $ancien)); }
private function __construct() { if (self::$bd == NULL) { self::$bd = new Base(); } }