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 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220
| <?php
$NumId = $_GET["NumId"];
$Fr_Date = date("Y-m-d", strtotime($_POST["Fr_Date"]));
$Fr_Code = $_POST["Fr_Code"];
$Fr_Libelle = $_POST["Fr_Libelle"];
$Fr_Marque = $_POST["Fr_Marque"];
$Fr_MenuId = $_POST["Fr_MenuId"];
$Fr_SousMenuId = $_POST["Fr_SousMenuId"];
$Fr_Mixte = $_POST["Fr_Mixte"];
$Fr_Licence = $_POST["Fr_Licence"];
$Fr_Decouvrez = $_POST["Fr_Decouvrez"];
$Fr_PlusLoin = $_POST["Fr_PlusLoin"];
$Fr_Nouveau = $_POST["Fr_Nouveau"];
$Fr_Activer = $_POST["Fr_Activer"];
$Fr_Parapharmacie = $_POST["Fr_Parapharmacie"];
$Fr_Afficher = $_POST["Fr_Afficher"];
$Fr_Philosophie = $_POST["Fr_Philosophie"];
$Fr_Resumer = $_POST["Fr_Resumer"];
$Fr_Description = $_POST["Fr_Description"];
$Fr_Benefice = $_POST["Fr_Benefice"];
$Fr_Type = $_POST["Fr_Type"];
$Fr_Probleme = $_POST["Fr_Probleme"];
$Fr_Contenance = $_POST["Fr_Contenance"];
$Fr_Format1 = $_POST["Fr_Format1"];
$Fr_Format2 = $_POST["Fr_Format2"];
$Fr_Format3 = $_POST["Fr_Format3"];
$Fr_Format4 = $_POST["Fr_Format4"];
$Fr_Indications = $_POST["Fr_Indications"];
$Fr_Utilisation = $_POST["Fr_Utilisation"];
$Fr_Ingredients = $_POST["Fr_Ingredients"];
$Fr_Routine1 = $_POST["Fr_Routine1"];
$Fr_Routine2 = $_POST["Fr_Routine2"];
$Fr_Routine3 = $_POST["Fr_Routine3"];
$Fr_Routine4 = $_POST["Fr_Routine4"];
$Fr_Routine5 = $_POST["Fr_Routine5"];
$Fr_Olfaction = $_POST["Fr_Olfaction"];
$Fr_NoteTete = $_POST["Fr_NoteTete"];
$Fr_NoteCoeur = $_POST["Fr_NoteCoeur"];
$Fr_NoteFond = $_POST["Fr_NoteFond"];
$Fr_Pays_CI = isset($_POST["Fr_Pays_CI"]) ? "1" : "0";
$Fr_Pays_SN = isset($_POST["Fr_Pays_SN"]) ? "1" : "0";
$En_Libelle = $_POST["En_Libelle"];
$En_Philosophie = $_POST["En_Philosophie"];
$En_Resumer = $_POST["En_Resumer"];
$En_Description = $_POST["En_Description"];
$En_Benefice = $_POST["En_Benefice"];
$En_Type = $_POST["En_Type"];
$En_Probleme = $_POST["En_Probleme"];
$En_Contenance = $_POST["En_Contenance"];
$En_Indications = $_POST["En_Indications"];
$En_Utilisation = $_POST["En_Utilisation"];
$En_Ingredients = $_POST["En_Ingredients"];
$En_Olfaction = $_POST["En_Olfaction"];
$En_NoteTete = $_POST["En_NoteTete"];
$En_NoteCoeur = $_POST["En_NoteCoeur"];
$En_NoteFond = $_POST["En_NoteFond"];
$Fr_Date = date("Y-m-d", strtotime($Fr_Date));
$Fr_Code = stripslashes($Fr_Code);
$Fr_Libelle = stripslashes($Fr_Libelle);
$Fr_Marque = stripslashes($Fr_Marque);
$Fr_MenuId = stripslashes($Fr_MenuId);
$Fr_SousMenuId = stripslashes($Fr_SousMenuId);
$Fr_Mixte = stripslashes($Fr_Mixte);
$Fr_Licence = stripslashes($Fr_Licence);
$Fr_Decouvrez = stripslashes($Fr_Decouvrez);
$Fr_PlusLoin = stripslashes($Fr_PlusLoin);
$Fr_Nouveau = stripslashes($Fr_Nouveau);
$Fr_Activer = stripslashes($Fr_Activer);
$Fr_Parapharmacie = stripslashes($Fr_Parapharmacie);
$Fr_Afficher = stripslashes($Fr_Afficher);
$Fr_Philosophie = stripslashes($Fr_Philosophie);
$Fr_Resumer = stripslashes($Fr_Resumer);
$Fr_Description = stripslashes($Fr_Description);
$Fr_Benefice = stripslashes($Fr_Benefice);
$Fr_Type = stripslashes($Fr_Type);
$Fr_Probleme = stripslashes($Fr_Probleme);
$Fr_Contenance = stripslashes($Fr_Contenance);
$Fr_Format1 = stripslashes($Fr_Format1);
$Fr_Format2 = stripslashes($Fr_Format2);
$Fr_Format3 = stripslashes($Fr_Format3);
$Fr_Format4 = stripslashes($Fr_Format4);
$Fr_Indications = stripslashes($Fr_Indications);
$Fr_Utilisation = stripslashes($Fr_Utilisation);
$Fr_Ingredients = stripslashes($Fr_Ingredients);
$Fr_Routine1 = stripslashes($Fr_Routine1);
$Fr_Routine2 = stripslashes($Fr_Routine2);
$Fr_Routine3 = stripslashes($Fr_Routine3);
$Fr_Routine4 = stripslashes($Fr_Routine4);
$Fr_Routine5 = stripslashes($Fr_Routine5);
$Fr_Olfaction = stripslashes($Fr_Olfaction);
$Fr_NoteTete = stripslashes($Fr_NoteTete);
$Fr_NoteCoeur = stripslashes($Fr_NoteCoeur);
$Fr_NoteFond = stripslashes($Fr_NoteFond);
$Fr_Pays_CI = stripslashes($Fr_Pays_CI);
$Fr_Pays_SN = stripslashes($Fr_Pays_SN);
$En_Libelle = stripslashes($En_Libelle);
$En_Philosophie = stripslashes($En_Philosophie);
$En_Resumer = stripslashes($En_Resumer);
$En_Description = stripslashes($En_Description);
$En_Benefice = stripslashes($En_Benefice);
$En_Type = stripslashes($En_Type);
$En_Probleme = stripslashes($En_Probleme);
$En_Contenance = stripslashes($En_Contenance);
$En_Indications = stripslashes($En_Indications);
$En_Utilisation = stripslashes($En_Utilisation);
$En_Ingredients = stripslashes($En_Ingredients);
$En_Olfaction = stripslashes($En_Olfaction);
$En_NoteTete = stripslashes($En_NoteTete);
$En_NoteCoeur = stripslashes($En_NoteCoeur);
$En_NoteFond = stripslashes($En_NoteFond);
$FR_PDO = $pdo->prepare("UPDATE fr_produits SET Date=:Fr_Date, Code=:Fr_Code, Libelle=:Fr_Libelle, Marque=:Fr_Marque, MenuId=:Fr_MenuId, SousMenuId=:Fr_SousMenuId, Mixte=:Fr_Mixte, Licence=:Fr_Licence,
Decouvrez=:Fr_Decouvrez, PlusLoin=:Fr_PlusLoin, Nouveau=:Fr_Nouveau, Activer=:Fr_Activer, Parapharmacie=:Fr_Parapharmacie, Afficher=:Fr_Afficher,
Philosophie=:Fr_Philosophie, Resumer=:Fr_Resumer, Description=:Fr_Description, Benefice=:Fr_Benefice, Type=:Fr_Type, Probleme=:Fr_Probleme,
Contenance=:Fr_Contenance, Format1=:Fr_Format1, Format2=:Fr_Format2, Format3=:Fr_Format3, Format4=:Fr_Format4, Indications=:Fr_Indications,
Utilisation=:Fr_Utilisation, Ingredients=:Fr_Ingredients, Routine1=:Fr_Routine1, Routine2=:Fr_Routine2, Routine3=:Fr_Routine3, Routine4=:Fr_Routine4,
Routine5=:Fr_Routine5, Olfaction=:Fr_Olfaction, NoteTete=:Fr_NoteTete, NoteCoeur=:Fr_NoteCoeur, NoteFond=:Fr_NoteFond, CI=:Fr_Pays_CI, SN=:Fr_Pays_SN
WHERE NumId = ".$NumId." ");
$FR_PDO->bindParam(":Fr_Date", $Fr_Date);
$FR_PDO->bindParam(":Fr_Code", $Fr_Code);
$FR_PDO->bindParam(":Fr_Libelle", $Fr_Libelle);
$FR_PDO->bindParam(":Fr_Marque", $Fr_Marque);
$FR_PDO->bindParam(":Fr_MenuId", $Fr_MenuId);
$FR_PDO->bindParam(":Fr_SousMenuId", $Fr_SousMenuId);
$FR_PDO->bindParam(":Fr_Mixte", $Fr_Mixte);
$FR_PDO->bindParam(":Fr_Licence", $Fr_Licence);
$FR_PDO->bindParam(":Fr_Decouvrez", $Fr_Decouvrez);
$FR_PDO->bindParam(":Fr_PlusLoin", $Fr_PlusLoin);
$FR_PDO->bindParam(":Fr_Nouveau", $Fr_Nouveau);
$FR_PDO->bindParam(":Fr_Activer", $Fr_Activer);
$FR_PDO->bindParam(":Fr_Parapharmacie", $Fr_Parapharmacie);
$FR_PDO->bindParam(":Fr_Afficher", $Fr_Afficher);
$FR_PDO->bindParam(":Fr_Philosophie", $Fr_Philosophie);
$FR_PDO->bindParam(":Fr_Resumer", $Fr_Resumer);
$FR_PDO->bindParam(":Fr_Description", $Fr_Description);
$FR_PDO->bindParam(":Fr_Benefice", $Fr_Benefice);
$FR_PDO->bindParam(":Fr_Type", $Fr_Type);
$FR_PDO->bindParam(":Fr_Probleme", $Fr_Probleme);
$FR_PDO->bindParam(":Fr_Contenance", $Fr_Contenance);
$FR_PDO->bindParam(":Fr_Format1", $Fr_Format1);
$FR_PDO->bindParam(":Fr_Format2", $Fr_Format2);
$FR_PDO->bindParam(":Fr_Format3", $Fr_Format3);
$FR_PDO->bindParam(":Fr_Format4", $Fr_Format4);
$FR_PDO->bindParam(":Fr_Indications", $Fr_Indications);
$FR_PDO->bindParam(":Fr_Utilisation", $Fr_Utilisation);
$FR_PDO->bindParam(":Fr_Ingredients", $Fr_Ingredients);
$FR_PDO->bindParam(":Fr_Routine1", $Fr_Routine1);
$FR_PDO->bindParam(":Fr_Routine2", $Fr_Routine2);
$FR_PDO->bindParam(":Fr_Routine3", $Fr_Routine3);
$FR_PDO->bindParam(":Fr_Routine4", $Fr_Routine4);
$FR_PDO->bindParam(":Fr_Routine5", $Fr_Routine5);
$FR_PDO->bindParam(":Fr_Olfaction", $Fr_Olfaction);
$FR_PDO->bindParam(":Fr_NoteTete", $Fr_NoteTete);
$FR_PDO->bindParam(":Fr_NoteCoeur", $Fr_NoteCoeur);
$FR_PDO->bindParam(":Fr_NoteFond", $Fr_NoteFond);
$FR_PDO->bindParam(":Fr_Pays_CI", $Fr_Pays_CI);
$FR_PDO->bindParam(":Fr_Pays_SN", $Fr_Pays_SN);
$FR_PDO->execute();
$EN_PDO = $pdo->prepare("UPDATE en_produits SET Date=:Fr_Date, Code=:Fr_Code, Libelle=:En_Libelle, Marque=:Fr_Marque, MenuId=:Fr_MenuId, SousMenuId=:Fr_SousMenuId, Mixte=:Fr_Mixte, Licence=:Fr_Licence,
Decouvrez=:Fr_Decouvrez, PlusLoin=:Fr_PlusLoin, Nouveau=:Fr_Nouveau, Activer=:Fr_Activer, Parapharmacie=:Fr_Parapharmacie, Afficher=:Fr_Afficher,
Philosophie=:En_Philosophie, Resumer=:En_Resumer, Description=:En_Description, Benefice=:En_Benefice, Type=:En_Type, Probleme=:En_Probleme,
Contenance=:En_Contenance, Format1=:Fr_Format1, Format2=:Fr_Format2, Format3=:Fr_Format3, Format4=:Fr_Format4, Indications=:En_Indications,
Utilisation=:En_Utilisation, Ingredients=:En_Ingredients, Routine1=:Fr_Routine1, Routine2=:Fr_Routine2, Routine3=:Fr_Routine3, Routine4=:Fr_Routine4,
Routine5=:Fr_Routine5, Olfaction=:En_Olfaction, NoteTete=:En_NoteTete, NoteCoeur=:En_NoteCoeur, NoteFond=:En_NoteFond, CI=:Fr_Pays_CI, SN=:Fr_Pays_SN
WHERE NumId = ".$NumId." ");
$EN_PDO->bindParam(":Fr_Date", $Fr_Date);
$EN_PDO->bindParam(":Fr_Code", $Fr_Code);
$EN_PDO->bindParam(":En_Libelle", $En_Libelle);
$EN_PDO->bindParam(":Fr_Marque", $Fr_Marque);
$EN_PDO->bindParam(":Fr_MenuId", $Fr_MenuId);
$EN_PDO->bindParam(":Fr_SousMenuId", $Fr_SousMenuId);
$EN_PDO->bindParam(":Fr_Mixte", $Fr_Mixte);
$EN_PDO->bindParam(":Fr_Licence", $Fr_Licence);
$EN_PDO->bindParam(":Fr_Decouvrez", $Fr_Decouvrez);
$EN_PDO->bindParam(":Fr_PlusLoin", $Fr_PlusLoin);
$EN_PDO->bindParam(":Fr_Nouveau", $Fr_Nouveau);
$EN_PDO->bindParam(":Fr_Activer", $Fr_Activer);
$EN_PDO->bindParam(":Fr_Parapharmacie", $Fr_Parapharmacie);
$EN_PDO->bindParam(":Fr_Afficher", $Fr_Afficher);
$EN_PDO->bindParam(":En_Philosophie", $En_Philosophie);
$EN_PDO->bindParam(":En_Resumer", $En_Resumer);
$EN_PDO->bindParam(":En_Description", $En_Description);
$EN_PDO->bindParam(":En_Benefice", $En_Benefice);
$EN_PDO->bindParam(":En_Type", $En_Type);
$EN_PDO->bindParam(":En_Probleme", $En_Probleme);
$EN_PDO->bindParam(":En_Contenance", $En_Contenance);
$EN_PDO->bindParam(":Fr_Format1", $Fr_Format1);
$EN_PDO->bindParam(":Fr_Format2", $Fr_Format2);
$EN_PDO->bindParam(":Fr_Format3", $Fr_Format3);
$EN_PDO->bindParam(":Fr_Format4", $Fr_Format4);
$EN_PDO->bindParam(":En_Indications", $En_Indications);
$EN_PDO->bindParam(":En_Utilisation", $En_Utilisation);
$EN_PDO->bindParam(":En_Ingredients", $En_Ingredients);
$EN_PDO->bindParam(":Fr_Routine1", $Fr_Routine1);
$EN_PDO->bindParam(":Fr_Routine2", $Fr_Routine2);
$EN_PDO->bindParam(":Fr_Routine3", $Fr_Routine3);
$EN_PDO->bindParam(":Fr_Routine4", $Fr_Routine4);
$EN_PDO->bindParam(":Fr_Routine5", $Fr_Routine5);
$EN_PDO->bindParam(":En_Olfaction", $En_Olfaction);
$EN_PDO->bindParam(":En_NoteTete", $En_NoteTete);
$EN_PDO->bindParam(":En_NoteCoeur", $En_NoteCoeur);
$EN_PDO->bindParam(":En_NoteFond", $En_NoteFond);
$EN_PDO->bindParam(":Fr_Pays_CI", $Fr_Pays_CI);
$EN_PDO->bindParam(":Fr_Pays_SN", $Fr_Pays_SN);
$EN_PDO->execute();
$Msg_Valide = "<div class=\"Message\">L'enregistrement a été édité avec succès.</div>";
$Msg_Erreur = "<div class=\"Erreur\">Une erreur est survenue lors de l'enregistrement.</div>";
if($FR_PDO){echo $Msg_Valide;}else{echo $Msg_Erreur;}
if (!empty($_GET["msg"])){$msg=urldecode($_GET["msg"]); $msg=stripslashes($msg); echo("<div class=\"Erreur\">$msg</div>");}
?> |
Partager