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
|
<?
session_start();
$sessionidclient = $_SESSION['id_client'];
$article = $_POST['article'];
$quantite = $_POST['quantite'];
//connexion BDD
$req1 = "SELECT ref_produit, prix_produit FROM produit WHERE designation_produit = '".$article."'";
$query1 = mysql_query($req1);
$fetch1 = mysql_fetch_array($query1);
$total = $fetch1[1]*$quantite;
$inser = "INSERT INTO panier (id_cli, ref_produit, quantite, total) VALUES ( '".$_SESSION['id_client']."','".$fetch1[0]."', '".$quantite."', '".$total."')";
$inquer = mysql_query($inser);
$affected = mysql_affected_rows();
$reqtot = "SELECT sum(total) FROM panier WHERE id_cli = '".$_SESSION['id_client']."' ";
$querytot = mysql_query($reqtot);
$fetchtot = mysql_fetch_array($querytot);
$select = "SELECT ref_produit, quantite, total FROM panier WHERE id_cli = '".$_SESSION['id_client']."' ";
$quersel = mysql_query($select);
echo "<table border= 2>
<tr>
<td><center><b>Designation</td></center></b>
<td><center><b>Quantite</td></center></b>
<td><center><b>Prix(en )</td> </center></b>
<td><center><b>Total produit</td></center></b>
<td>Modifier</td></tr>";
while($fetchsel = mysql_fetch_array($quersel))
{
$selectdesi = "SELECT designation_produit, prix_produit FROM produit WHERE ref_produit = '".$fetchsel[0]."'";
$querdesi = mysql_query($selectdesi);
while ($fetchdesi = mysql_fetch_array($querdesi))
{
if(isset($_POST['sub_form']))
{
if ($_POST['sub_form'] == 'modifier')
{
$modif = "UPDATE panier SET quantite = ".$_POST['quantite'].", total = ".$fetchdesi[1] * $fetchsel[0]." WHERE ref_produit = '".$fetchsel[0]."' AND id_cli = '".$_SESSION['id_client']."'";
$res = mysql_query($modif) or die (mysql_error());
}
}
echo "<form method= 'post' action='{$_SERVER['PHP_SELF']}'>";
echo "<tr>
<td>".$fetchdesi[0]."</td>
<td><input type = text name = quantite value = ".$fetchsel[1]." ></td>
<td>".$fetchdesi[1]."</td>
<td>".$total."</td>
<td><input type = submit name = 'sub_form' value = 'modifier'></td>
</form>
</tr>
";
}
}
echo "
<tr><td></td><td></td><b><center> </b></td><td align = \"center\"><b>Total : ".$fetchtot[0]." </b></td></tr>
</table>
"; |
Partager