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
|
$add_com = " INSERT INTO commande(num_com, date_com) VALUES ( '', '".$date."' )";
$derniere_com = "SELECT MAX(num_com) FROM commande WHERE date_com = '".$date."';";
if ($base=mysql_connect (SERVEUR,log,password))
{
echo "<h1><u><center></u></h1></center><br>";
}
else
{
echo "<H3>Echec de la connexion au serveur</h3>";
exit;
}
mysql_select_db(BASE,$base);
$requetes = array (
"passer" => array ("", "", "", "", "", "", "","","","","","","","","","","","","","","","","","","","","","","","") ,
"conserner" => array ("", "", "", "", "", "", "","","","","","","","","","","","","","","","","","","","","","","",""),
"acheter" => array ("", "", "", "", "", "", "","","","","","","","","","","","","","","","","","","","","","","",""),
"livraison" => array ("", "", "", "", "", "", "","","","","","","","","","","","","","","","","","","","","","","",""),
"ligne_livr" => array ("","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","")
);
if (mysql_query ($add_com,$base))
{
echo "<h3><B><b><center><font face = papyrus>Votre commande a bien été prise en compte</B><br><br>Le paiement s'effectuera au moment de la livraison<br>
le delais est de 48h
</center>"; //contre remboursement paiement à la livraison delais de livraison contre remboursement : paiement à la livraison
}
else
{
echo "Erreur dans l'éxecution de la requete add_commande<br>";
echo "Erreur".mysql_error().":".mysql_error()."<br>";
}
if ($tab_com = mysql_query ($derniere_com,$base))
{
$res_com = mysql_fetch_array($tab_com);
$num_com = $res_com[0];
$quantite = $_SESSION['panier']['quantite'];
$add_passer = "INSERT INTO passer (num_com, num_cli) VALUES ('".$num_com."', '".$_SESSION['num_cli']."')"; //fais le lien entre la table client et la table commande grace a la table PASSER
$add_conserner = "INSERT INTO conserner (num_com, ref_produit, quantite) VALUES ( '".$num_com."','".$_SESSION['panier']['ref_produit']."', '".$_SESSION['panier']['quantite']."')"; //idem entre la table produit et la table commande
$add_acheter = "INSERT INTO acheter (num_cli, ref_produit, designation_produit, quantite, total) VALUES ('".$_SESSION['num_cli']."', '".$_SESSION['panier']['ref_produit']."', '".$_SESSION['article']."', ".$quantite.",'".$_SESSION['total']."' )";
$add_livraison = "INSERT INTO livraison (num_livr, date_livr, etat_livr) VALUES ('','aucun', 'encours de traitement')";
$add_ligne_livr = "INSERT INTO ligne_livr (num_com, num_livr) VALUES ('".$num_com."', '')";
}
else
{
echo "Erreur dans l'éxecution de la requete derniere_comm<br>";
echo "Erreur".mysql_error().":".mysql_error()."<br>";
}
if ($tab_com = mysql_query ($add_com,$base))
{
for ($i = 0; $i <= 20 ; $i++)
{
if ($_SESSION['panier']['quantite'][$i] >0)
{
$requetes['passer'][$i] = "INSERT INTO passer(num_com, num_cli) VALUES ('".$num_com."', '".$_SESSION['num_cli']."')";
$requetes['conserner'][$i] = "INSERT INTO conserner (num_com, ref_produit, quantite) VALUES ( '".$num_com."','".$_SESSION['panier']['ref_produit'][$i]."', '".$_SESSION['panier']['quantite'][$i]."');";
$requetes['acheter'][$i] = "INSERT INTO acheter (num_cli, ref_produit, designation_produit, quantite, total) VALUES ('".$_SESSION['num_cli']."', '".$_SESSION['panier']['ref_produit'][$i]."', '".$_SESSION['article']."', '".$_SESSION['panier']['quantite'][$i]."','".$_SESSION['total']."');";
$requetes['livraison'][$i] = "INSERT INTO livraison (num_livr, date_livr, etat_livr) VALUES ('','aucun', 'encours de traitement')";
$requetes['ligne_livr'][$i] = "INSERT INTO ligne_livr (num_com, num_livr) VALUES ('".$num_com."', '')";
}
}
for ($i = 0; $i <= 20 ; $i++)
{
if ($requetes['conserner'][$i] != "")
{
if (mysql_query ($requetes['conserner'][$i],$base))
{
//echo "<h3>Conserner n°".$i." Ajoute</h3>";
}
else
{
echo "Erreur dans l'éxecution de la requete add_conserner<br>";
echo "Erreur".mysql_error().":".mysql_error()."<br>";
}
}
//echo "<br>Passer = ".$requetes['passer'][1]."<br>";
if ($requetes['passer'][$i] != "")
{
if (mysql_query ($requetes['passer'][$i],$base))
{
//echo "<h3>Passer Ajoute n°".$i."</h3>";
}
else
{
echo "Erreur dans l'éxecution de la requete add_passer<br>";
echo "Erreur".mysql_error().":".mysql_error()."<br>";
}
}
//echo"<br>acheter = ".$requetes['acheter'][$i]."<br>";
if ($requetes['acheter'][$i] != "")
{
if (mysql_query ($requetes['acheter'][$i],$base))
{
//echo "<h3>Acheter n°".$i." Ajoute</h3>";
}
else
{
// echo "Erreur dans l'éxecution de la requete add_acheter<br>";
echo "Erreur".mysql_error().":".mysql_error()."<br>";
}
}
if ($requetes['livraison'][$i] != "")
{
if (mysql_query ($requetes['livraison'][$i],$base))
{
//echo "<h3>Livraison n°".$i." Ajoute</h3>";
}
else
{
//echo "Erreur dans l'éxecution de la requete add_livraison<br>";
echo "Erreur".mysql_error().":".mysql_error()."<br>";
}
}
// echo"<br>ligne_livr = ".$requetes['ligne_livr'][$i]."<br>";
if ($requetes['ligne_livr'][$i] != "")
{
if (mysql_query ($requetes['ligne_livr'][$i],$base))
{
//echo "<h3>Livraison n°".$i." Ajoute</h3>";
}
else
{
echo "Erreur dans l'éxecution de la requete add_ligne_livr<br>";
echo "Erreur".mysql_error().":".mysql_error()."<br>";
}
}
}
} |
Problème double insertion dans BDD
Répondre avec citation
) : 
Envoyé par oceane751
Partager