Code : Tout sélectionner
<?php
$base = mysql_connect("serveur","identifiant","mot de passe");
mysql_select_db("base",$base);
$no = $_POST['no'];$no1 = $_POST['no1'];$no2 = $_POST['no2'];$no3 = $_POST['no3'];$no4 = $_POST['no4'];
$nb = $_POST['nb'];$nb1 = $_POST['nb1'];$nb2 = $_POST['nb2'];$nb3 = $_POST['nb3'];$nb4 = $_POST['nb4'];
$requete = mysql_query("SELECT * FROM inventaire WHERE identifiant='$no'")or die(mysql_error());
$resultat = mysql_fetch_array($requete);
$prix = $resultat['prix'];
$nom = $resultat['nom'];
$photo = $resultat['photo'];
$prixtotal = $prix*$nb;
$requete1 = mysql_query("SELECT * FROM inventaire WHERE identifiant='$no1'")or die(mysql_error());
$resultat1 = mysql_fetch_array($requete1);
$prix1 = $resultat1['prix'];
$nom1 = $resultat1['nom'];
$photo1 = $resultat1['photo'];
$prixtotal1 = $prix1*$nb1;
$requete2 = mysql_query("SELECT * FROM inventaire WHERE identifiant='$no2'")or die(mysql_error());
$resultat2 = mysql_fetch_array($requete2);
$prix2 = $resultat2['prix'];
$nom2 = $resultat2['nom'];
$photo2 = $resultat2['photo'];
$prixtotal2 = $prix2*$nb2;
$requete3 = mysql_query("SELECT * FROM inventaire WHERE identifiant='$no3'")or die(mysql_error());
$resultat3 = mysql_fetch_array($requete3);
$prix3 = $resultat3['prix'];
$nom3 = $resultat3['nom'];
$photo3 = $resultat3['photo'];
$prixtotal3 = $prix3*$nb3;
$requete4 = mysql_query("SELECT * FROM inventaire WHERE identifiant='$no4'")or die(mysql_error());
$resultat4 = mysql_fetch_array($requete4);
$prix4 = $resultat4['prix'];
$nom4 = $resultat4['nom'];
$photo4 = $resultat4['photo'];
$prixtotal4 = $prix4*$nb4;
$grandtotal = $prixtotal + $prixtotal1 + $prixtotal2 + $prixtotal3 + $prixtotal4;
echo '<div align="center">Veuillez confirmer votre commande s\'il vous plaît</div>';
echo '<div align="center"><center>
<table border="1" cellspacing="1" height="55">
<tr>
<td align="left">Photo</td>
<td align="left">no d\'identification</td>
<td align="left">Nom de l\'article</td>
<td align="left">Prix à l\'unité</td>
<td align="left">Quantité</td>
<td align="left">Total</td>
</tr>
<tr>
<td align="center"><img src='.$photo.'></td>
<td align="center">'.$no.'</td>
<td align="center">'.$nom.'</td>
<td align="right">'.number_format($prix, 2, ',', ' ').'</td>
<td align="right">'.$nb.'</td>
<td align="right">'.number_format($prixtotal, 2, ',', ' ').'</td>
</tr>
<tr>
<td align="center"><img src='.$photo1.'></td>
<td align="center">'.$no1.'</td>
<td align="center">'.$nom1.'</td>
<td align="right">'.number_format($prix1, 2, ',', ' ').'</td>
<td align="right">'.$nb1.'</td>
<td align="right">'.number_format($prixtotal1, 2, ',', ' ').'</td>
</tr>
<tr>
<td align="center"><img src='.$photo2.'></td>
<td align="center">'.$no2.'</td>
<td align="center">'.$nom2.'</td>
<td align="right">'.number_format($prix2, 2, ',', ' ').'</td>
<td align="right">'.$nb2.'</td>
<td align="right">'.number_format($prixtotal2, 2, ',', ' ').'</td>
</tr>
<tr>
<td align="center"><img src='.$photo3.'></td>
<td align="center">'.$no3.'</td>
<td align="center">'.$nom3.'</td>
<td align="right">'.number_format($prix3, 2, ',', ' ').'</td>
<td align="right">'.$nb3.'</td>
<td align="right">'.number_format($prixtotal3, 2, ',', ' ').'</td>
</tr>
<tr>
<td align="center"><img src='.$photo4.'></td>
<td align="center">'.$no4.'</td>
<td align="center">'.$nom4.'</td>
<td align="right">'.number_format($prix4, 2, ',', ' ').'</td>
<td align="right">'.$nb4.'</td>
<td align="right">'.number_format($prixtotal4, 2, ',', ' ').'</td>
</tr>
<tr>
<td align="center" colspan="5">
<p align="right">Prix total :</td>
<td align="right">'.number_format($grandtotal, 2, ',', ' ').'</td>
</tr>
</table>
</div>';