Salut voici le code:
<?php
session_start (); // création d'une nouvelle session ***********************
// variables de connexion **************************************************
$database = "gestion_stock";
$user = "root";
$pwd = "";
$host = "localhost";
// fin variables de connexion **********************************************
//réinitialisation des sessions ********************************************
if(isset($_POST['reset']))
{
session_unregister('selectp');
}
// fin réinitialisation des sessions ****************************************
// deselectionner un produit ***********************************************
$sDelProd = (isset($_GET['iDelProd'])) ? $_GET['iDelProd'] : '';
if($sDelProd !="")
{ if(isset($_SESSION['selectp']))
{
$aDelProd[$_GET['iDelProd']] = $_GET['iDelProd'];
$aSelectedProdq = explode(",", $_SESSION['selectp']);
foreach($aSelectedProdq as $k=>$v)
{
$aElem = explode(":", $v);
$aSelectedProd[$aElem[0]] = $aElem[1];
}
$iNbr = count($aSelectedProd);
if($iNbr ==1)
{
session_unregister('selectp');
}
else
{
$aSelectedProd = array_diff_key($aSelectedProd,$aDelProd);
$_SESSION['selectp'] = '';
foreach($aSelectedProd as $k=>$v)
{
$_SESSION['selectp'] = ($_SESSION['selectp'] == '') ? $k.':'.$v : $_SESSION['selectp'].','.$k.':'.$v;
}
}
header('location:Ajouter_facture3.php');
}
}
// fin deselctionner un produit *********************************************
// connexion au serveur mysql
mysql_pconnect($host,$user,$pwd) or die("Erreur d'accès au serveur Mysql");
// selection de la base de données
mysql_select_db($database) or die("Erreur de selection de la base de données");
// Inialisation des variables utilisateur ********************************
$iSelectedProd = (isset($_POST['refp'])) ? $_POST['refp'] : '';
$iQteProd = (isset($_POST['qte'])) ? (integer) $_POST['qte'] : '';
if($iSelectedProd != "" and is_int($iQteProd) and $iQteProd != 0)
{
if(isset($_SESSION['selectp'])) {$_SESSION['selectp'] .= ",".$iSelectedProd.':'.$iQteProd;
}
else{$_SESSION['selectp'] = $iSelectedProd.':'.$iQteProd;
}
}
// Fin Inialisation des variables utilisateur ****************************
$sSql = "SELECT ref FROM produit";
$iRes = mysql_query($sSql) or die(mysql_error());
$iNbr = mysql_num_rows($iRes);
while($aData = mysql_fetch_assoc($iRes))
{
$aListProd[$aData['ref']] = $aData['ref'];
}
if(isset($_SESSION['selectp']) && isset($aListProd))
{
$aSelectedProdq = explode(",", $_SESSION['selectp']);
foreach($aSelectedProdq as $k=>$v)
{
$aElem = explode(":", $v);
$aSelectedProd[$aElem[0]] = $aElem[1];
}
$aProdNotSelected = array_diff_key($aListProd,$aSelectedProd);
}
else
{
$aProdNotSelected = $aListProd;
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Facture</title>
<link href="styles.css" rel="stylesheet" type="text/css" />
</head>
<body>
<form action="#" name="prod" method="post" enctype="multipart/form-data">
<div id="Layer5">
<table width="402" height="219" border="0">
<tr>
<td width="396" bgcolor="#CCCCCC"><p><strong>MICROHARD Vente Materiel et Accessoire </strong></p>
<p><strong>Compte bancaire:</strong><strong><br />
</strong><strong>R.C:</strong></p>
<p><strong>Id_fiscal:</strong></p>
<p><strong>Art_impo:</strong></p>
<p><strong>Tel:0553524888</strong></p>
<p><strong>Adresse:Local N°2 Immeuble HADRI Azeffoun Centre </strong></p></td>
</tr>
</table>
</div>
<div id="Layer8"><img src="../../../EasyPHP 3.0/www/facture/IMAGES/Ajouter_facture_clip_image001_0002.gif" width="184" height="34" />
<div id="Layer18"> <strong><?php echo date("d/F/Y"); ?></strong></div>
</div>
<div id="Layer7"><strong></div>
<p> </p>
<p> </p>
<p> </p>
<div id="Layer11"><span class="Style2"><strong>Client:<?php require_once('Connections/connect.php'); ?>
<?php
mysql_select_db($database_connect, $connect);
$query_Recordset1 = "SELECT identifiant FROM client";
$Recordset1 = mysql_query($query_Recordset1, $connect) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
$totalRows_Recordset1 = mysql_num_rows($Recordset1);
?>
<label>
<select name="select">
<?php
do {
?>
<option value="<?php echo $row_Recordset1['identifiant']?>"<?php if (!(strcmp($row_Recordset1['identifiant'], $row_Recordset1['identifiant']))) {echo "selected=\"selected\"";} ?>><?php echo $row_Recordset1['identifiant']?></option>
<?php
} while ($row_Recordset1 = mysql_fetch_assoc($Recordset1));
$rows = mysql_num_rows($Recordset1);
if($rows > 0) {
mysql_data_seek($Recordset1, 0);
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
}
?>
</select>
</label>
<?php
mysql_free_result($Recordset1);
?>
</strong>
</span>
<div class="Style2" id="Layer12"><strong>Facture N°: <?php echo date("Y");?></strong></div>
<label></label>
</div>
<p> </p>
<p> </p>
<p> </p>
<p><strong>Mode de paiement: </strong>
<label>
<select name="select">
<option>En espèce</option>
<option>Par chèque</option>
</select>
</label>
<p>
<label>
Produit : <select name="refp">
<option value="">Choisir</option>
<?php
foreach($aProdNotSelected as $k=>$v)
{
?>
<option value="<?php echo $v; ?>"> <?php echo $v; ?> </option>
<?php
}
?>
</select>
Quantité : <input type="text" name="qte" size="3"/>
<input type="button" name="add" value="Ajouter" onclick="javascript:document.prod.submit();"/>
</label>
<label> </label>
<div id="Layer14">
<table width="1209" height="54" border="1">
<tr>
<td width="185"><strong>Reference</strong></td>
<td width="487"><strong>Designation</strong></td>
<td width="126"><strong>Quantite</strong></td>
<td width="135"><strong>Prix Unitaire </strong></td>
<td width="125"><strong>Montant</strong></td>
</tr>
</table>
</td>
<?php
$somme =0;
?>
<?php
mysql_free_result($iRes);
if(isset($aSelectedProd))
{
$somme = 0;
foreach($aSelectedProd as $k=>$v)
{
$Sqlp = "SELECT * FROM produit WHERE ref ='".$k."' " ;
$ress = mysql_query($Sqlp);
$data = mysql_fetch_assoc($ress);
?>
<label> </label>
<table width="1208" border="1">
<tr>
<td width="186"> <label></label> <strong><spacer /><?php echo $data['ref'];?></strong>
<br/>
<td width="486" height="35"><strong><?php echo $data['nom'];?>
</strong></td>
<td width="127" height="35"><strong><?php echo $v;?></strong></td>
<td width="135" height="35"><strong><?php echo $data['prix_achat'];?></strong></td>
<td width="124" height="35"><strong><?php echo $data['prix_achat']*$v;?></strong>
<a href="Ajouter_facture3.php?iDelProd=<?php echo $data['ref']; ?>">Enlever</a>
</td>
</tr>
</table>
<div align="right">
<table width="244" border="1">
<tr>
<td>Total H.T:<?php $somme = $somme + $data['prix_achat']*$v;?>
</td>
</tr>
</table>
<table width="242" border="1">
<tr>
<td>Total T.V.A: </td>
</tr>
</table>
<table width="242" border="1">
<tr>
<td>Total T.T.C: </td>
</tr>
</table>
<?php
}
}
?>
<div align="center">
<p><strong><?php echo "La presente facture est arretée à la somme de :" ;?>
</strong></p>
<p><strong>
<input type="submit" name="reset" value="Réinitialiser" />
<input type="submit" name="valider" value="Valider" />
</strong></p>
</div>
</div>
</div>
</p>
<p> </p>
</form>
</body>
</html>