[MySQL] Transfert variable entre 2 fichiers

bjr,
je dispose d'un formulaire qui renvoie vers un fichier php
dont voici le code

Code:

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
 
if (($_POST['se1']==""))
{}
else
{
$requete51 = "UPDATE vn SET datesortie='$dateupdateF', bon='$_POST[chrono]' WHERE chassis='$_POST[se1]' && datesortie='0000-00-00'";
$execution = mysql_query( $requete51);
//on met à jour le champ    nbjstok
$requete511 = "UPDATE vn SET nbjstk=datediff(datesortie,datentree) WHERE chassis='$_POST[se1]'";
$execution = mysql_query( $requete511);
//on enleve la franchise
$requete5111="update vn SET nbjstk=((nbjstk)-(select nb_jfra from franchise where pseudo_fra='$_POST[site]')) where vn.chassis='$_POST[se1]'";
$execution=mysql_query( $requete5111);
$requete1 = "INSERT INTO programme (datesys, datelivraison, matin, aprem, site,stock,type,serie) VALUES (now(), '$_POST[datelivraison]','1','0','$_POST[site]','$_POST[st1]','$_POST[t1]','$_POST[se1]')";
$execution = mysql_query( $requete1);
}
if (($_POST['se2']==""))
{}
else
{
$requete52 = "UPDATE vn SET datesortie='$dateupdateF', bon='$_POST[chrono]' WHERE chassis='$_POST[se2]' && datesortie='0000-00-00'";
$execution = mysql_query( $requete52);
$requete521 = "UPDATE vn SET nbjstk=datediff(datesortie,datentree) WHERE chassis='$_POST[se2]'";
$execution = mysql_query( $requete521);
//on enleve la franchise
$requete5211="update vn SET nbjstk=((nbjstk)-(select nb_jfra from franchise where pseudo_fra='$_POST[site]')) where vn.chassis='$_POST[se2]'";
$execution=mysql_query( $requete5211);
}
if (($_POST['se3']==""))
{}
else
{
$requete53 = "UPDATE vn SET datesortie='$dateupdateF', bon='$_POST[chrono]' WHERE chassis='$_POST[se3]' && datesortie='0000-00-00'";
$execution = mysql_query( $requete53);
$requete531 = "UPDATE vn SET nbjstk=datediff(datesortie,datentree) WHERE chassis='$_POST[se3]'";
$execution = mysql_query( $requete531);
//on enleve la franchise
$requete5311="update vn SET nbjstk=((nbjstk)-(select nb_jfra from franchise where pseudo_fra='$_POST[site]')) where vn.chassis='$_POST[se3]'";
$execution=mysql_query( $requete5311);
}
if (($_POST['se4']==""))
{}
else
{
$requete54 = "UPDATE vn SET datesortie='$dateupdateF', bon='$_POST[chrono]' WHERE chassis='$_POST[se4]' && datesortie='0000-00-00'";
$execution = mysql_query( $requete54);
$requete541 = "UPDATE vn SET nbjstk=datediff(datesortie,datentree) WHERE chassis='$_POST[se4]'";
$execution = mysql_query( $requete541);
//on enleve la franchise
$requete5411="update vn SET nbjstk=((nbjstk)-(select nb_jfra from franchise where pseudo_fra='$_POST[site]')) where vn.chassis='$_POST[se4]'";
$execution=mysql_query( $requete5411);
}
if (($_POST['se5']==""))
{}
else
{
$requete55 = "UPDATE vn SET datesortie='$dateupdateF', bon='$_POST[chrono]' WHERE chassis='$_POST[se5]' && datesortie='0000-00-00'";
$execution = mysql_query( $requete55);
$requete551 = "UPDATE vn SET nbjstk=datediff(datesortie,datentree) WHERE chassis='$_POST[se5]'";
$execution = mysql_query( $requete551);
//on enleve la franchise
$requete5511="update vn SET nbjstk=((nbjstk)-(select nb_jfra from franchise where pseudo_fra='$_POST[site]')) where vn.chassis='$_POST[se5]'";
$execution=mysql_query( $requete5511);
}
if (($_POST['se6']==""))
{}
else
{
$requete56 = "UPDATE vn SET datesortie='$dateupdateF', bon='$_POST[chrono]' WHERE chassis='$_POST[se6]' && datesortie='0000-00-00'";
$execution = mysql_query( $requete56);
$requete561 = "UPDATE vn SET nbjstk=datediff(datesortie,datentree) WHERE chassis='$_POST[se6]'";
$execution = mysql_query( $requete561);
//on enleve la franchise
$requete5611="update vn SET nbjstk=((nbjstk)-(select nb_jfra from franchise where pseudo_fra='$_POST[site]')) where vn.chassis='$_POST[se6]'";
$execution=mysql_query( $requete5611);
}
if (($_POST['se7']==""))
{}
else
{
$requete57 = "UPDATE vn SET datesortie='$dateupdateF', bon='$_POST[chrono]' WHERE chassis='$_POST[se7]' && datesortie='0000-00-00'";
$execution = mysql_query( $requete57);
$requete571 = "UPDATE vn SET nbjstk=datediff(datesortie,datentree) WHERE chassis='$_POST[se7]'";
$execution = mysql_query( $requete571);
//on enleve la franchise
$requete5711="update vn SET nbjstk=((nbjstk)-(select nb_jfra from franchise where pseudo_fra='$_POST[site]')) where vn.chassis='$_POST[se7]'";
$execution=mysql_query( $requete5711);
}
if (($_POST['se8']==""))
{}
else
{
$requete58 = "UPDATE vn SET datesortie='$dateupdateF', bon='$_POST[chrono]' WHERE chassis='$_POST[se8]' && datesortie='0000-00-00'";
$execution = mysql_query( $requete58);
$requete581 = "UPDATE vn SET nbjstk=datediff(datesortie,datentree) WHERE chassis='$_POST[se8]'";
$execution = mysql_query( $requete581);
//on enleve la franchise
$requete5811="update vn SET nbjstk=((nbjstk)-(select nb_jfra from franchise where pseudo_fra='$_POST[site]')) where vn.chassis='$_POST[se8]'";
$execution=mysql_query( $requete5811);
}
if (($_POST['se9']==""))
{}
else
{
$requete59 = "UPDATE vn SET datesortie='$dateupdateF', bon='$_POST[chrono]' WHERE chassis='$_POST[se9]' && datesortie='0000-00-00'";
$execution = mysql_query( $requete59);
$requete591 = "UPDATE vn SET nbjstk=datediff(datesortie,datentree) WHERE chassis='$_POST[se9]'";
$execution = mysql_query( $requete591);
//on enleve la franchise
$requete5911="update vn SET nbjstk=((nbjstk)-(select nb_jfra from franchise where pseudo_fra='$_POST[site]')) where vn.chassis='$_POST[se9]'";
$execution=mysql_query( $requete5911);
}
if (($_POST['se10']==""))
{}
else
{
$requete60 = "UPDATE vn SET datesortie='$dateupdateF', bon='$_POST[chrono]' WHERE chassis='$_POST[se10]' && datesortie='0000-00-00'";
$execution = mysql_query( $requete60);
$requete601 = "UPDATE vn SET nbjstk=datediff(datesortie,datentree) WHERE chassis='$_POST[se10]'";
$execution = mysql_query( $requete601);
//on enleve la franchise
$requete6011="update vn SET nbjstk=((nbjstk)-(select nb_jfra from franchise where pseudo_fra='$_POST[site]')) where vn.chassis='$_POST[se10]'";
$execution=mysql_query( $requete6011);
}
if (($_POST['se11']==""))
{}
else
{
$requete61 = "UPDATE vn SET datesortie='$dateupdateF', bon='$_POST[chrono]' WHERE chassis='$_POST[se11]' && datesortie='0000-00-00'";
$execution = mysql_query( $requete61);
$requete611 = "UPDATE vn SET nbjstk=datediff(datesortie,datentree) WHERE chassis='$_POST[se11]'";
$execution = mysql_query( $requete611);
//on enleve la franchise
$requete6111="update vn SET nbjstk=((nbjstk)-(select nb_jfra from franchise where pseudo_fra='$_POST[site]')) where vn.chassis='$_POST[se11]'";
$execution=mysql_query( $requete6111);
}
if (($_POST['se12']==""))
{}
else
{
$requete62 = "UPDATE vn SET datesortie='$dateupdateF', bon='$_POST[chrono]' WHERE chassis='$_POST[se12]' && datesortie='0000-00-00'";
$execution = mysql_query( $requete62);
$requete621 = "UPDATE vn SET nbjstk=datediff(datesortie,datentree) WHERE chassis='$_POST[se12]'";
$execution = mysql_query( $requete621);
//on enleve la franchise
$requete6211="update vn SET nbjstk=((nbjstk)-(select nb_jfra from franchise where pseudo_fra='$_POST[site]')) where vn.chassis='$_POST[se12]'";
$execution=mysql_query( $requete6211);
}
if (($_POST['se13']==""))
{}
else
{
$requete63 = "UPDATE vn SET datesortie='$dateupdateF', bon='$_POST[chrono]' WHERE chassis='$_POST[se13]' && datesortie='0000-00-00'";
$execution = mysql_query( $requete63);
$requete631 = "UPDATE vn SET nbjstk=datediff(datesortie,datentree) WHERE chassis='$_POST[se13]'";
$execution = mysql_query( $requete631);
//on enleve la franchise
$requete6311="update vn SET nbjstk=((nbjstk)-(select nb_jfra from franchise where pseudo_fra='$_POST[site]')) where vn.chassis='$_POST[se13]'";
$execution=mysql_query( $requete6311);
}
if (($_POST['se14']==""))
{}
else
{
$requete64 = "UPDATE vn SET datesortie='$dateupdateF', bon='$_POST[chrono]' WHERE chassis='$_POST[se14]' && datesortie='0000-00-00'";
$execution = mysql_query( $requete64);
$requete641 = "UPDATE vn SET nbjstk=datediff(datesortie,datentree) WHERE chassis='$_POST[se14]'";
$execution = mysql_query( $requete641);
//on enleve la franchise
$requete6411="update vn SET nbjstk=((nbjstk)-(select nb_jfra from franchise where pseudo_fra='$_POST[site]')) where vn.chassis='$_POST[se14]'";
$execution=mysql_query( $requete6411);
}
Header("Location: prod_insert.php?num=".$_POST['num']."");
}
else Header("Location: ../erreur/travaux.php");
?>

il fonctionne correctement
par contre en fin de ce fichier je renvoi vers un autre fichier php

Code:

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
 
if (($_POST['se1']==""))
{}
else
{
echo $_POST['se1'];
$requete1 = "INSERT INTO programme (datesys, datelivraison, matin, aprem, site,stock,type,serie) VALUES (now(), '$_POST[datelivraison]','1','0','$_POST[site]','$_POST[st1]','$_POST[t1]','$_POST[se1]')";
$execution = mysql_query( $requete1);
}
if (($_POST['se2']==""))
{}
else
{
$requete2 = "INSERT INTO programme (datesys, datelivraison, matin, aprem, site,stock,type,serie) VALUES (now(), '$_POST[datelivraison]','1','0','$_POST[site]','$_POST[st2]','$_POST[t2]','$_POST[se2]')";
$execution = mysql_query( $requete2);
}
if (($_POST['se3']==""))
{}
else
{
$requete3 = "INSERT INTO programme (datesys, datelivraison, matin, aprem, site,stock,type,serie) VALUES (now(), '$_POST[datelivraison]','1','0','$_POST[site]','$_POST[st3]','$_POST[t3]','$_POST[se3]')";
$execution = mysql_query( $requete3);
}
if (($_POST['se4']==""))
{}
else
{
$requete4 = "INSERT INTO programme (datesys, datelivraison, matin, aprem, site,stock,type,serie) VALUES (now(), '$_POST[datelivraison]','1','0','$_POST[site]','$_POST[st4]','$_POST[t4]','$_POST[se4]')";
$execution = mysql_query( $requete4);
}
if (($_POST['se5']==""))
{}
else
 {
$requete5 = "INSERT INTO programme (datesys, datelivraison, matin, aprem, site,stock,type,serie) VALUES (now(), '$_POST[datelivraison]','1','0','$_POST[site]','$_POST[st5]','$_POST[t5]','$_POST[se5]')";
$execution = mysql_query( $requete5);
}
if (($_POST['se6']==""))
{}
else
{
$requete6 = "INSERT INTO programme (datesys, datelivraison, matin, aprem, site,stock,type,serie) VALUES (now(), '$_POST[datelivraison]','1','0','$_POST[site]','$_POST[st6]','$_POST[t6]','$_POST[se6]')";
$execution = mysql_query( $requete6);
}
if (($_POST['se71']==""))
{}
else
{
$requete7 = "INSERT INTO programme (datesys, datelivraison, matin, aprem, site,stock,type,serie) VALUES (now(), '$_POST[datelivraison]','1','0','$_POST[site]','$_POST[st7]','$_POST[t7]','$_POST[se7]')";
$execution = mysql_query( $requete7);
}
if (($_POST['se8']==""))
{}
else
{
$requete8 = "INSERT INTO programme (datesys, datelivraison, matin, aprem, site,stock,type,serie) VALUES (now(), '$_POST[datelivraison]','0','1','$_POST[site]','$_POST[st8]','$_POST[t8]','$_POST[se8]')";
$execution = mysql_query( $requete8);
}
if (($_POST['se9']==""))
{}
else
{
$requete9 = "INSERT INTO programme (datesys, datelivraison, matin, aprem, site,stock,type,serie) VALUES (now(), '$_POST[datelivraison]','0','1','$_POST[site]','$_POST[st9]','$_POST[t9]','$_POST[se9]')";
$execution = mysql_query( $requete9);
}
if (($_POST['se10']==""))
{}
else
 {
$requete10 = "INSERT INTO programme (datesys, datelivraison, matin, aprem, site,stock,type,serie) VALUES (now(), '$_POST[datelivraison]','0','1','$_POST[site]','$_POST[st10]','$_POST[t10]','$_POST[se10]')";
$execution = mysql_query( $requete10);
}
if (($_POST['se11']==""))
{}
else
{
$requete11 = "INSERT INTO programme (datesys, datelivraison, matin, aprem, site,stock,type,serie) VALUES (now(), '$_POST[datelivraison]','0','1','$_POST[site]','$_POST[st11]','$_POST[t11]','$_POST[se11]')";
$execution = mysql_query( $requete11);
}
if (($_POST['se12']==""))
{}
else
{
$requete12 = "INSERT INTO programme (datesys, datelivraison, matin, aprem, site,stock,type,serie) VALUES (now(), '$_POST[datelivraison]','0','1','$_POST[site]','$_POST[st12]','$_POST[t12]','$_POST[se12]')";
$execution = mysql_query( $requete12);
}
if (($_POST['se13']==""))
{}
else
{
$requete13 = "INSERT INTO programme (datesys, datelivraison, matin, aprem, site,stock,type,serie) VALUES (now(), '$_POST[datelivraison]','0','1','$_POST[site]','$_POST[st13]','$_POST[t13]','$_POST[se13]')";
$execution = mysql_query( $requete13);
}
if (($_POST['se14']==""))
{}
else
{
$requete14 = "INSERT INTO programme (datesys, datelivraison, matin, aprem, site,stock,type,serie) VALUES (now(), '$_POST[datelivraison]','0','1','$_POST[site]','$_POST[st14]','$_POST[t14]','$_POST[se14]')";
$execution = mysql_query( $requete14);

et lors du traitement j'ai l'erreur
Notice: Undefined index: se1 in H:\EasyPHP 2.0b1\www\intra\commandes\prod_insert.php on line 19

pour toutes les variables

pourquoi les variables passent bien dans le prmier php
et pas dans le second ?