Update PDO bizare vraiment bizare

**sinistrus** · 09/09/2015, 17h11

Bonjour à tous !

J'utilise le PDO pour éditer ma table MySQL. Cependant, lors du chargement du formulaire de validation de l'édition, si je charge ma table, les données y sont inscrites, mais une fois le formulaire totalement chargé, la table se vide.
Je ne sais pas pourquoi mais svp, jetez un oeil à mon code :

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

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 &eacute;t&eacute; &eacute;dit&eacute; avec succ&egrave;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>");}
?>

Update PDO bizare vraiment bizare [PHP 5.4]

Langage PHP

Mode arborescent

Discussions similaires

Partager

Partager