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;
}
}
?> |
Partager