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 delete(){ $query = "DELETE FROM ELEVE_RESPONSABLE WHERE ". "idEleve = ".$this->getIdEleve()." AND ". "idResponsable = ".$this->getIdResponsable(); if (db_connect::query($query)) return true; return false; }
public function delete(){ $query = "DELETE FROM EVALUATION_POINT_CPT WHERE idEvaluationPointCpt = ".$this->getIdEvaluationPointCpt(); if (db_connect::query($query)) return true; return false; }
public function delete(){ $query = "DELETE FROM MATIERE_NIVEAU WHERE idMatiereNiveau = ".$this->getIdMatiereNiveau(); if (db_connect::query($query)) return true; return false; }
public static function getAll() { $query = " SELECT c.* FROM CONNEXION c, UTILISATEUR u WHERE c.idUtilisateur = u.idUtilisateur AND u.actifUtilisateur = 1 ORDER BY loginUtilisateur ASC"; $result = db_connect::query($query); $return = array(); while ($info = $result->fetch_object('Connexion')) { $return[] = $info; } $result->close(); return $return; //return $result->fetch_all(); }
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 delete(){ $query = "DELETE FROM COMMUNICATION WHERE idCommunication = ".$this->idCommunication; if (db_connect::query($query)) return true; }
public function delete() { $query = "DELETE FROM NIVEAU_CPT WHERE idNiveauCpt = " . $this->getIdNiveauCpt(); if (db_connect::query($query)) return TRUE; return FALSE; }
public function delete(){ $query = "DELETE FROM CARNET_LIAISON WHERE idCarnetLiaison = ".$this->getIdCarnetLiaison(); if (db_connect::query($query)) return true; return false; }
public function delete(){ $query = "DELETE FROM MODULE WHERE idModule = ".$this->getIdModule(); if (db_connect::query($query)) return true; return false; }
<?php require_once "db_conect.php"; /** * Created by PhpStorm. * User: chuli * Date: 22/10/2015 * Time: 7:13 SA */ $task = $_POST["task"]; $id = $_POST["id"]; $hoten = $_POST["hoTen"]; $diaChi = $_POST["diaChi"]; $SDT = $_POST["SDT"]; $CMTND = $_POST["CMTND"]; $ghiChu = $_POST["ghiChu"]; $connect = new db_connect(); if ($task == "add") { $sql = "INSERT INTO `quanlykhachsan`.`tblkhachhang` (`id`, `hoTen`, `diaChi`, `SDT`, `CMTND`, `ghiChu`) VALUES (NULL,' " . $hoten . " ', ' " . $diaChi . " ','" . $SDT . "','" . $CMTND . "','" . $ghiChu . "');"; } if ($task == "edit") { $sql = "INSERT INTO `quanlykhachsan`.`tblkhachhang` (`id`, `hoTen`, `diaChi`, `SDT`, `CMTND`, `ghiChu`) VALUES (NULL,' " . $hoten . " ', ' " . $diaChi . " ','" . $SDT . "','" . $CMTND . "','" . $ghiChu . "');"; } if ($task == "trash") { $sql = "DELETE FROM `quanlykhachsan`.`tblkhachhang` WHERE id =" . $id; } $connect->query($sql); header("location: http://localhost/Quanlykhachsan");
public function delete(){ $query = "DELETE FROM CAHIER_TEXTE WHERE idCahierTexte = ".$this->getIdCahierTexte(); if (db_connect::query($query)) return true; return false; }
public function delete(){ $query = "DELETE FROM DOMAINE_CPT WHERE idDomaineCpt = ".$this->getIdDomaineCpt(); if (db_connect::query($query)) return true; return false; }
<?php /** * Created by PhpStorm. * User: Jean-Baptiste * Date: 26/10/2015 * Time: 21:31 */ require_once('../Require/Objects.php'); $query = " select idEleve, mn.idMatiereNiveau from ELEVE e, MATIERE_NIVEAU mn WHERE e.idNiveau = mn.idMatiere ORDER BY idMatiereNiveau asc"; $result = db_connect::query($query); $return = array(); while ($info = $result->fetch_object('EleveMatiereNiveau')){ echo '<pre>'; var_dump($info); echo '</pre>'; $info->insert(); } $result->close(); db_connect::close();
public function delete() { $query = "DELETE FROM POINT_CPT_ELEVE WHERE idPointCpt = " . $this->getIdPointCpt() . " AND idEleve = " . $this->getIdEleve() . " AND idTrimestre = " . $this->getIdTrimestre(); if (db_connect::query($query)) return true; return false; }
public function insertOnly(){ $query = "INSERT INTO PROFESSEUR (idProfesseur) VALUES (". $this->getIdProfesseur(). ")"; return db_connect::query($query); }
public function insertOnly() { $query = "INSERT INTO ADMINISTRATION (idAdministration) VALUES (" . $this->getIdAdministrateur() . ")"; return db_connect::query($query); }
public function delete(){ $query = "DELETE FROM ABSENCE WHERE idAbsence = ".$this->getIdAbsence(); return db_connect::query($query); }
public function delete(){ $query = "DELETE FROM PERIODE WHERE idPeriode = ".$this->getIdPeriode(); if (db_connect::query($query)) return true; return false; }
public function delete(){ $query = "DELETE FROM TRIMESTRE WHERE idTrimestre = ".$this->getIdTrimestre(); if (db_connect::query($query)) return true; return false; }
public function delete () { $query = "DELETE FROM EVALUATION WHERE idEvaluation = " . $this->getIdEvaluation(); if (db_connect::query($query)) return true; return false; }
public function delete() { $query = "DELETE FROM POINT_CPT WHERE idPointCpt = " . $this->getIdPointCpt(); if (db_connect::query($query)) return TRUE; return FALSE; }
public function delete(){ $query = "DELETE FROM EMPLOI_TEMPS WHERE idEdT = ".$this->getIdEdT(); 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 insertOnly(){ $query = "INSERT INTO RESPONSABLE (idResponsable) VALUES (". $this->getIdResponsable() .")"; return db_connect::query($query); }
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 delete(){ $query = "DELETE FROM NOTE WHERE idEleve = ".$this->getIdEleve()." AND idEvaluation = ".$this->getIdEvaluation(); if (db_connect::query($query)) return true; return false; }