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;
}
