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
| <?php
if (isset($_SESSION['MM_Username'])) {
mysql_select_db($database_Maboutique, $Maboutique);
$query_commande = sprintf("SELECT id_commande FROM shop_commande WHERE client = '".$_SESSION['MM_Username']."' ORDER BY id_commande DESC");
$commande = mysql_query($query_commande, $Maboutique) or die(mysql_error());
$row_commande = mysql_fetch_assoc($commande);
$totalRows_commande = mysql_num_rows($commande);
mysql_select_db($database_Maboutique, $Maboutique);
$query_panier = sprintf("SELECT shop_panier.*, shop_produit.prix_ttc,
shop_produit.prix_ttc*shop_panier.quantite AS total_ttc FROM shop_panier INNER JOIN shop_produit ON shop_produit.id_article = shop_panier.ref_produit WHERE client = '".$_SESSION['MM_Username']."'");
$panier = mysql_query($query_panier, $Maboutique) or die(mysql_error());
$totalRows_panier = mysql_num_rows($panier);
$compteur = 0;
while ($row_panier = mysql_fetch_assoc($panier) and $compteur < $totalRows_panier)
{
$query_ligne_commande = sprintf("INSERT INTO shop_ligne_commande (ref_commande, ref_produit, prix_ttc, quantite, total_ttc) VALUES (%s, %s, %s, %s, %s)",
GetSQLValueString($row_commande['id_commande'], "int"),
GetSQLValueString($row_panier['ref_produit'], "int"),
GetSQLValueString($row_panier['prix_ttc'], "double"),
GetSQLValueString($row_panier['quantite'], "int"),
GetSQLValueString($row_panier['total_ttc'], "double"));
mysql_select_db($database_Maboutique, $Maboutique);
$Result1 = mysql_query($query_ligne_commande, $Maboutique) or die(mysql_error());
$query_suppr_panier = sprintf("DELETE FROM shop_panier WHERE id_panier=%s",
GetSQLValueString($row_panier['id_panier'], "int"));
mysql_select_db($database_Maboutique, $Maboutique);
$Result1 = mysql_query($query_suppr_panier, $Maboutique) or die(mysql_error());
$compteur = $compteur+1;
}
}
?> |
Partager