1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26
| <?php
$rfid = $_GET['RFID'];
$req=$bdd->prepare("
DELIMITER //
CREATE TRIGGER ajouter_effacer BEFORE INSERT ON $rfid
FOR EACH ROW
BEGIN
DELETE FROM $rfid
WHERE N =
(
SELECT MIN(N)
FROM $rfid
)
INSERT INTO $rfid(RFID,Chambre,Nom,Prenom,Sexe,Age,Taille,Poids,Alergies,Antecedents,Tension,Temperature,Rythme,Glycemie)
VALUES(NEW.:rfid_,:chambre_,:nom_,:prenom_,:sexe_,:age_,:taille_,:poids_,:allergies_,:antecedents_,:tension_,:temperature_,:rythme_,:glycemie_)
END//
DELIMITER");
$req->execute( array('rfid_'=>$_GET['RFID'],'chambre_'=>$_GET['CHAMBRE'],'nom_'=>$_GET['NOM'],'prenom_'=>$_GET['PRENOM'],'sexe_'=>$_GET['SEXE'],
'age_'=>$_GET['AGE'],'taille_'=>$_GET['TAILLE'],'poids_'=>$_GET['POIDS'],'allergies_'=>$_GET['ALERGIES'],'antecedents_'=>$_GET['ANTECEDENTS'],
ici line 42 'tension_'=>$_GET['TENSION'],'temperature_'=>$_GET['TEMPERATURE'],'rythme_'=>$_GET['RYTHME'],'glycemie_'=>$_GET['GLYCEMIE']));
$req->closeCursor();
?> |
Partager