public function update(){ $query = "UPDATE TYPE_EVALUATION SET ". "libelleEvaluation = '".db_connect::escape_string($this->getLibelleTypeEvaluation())."'". "WHERE idTypeEvaluation = ".$this->getIdTypeEvaluation(); if (db_connect::query($query)) return true; return false; }
public function update() { $query = "UPDATE UTILISATEUR SET " . " nomUtilisateur = '" . db_connect::escape_string(trim($this->getNomUtilisateur())) . "', " . " prenomUtilisateur = '" . db_connect::escape_string(trim($this->getPrenomUtilisateur())) . "', " . " adr1Utilisateur = '" . db_connect::escape_string(trim($this->getAdr1Utilisateur())) . "', " . " adr2Utilisateur = '" . db_connect::escape_string(trim($this->getAdr2Utilisateur())) . "', " . " cpUtilisateur = '" . db_connect::escape_string(trim($this->getCpUtilisateur())) . "', " . " villeUtilisateur = '" . db_connect::escape_string(trim($this->getVilleUtilisateur())) . "', " . " actifUtilisateur = " . ($this->getActifUtilisateur() ? 'true' : 'false') . ", " . " mailUtilisateur = '" . db_connect::escape_string(trim($this->getMailUtilisateur())) . "', " . " dateNaissanceUtilisateur = '" . db_connect::escape_string(trim($this->getDateNaissanceUtilisateur())) . "', " . " dateInscriptionUtilisateur = '" . db_connect::escape_string(trim($this->getDateInscriptionUtilisateur())) . "'" . " WHERE idUtilisateur = " . $this->getIdUtilisateur(); if (db_connect::query($query)) { $connexion = Connexion::getById($this->getIdUtilisateur()); if (empty($connexion->getIdUtilisateur())) $connexion->setIdUtilisateur($this->getIdUtilisateur()); $connexion->setLoginUtilisateur($this->getNomUtilisateur() . '.' . $this->getPrenomUtilisateur()); if (empty($connexion->getMdpUtilisateur())) $connexion->setMdpUtilisateur('123Soleil'); return $connexion->update(); } return FALSE; }
public function update(){ $query = "UPDATE TRIMESTRE SET ". "libelleTrimestre = '".db_connect::escape_string($this->getLibelleTrimestre())."', ". "dateDebutTrimestre = '".$this->SQLdateDebutTrimestre()."', ". "dateFinTrimestre = '".$this->SQLdateFinTrimestre()."', ". "dateFinCommentaire = '".$this->SQLdateFinCommentaire()."'". "WHERE idTrimestre = ".$this->getIdTrimestre(); if (db_connect::query($query)) return true; return false; }
public static function connecter($login, $mdp) { $connexion = new Connexion(); $connexion->setLoginUtilisateur($login); $connexion->setMdpUtilisateur($mdp); $query = " SELECT c.* FROM CONNEXION c, UTILISATEUR u " . " WHERE c.loginUtilisateur = '" . db_connect::escape_string($connexion->getLoginUtilisateur()) . "' " . " AND c.mdpUtilisateur = '" . $connexion->getMdpUtilisateur() . "' " . " AND c.idUtilisateur = u.idUtilisateur " . " AND u.actifUtilisateur = 1 "; $result = db_connect::query($query); if ($result->num_rows != 1) { return new connexion; } else { return $result->fetch_object('Connexion'); } }
public function insert(){ $query = "INSERT INTO ABSENCE (idEleve, dateDebutAbsence, dateFinAbsence, etatAbsence, motifAbsence, dateRedaction, idRedacteur) VALUES (". $this->getIdEleve().", '".$this->getDateDebutAbsence()."', '".$this->getDateFinAbsence()."', ". ($this->getEtatAbsence()?'TRUE':'FALSE').", '".db_connect::escape_string($this->getMotifAbsence())."', '".$this->getDateRedaction()."', ".$this->getIdRedacteur(). ")"; if( db_connect::query($query)){ $query2 = "SELECT * FROM ABSENCE WHERE idEleve = ".$this->getIdEleve()." AND dateDebutAbsence = '".$this->getDateDebutAbsence()."' AND dateFinAbsence = '".$this->getDateFinAbsence()."' ". "AND etatAbsence = ". ($this->getEtatAbsence()?'TRUE':'FALSE')." and motifAbsence = '".db_connect::escape_string($this->getMotifAbsence())."' AND dateRedaction = '".$this->getDateRedaction()."' AND idRedacteur = ".$this->getIdRedacteur(); $result = db_connect::query($query2); if ($result->num_rows == 1){ $return = $result->fetch_object('Absence'); $this->setIdAbsence($return->getIdAbsence()); return true; } return false; } return false; }
public function update() { $query = "UPDATE NIVEAU_CPT SET libelleNiveauCpt = '" . db_connect::escape_string($this->getLibelleNiveauCpt()) . "', codeNiveauCpt = '" . db_connect::escape_string($this->getCodeNiveauCpt()) . "' WHERE idNiveauCpt = " . $this->getIdNiveauCpt(); if (db_connect::query($query)) return TRUE; return FALSE; }
if (isset($_POST['noter'])){ if (isset($_POST['selectEval']) && !empty($_POST['selectEval'])) header('location: ../Intranet/affectNote.php?idEval='.$_POST['selectEval']); } if (isset($_POST['btAjouter'])) { $evaluation = new Evaluation(); $evaluation->setDateEvaluation($_POST['addDate']); $evaluation->setIdMatiereNiveau(MatiereNiveau::getByMatiereNiveau($_POST['addMatiere'], $_POST['addNiveau'])->getIdMatiereNiveau()); $evaluation->setIdTypeEvaluation($_POST['addType']); $evaluation->setTitreEvaluation(db_connect::escape_string($_POST['addTitre'])); // echo $evaluation->getTitreEvaluation(); $evaluation->setMaxEvaluation($_POST['addMax']); if ($evaluation->getIdTypeEvaluation() == 3) $evaluation->setAutreEvaluation(db_connect::escape_string($_POST['autreEval'])); if ($evaluation->insert()){ $msgInsert = "<h4 style='color: green'> L'ajout de l'évaluation a réussi. </h4>"; } else{ $msgInsert = "<h4 style='color: red'> L'ajout de l'évaluation a échoué. </h4>"; } // tansfert du fichier Sujet associ�. if (!empty($_FILES['fichierSujet'])) { if (ftp_link::estPDFfile($_FILES['fichierSujet']['name'], $_FILES['fichierSujet']['type'])) {
public function update(){ $query = "UPDATE MODULE SET libelleModule = '".db_connect::escape_string($this->getLibelleModule())."' WHERE idModule = ".$this->getIdModule(); if (db_connect::query($query)) return true; return false; }
public function insert(){ $query = "INSERT INTO COMMUNICATION (". "contenuCommunication, idRedacteur, dateRedaction" .") VALUES (". "'".db_connect::escape_string($this->getContenuCommunication())."', ". $this->getIdRedacteur().", ". "'".$this->getDateRedaction()."'" .")"; if (db_connect::query($query)){ $query2 = "SELECT idCommunication FROM COMMUNICATION WHERE ". "contenuCommunication = '".db_connect::escape_string($this->getContenuCommunication())."' AND ". "idRedacteur = ".$this->getIdRedacteur()." AND ". "dateRedaction = '".$this->getDateRedaction()."'"; $result = db_connect::query($query2); if ($result->num_rows == 1){ $info = $result->fetch_assoc(); $this->setIdCommunication($info['idCommunication']); $result->close(); return true; } } //db_connect::getInstance()->rollback(); return false; }
public function update(){ $query = "UPDATE CAHIER_TEXTE SET ". "idMatiereNiveau = ".$this->getIdMatiereNiveau()." , ". "idRedacteur = ".$this->idRedacteur." , ". "dateRedaction = '".$this->SQLdateRedaction()."' , ". "dateRealisation = '".$this->SQLdateRealisation()."' , ". "contenuCahierTexte = '".db_connect::escape_string($this->getContenuCahierTexte())."' ". "WHERE idCahierTexte = ".$this->getIdCahierTexte(); if (db_connect::query($query)) return true; return false; }
public function update(){ $query = "UPDATE CARNET_LIAISON SET ". "contenuCarnetLiaison = '".db_connect::escape_string($this->getContenuCarnetLiaison())."', ". "idReponse = ".($this->getIdReponse()?$this->getIdReponse():'NULL').", ". "idRedacteur = ".$this->getIdRedacteur().", ". "dateRedaction = '".$this->sqlDateRedaction()."', ". "idEleve = ".$this->getIdEleve(). "WHERE idCarnetLiaison = ".$this->getIdCarnetLiaison(); if (db_connect::query($query)) return true; return false; }
public function update () { $query = "UPDATE MATIERE SET " . "libelleMatiere = '" . db_connect::escape_string($this->getLibelleMatiere()) . "' WHERE idMatiere = " . $this->getIdMatiere(); if (db_connect::query($query)) return true; return false; }
public function update(){ $query = "UPDATE DOMAINE_CPT SET ". "libelleDomaineCpt = '".db_connect::escape_string($this->getLibelleDomaineCpt())."', ". "idMatiere = ".$this->getIdMatiere(). "WHERE idDomaineCpt = ".$this->getIdDomaineCpt(); if (db_connect::query($query)) return true; return false; }
public function delete(){ $query = "DELETE FROM PLAN_TRAVAIL WHERE idPlanTravail = ".db_connect::escape_string($this->getIdPlanTravail()); if (db_connect::query($query)) return true; return false; }
public function update() { $query = "UPDATE POINT_CPT SET " . "libellePointCpt = '" . db_connect::escape_string($this->getLibellePointCpt()) . "', " . "idDomaineCpt = " . $this->getIdDomaineCpt() . " " . "WHERE idPointCpt = " . $this->getIdPointCpt(); if (db_connect::query($query)) return TRUE; return FALSE; }
public function update(){ $query = "UPDATE PERIODE SET ". "libellePeriode = '".db_connect::escape_string($this->getLibellePeriode())."', ". "dateDebutPeriode = '".$this->SQLdateDebutperiode()."', ". "dateFinPeriode = '".$this->SQLdateFinPeriode()."', ". "idTrimestre = ".$this->getIdTrimestre()." ". "WHERE idPeriode = ".$this->getIdPeriode(); if (db_connect::query($query)) return true; return false; }
public function update(){ $query = " UPDATE BULLETIN SET dateRedaction = '".$this->getDateRedacton()."', contenuBulletin = '".db_connect::escape_string($this->getContenuBulletin())."', idEleve = ".$this->getIdEleve().", idMatiereNiveau = ".$this->getIdMatiereNiveau()." WHERE idBulletin = ".$this->getIdBulletin(); if (db_connect::query($query)){ return true; } return false; }
public function update () { $query = "UPDATE EVALUATION SET " . "idTypeEvaluation = " . $this->getIdTypeEvaluation() . ", " . "idMatiereNiveau = " . $this->getIdMatiereNiveau() . ", " . "dateEvaluation = '" . $this->sqlDateEvaluation() . "', " . "titreEvaluation = '" . db_connect::escape_string($this->getTitreEvaluation()) . "', " . "autreEvaluation = " . (empty($this->getAutreEvaluation()) ? 'NULL' : "'".db_connect::escape_string($this->getAutreEvaluation())."'") . ", " . "maxEvaluation = " . $this->getMaxEvaluation() . " " . "WHERE idEvaluation = " . $this->getIdEvaluation(); if (db_connect::query($query)) return true; return false; }
public function update() { $query = "UPDATE ELEVE SET idNiveau = " . db_connect::escape_string(trim($this->getIdNiveau())) . " WHERE idEleve = " . $this->getIdEleve(); return db_connect::query($query); }
public function update(){ $query = "UPDATE NIVEAU SET ". "libelleNiveau = '".db_connect::escape_string($this->getLibelleNiveau())."', ". "idModule = ".$this->getIdModule(). "WHERE idNiveau = ".$this->getIdNiveau(); if (db_connect::query($query)) return true; return false; }