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
| <?php
if (isset($_SESSION['MM_Username'])) {
mysql_select_db($database_connection_boutique, $connection_boutique);
$query_commande = sprintf("SELECT id
FROM shop_commande
WHERE client = '".$_SESSION['MM_Username']."'
ORDER BY id DESC");
$commande = mysql_query($query_commande, $connection_boutique) or die(mysql_error());
$row_commande = mysql_fetch_assoc($commande);
$totalRows_commande = mysql_num_rows($commande);
mysql_select_db($database_connection_boutique, $connection_boutique);
$query_panier = sprintf("SELECT * FROM shop_commander
WHERE client = '".$_SESSION['MM_Username']."'");
$panier = mysql_query($query_panier, $connection_boutique) or die(mysql_error());
$totalRows_panier = mysql_num_rows($panier);
mysql_select_db($database_connection_boutique, $connection_boutique);
$Result1 = mysql_query($insertSQL, $connection_boutique) or die(mysql_error());
$compteur = 0;
while ($row_panier = mysql_fetch_assoc($panier) and $compteur < $totalRows_panier)
{
$query_ligne_commande = sprintf("INSERT
INTO shop_ligne_commande (client, id, ref, couleur, XXS, XS, S, M, L, XL, XXL, quantite, pu, total, p1, P2, p3) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)",
GetSQLValueString($_SESSION['MM_Username'], "text"),
GetSQLValueString($row_commande['id'], "int"),
GetSQLValueString($row_panier['ref'], "text"),
GetSQLValueString($row_panier['couleur'], "text"),
GetSQLValueString($row_panier['XXS'], "int"),
GetSQLValueString($row_panier['XS'], "int"),
GetSQLValueString($row_panier['S'], "int"),
GetSQLValueString($row_panier['M'], "int"),
GetSQLValueString($row_panier['L'], "int"),
GetSQLValueString($row_panier['XL'], "int"),
GetSQLValueString($row_panier['XXL'], "int"),
GetSQLValueString($row_panier['quantite'], "int"),
GetSQLValueString($row_panier['pu'], "float"),
GetSQLValueString($row_panier['total'], "int"),
GetSQLValueString($row_panier['p1'], "float"),
GetSQLValueString($row_panier['p2'], "float"),
GetSQLValueString($row_panier['p3'], "float"));
mysql_select_db($database_connection_boutique, $connection_boutique);
$Result1 = mysql_query($query_ligne_commande, $connection_boutique) or die(mysql_error());
$query_suppr_panier = sprintf("DELETE FROM shop_commander WHERE ligne=%s",
GetSQLValueString($row_panier['ligne'], "int"));
mysql_select_db($database_connection_boutique, $connection_boutique);
$Result1 = mysql_query($query_suppr_panier, $connection_boutique) or die(mysql_error());
$compteur = $compteur+1;
}
}
?> |
