$session = $_SESSION[\"pseudo\"];
$session = $_SESSION["pseudo"]; // ou $session = $_SESSION['pseudo'];
//Ceci évite des erreurs lors de la récup des données $session = isset($_SESSION["pseudo"])? $_SESSION["pseudo"]:'';
$sql = \"INSERT INTO articles(id_art,dateArt,articleVendu,articleRef,articleQuant,articlePU,id,id_prod,session) VALUES('',NOW(),'\".$articleVendu.\"','\".$articleRef.\"','\".$articleQuant.\"','\".$articlePU.\"','\".$id.\"','\".$id_prod.\"','\".$_SESSION[\"pseudo\"].\"')\";
$sql = \"INSERT INTO articles( dateArt ,articleVendu ,articleRef ,articleQuant ,articlePU ,id ,id_prod,session) VALUES(NOW() ,'\".$articleVendu.\"' ,'\".$articleRef.\"' ,'\".$articleQuant.\"' ,'\".$articlePU.\"' ,'\".$id.\"' ,'\".$id_prod.\"' ,'\".$_SESSION[\"pseudo\"].\"' )\";
$pseudo = isset($_SESSION['pseudo'])?$_SESSION['pseudo']:''; $sql = "INSERT INTO articles ( dateArt ,articleVendu ,articleRef ,articleQuant ,articlePU ,id ,id_prod,session ) VALUES( NOW() ,'$articleVendu' ,'$articleRef' ,'$articleQuant' ,'$articlePU' ,'$id' ,'$id_prod' ,'$pseudo' )";
echo m'affiche : 11111
// on fait l'INSERT dans la base de données $sql = "INSERT INTO articles ( dateArt ,articleVendu ,articleRef ,articleQuant ,articlePU ,id ,id_prod,session ) VALUES( NOW() ,'$articleVendu' ,'$articleRef' ,'$articleQuant' ,'$articlePU' ,'$id' ,'$id_prod' ,'$pseudo' )"; // >>>> ECHO DE LA REQUETE <<<<<< echo "<br><b> REQUETE : </b><br>".$sql."<br>"; // on insère les informations du formulaire dans la table mysql_query($sql) or die('Erreur SQL !'.$sql.'<br>'.mysql_error());
j'ai fais suivi vos conseils.Sauf pour :
si ça bloque toujours, repostes ton code modifié et indique nous (en fonction de mes remaques/questions) ce que tu obtiens....
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre question$sql = "INSERT INTO articles ( dateArt ,articleVendu ,articleRef ,articleQuant ,articlePU ,id ,id_prod,session ) VALUES( NOW() ,'$articleVendu' ,'$articleRef' ,'$articleQuant' ,'$articlePU' ,'$id' ,'$id_prod' ,'$pseudo' )";
-- Structure de la table 'articles' CREATE TABLE IF NOT EXISTS 'articles' ( 'id_art' int(11) NOT NULL AUTO_INCREMENT, 'dateArt' datetime NOT NULL, 'articleVendu' varchar(50) NOT NULL, 'articleRef' varchar(50) NOT NULL, 'articleQuant' varchar(50) NOT NULL, 'articlePU' varchar(50) NOT NULL, 'id' int(11) NOT NULL, 'id_prod' int(11) NOT NULL, 'session' varchar(150) NOT NULL, PRIMARY KEY ('id_art') ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=188 ; -- -- Contenu de la table 'articles' -- INSERT INTO 'articles' ('id_art', 'dateArt', 'articleVendu', 'articleRef', 'articleQuant', 'articlePU', 'id', 'id_prod', 'session') VALUES (187, '2014-06-13 09:52:49', '$articleVendu', '$articleRef', '$articleQuant', '$articlePU', 0, 0, '$pseudo'); COMMIT;
<?php $pseudo = isset($_SESSION['pseudo'])?$_SESSION['pseudo']:''; if (isset($_POST["submit"])) { $cat = strip_tags(trim($_POST['cat'])); //compter le nombre d'enregistrement $sql = ("SELECT * FROM tmp_articles WHERE session = '".$session."' order by id_art "); $q = mysql_query($sql) or die('Erreur SQL !<br>'.$sql.'<br>'.mysql_error()); $nbre = mysql_num_rows($q); if($nbre !=0){ for($i = 1; $i <= $nbre; $i++){ //declaration de variable $dateArt=trim($_POST["dateArt".$i]); $articleRef=trim($_POST["articleRef".$i]); $articleQuant=trim($_POST["articleQuant".$i]); $articlePU=trim($_POST["articlePU".$i]); //RECUPERATION DE L ID PRODUIT $id_pd = explode("/",$_POST["articleVendu".$i]); $id_prod = $id_pd[1]; $articleVendu = $id_pd[0]; // on fait l'INSERT dans la base de données $sql = "INSERT INTO articles ( dateArt ,articleVendu ,articleRef ,articleQuant ,articlePU ,id ,id_prod,session ) VALUES( NOW() ,'$articleVendu' ,'$articleRef' ,'$articleQuant' ,'$articlePU' ,'$id' ,'$id_prod' ,'$pseudo' )"; // >>>> ECHO DE LA REQUETE <<<<<< echo "<br><b> REQUETE : </b><br>".$sql."<br>"; // on insère les informations du formulaire dans la table $r = mysql_query($sql) or die('Erreur SQL !'.$sql.'<br>'.mysql_error()); print_r($r); }}} ?> <!--Force IE6 into quirks mode with this comment tag--> <!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]" lang="en" xml:lang="en"> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> <title>achat</title> </head> <body> <h1 style=" color:#400000">ARTICLES SAISIS</h1> <form action="" method="post"> <table width="960" border="0"> <tr> <td width="192">ARTICLES VENDUS</td> <td width="137"><span class="Style3">REFERENCE</span></td> <td width="148"><span class="Style3">QUANTITE</span></td> <td width="141"><span class="Style3">(PRIX U)</span></td> <td width="76"></td> <td width="80"></td> </tr> <?php $session = $_SESSION["pseudo"]; $sql = ("SELECT * FROM tmp_articles WHERE session = '".$session."' order by id_art "); $q = mysql_query($sql) or die('Erreur SQL !<br>'.$sql.'<br>'.mysql_error()); extract($_POST); while($rows = mysql_fetch_assoc($q)){ for($j = 1; $j<= $nbre; $j++); ?> <tr> <td><input name="articleVendu<?php echo $j; ?>" type="text" style="width:160px;background-color:#E5E5E5;" size="15" value="<?php echo $rows["articleVendu"]; ?>" /></td> <td><input type="text" style="width:100px;background-color:#E5E5E5; text-align:center" name="articleRef<?php echo $j; ?>" value="<?php echo $rows["articleRef"]; ?>" /></td> <td><input type="text" style="width:100px;background-color:#E5E5E5; text-align:center" name="articleQuant<?php echo $j; ?>" value="<?php echo $rows["articleQuant"]; ?>" /></td> <td><input type="text" style="width:100px;background-color:#E5E5E5; text-align:center " name="articlePU<?php echo $j; ?>" value="<?php echo $rows["articlePU"]; ?>" /></td> <td><input type="text" style="width:45px;background-color:#E5E5E5 ; text-align:center" name="id<?php echo $j; ?>" value="<?php echo $rows["id"]; ?>" /></td> <td><input type="text" style="width:45px;background-color:#E5E5E5; text-align:center " name="id_prod<?php echo $j; ?>" value="<?php echo $rows["id_prod"]; ?>" /></td> </tr> <?php }//} ?> </table> <table width="200" border="0" style="position:absolute; top:5px; left:500px; color:#400000"> <tr> <td> <?php $sql = "SELECT SUM(articleQuant * articlePU) AS leTotal FROM tmp_articles WHERE session = '".$session."' "; // on envoie la requête $req = mysql_query($sql) or die('Erreur SQL !<br>'.$sql.'<br>'.mysql_error()); while ($liste_etu=mysql_fetch_assoc($req)) { $leTotal = number_format($liste_etu["leTotal"], 0, ',', ' '); echo '<center> <table width="561" border="0"> <tr> <td width="238" style=" color:#400000">MONTANT TOTAL A PAYER </td> <td bgcolor="#CCCCCC" width="307"><input type="text" name="textfield" value = "'.$leTotal.'"/>F</td> </tr> </table></center>'; } ?> </td> </tr> </table> </div> </br></br> <h3><input type="submit" name="submit" id="submit" value="FACTURER" /></h3> </div> </div> </form> </body> </html>
// on fait l'INSERT dans la base de données $sql = "INSERT INTO articles ( dateArt ,articleVendu ,articleRef ,articleQuant ,articlePU ,id ,id_prod,session ) VALUES( NOW() ,'$articleVendu' ,'$articleRef' ,'$articleQuant' ,'$articlePU' ,'$id' ,'$id_prod' ,'$pseudo' )"; // >>>> ECHO DE LA REQUETE <<<<<< echo "<br>-----------------------------------------<br>"; echo "<br><b> REQUETE : </b><br>".$sql."<br>"; echo "-----------------------------------------<br>";
INSERT INTO 'articles' ('id_art', 'dateArt', 'articleVendu', 'articleRef', 'articleQuant', 'articlePU', 'id', 'id_prod', 'session') VALUES (187, '2014-06-13 09:52:49', '$articleVendu', '$articleRef', '$articleQuant', '$articlePU', 0, 0, '$pseudo'); COMMIT;
INSERT INTO articlesDONNE BIEN :
(
dateArt
,articleVendu
,articleRef
,articleQuant
,articlePU
,id
,id_prod,session
)
VALUES(
NOW()
,'FLAG'
,'1005'
,'50t'
,'250'
,'$id'
,'$id_prod'
,'MSI79'
)
<?php2.
$pseudo = isset($_SESSION['pseudo'])?$_SESSION['pseudo']:'';
if (isset($_POST["submit"])) {
?>
<!--Force IE6 into quirks mode with this comment tag-->
<!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" lang="en" xml:lang="en">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>achat</title>
</head>
<body>
<h1 style=" color:#400000">ARTICLES SAISIS</h1>
<form action="" method="post">
<table width="960" border="0">
<tr>
<td width="192">ARTICLES VENDUS</td>
<td width="137"><span class="Style3">REFERENCE</span></td>
<td width="148"><span class="Style3">QUANTITE</span></td>
<td width="141"><span class="Style3">(PRIX U)</span></td>
<td width="76"></td>
<td width="80"></td>
</tr>
<?php
$session = $_SESSION["pseudo"];
$sql = ("SELECT * FROM tmp_articles WHERE session = '".$session."' order by id_art ");
$q = mysql_query($sql) or die('Erreur SQL !<br>'.$sql.'<br>'.mysql_error());
extract($_POST);
while($rows = mysql_fetch_assoc($q)){
//declaration de variable
//$dateArt=trim($_POST["dateArt".$i]);
$articleRef=trim($_POST["articleRef"]);
$articleQuant=trim($_POST["articleQuant"]);
$articlePU=trim($_POST["articlePU"]);
//RECUPERATION DE L ID PRODUIT
$id_pd = explode("/",$_POST["articleVendu"]);
$id_prod = $id_pd[1];
$articleVendu = $id_pd[0];
// on fait l'INSERT dans la base de données
$sql = "INSERT INTO articles
(
dateArt
,articleVendu
,articleRef
,articleQuant
,articlePU
,id
,id_prod,session
)
VALUES(
NOW()
,'$articleVendu'
,'$articleRef'
,'$articleQuant'
,'$articlePU'
,'$id'
,'$id_prod'
,'$pseudo'
)";
// >>>> ECHO DE LA REQUETE <<<<<<
echo "<br>-----------------------------------------<br>";
echo "<br><b> REQUETE : </b><br>".$sql."<br>";
echo "-----------------------------------------<br>";
// on insère les informations du formulaire dans la table
$r = mysql_query($sql) or die('Erreur SQL !'.$sql.'<br>'.mysql_error());
print_r($r);
?>
<tr>
<td><input name="articleVendu" type="text" style="width:160px;background-color:#E5E5E5;" size="15" value="<?php echo $rows["articleVendu"]; ?>" /></td>
<td><input type="text" style="width:100px;background-color:#E5E5E5; text-align:center" name="articleRef" value="<?php echo $rows["articleRef"]; ?>" /></td>
<td><input type="text" style="width:100px;background-color:#E5E5E5; text-align:center" name="articleQuant" value="<?php echo $rows["articleQuant"]; ?>" /></td>
<td><input type="text" style="width:100px;background-color:#E5E5E5; text-align:center " name="articlePU" value="<?php echo $rows["articlePU"]; ?>" /></td>
<td><input type="text" style="width:45px;background-color:#E5E5E5 ; text-align:center" name="id" value="<?php echo $rows["id"]; ?>" /></td>
<td><input type="text" style="width:45px;background-color:#E5E5E5; text-align:center " name="id_prod" value="<?php echo $rows["id_prod"]; ?>" /></td>
</tr>
<?php
}}
?>
</table>
<table width="200" border="0" style="position:absolute; top:5px; left:500px; color:#400000">
<tr>
<td>
<?php
$sql = "SELECT SUM(articleQuant * articlePU) AS leTotal FROM tmp_articles WHERE session = '".$session."' ";
// on envoie la requête
$req = mysql_query($sql) or die('Erreur SQL !<br>'.$sql.'<br>'.mysql_error());
while ($liste_etu=mysql_fetch_assoc($req)) {
$leTotal = number_format($liste_etu["leTotal"], 0, ',', ' ');
echo '<center> <table width="561" border="0">
<tr>
<td width="238" style=" color:#400000">MONTANT TOTAL A PAYER </td>
<td bgcolor="#CCCCCC" width="307"><input type="text" name="textfield" value = "'.$leTotal.'"/>F</td>
</tr>
</table></center>';
}
?>
</td>
</tr>
</table>
</div>
</br></br>
<h3><input type="submit" name="submit" id="submit" value="FACTURER" /></h3>
</div>
</div>
</form>
</body>
</html>
// >>>> ECHO DE LA REQUETE <<<<<<
echo "<br>-----------------------------------------<br>";
echo "<br><b> REQUETE : </b><br>".$sql."<br>";
echo "-----------------------------------------<br>";
// on insère les informations du formulaire dans la table
$r = mysql_query($sql) or die('Erreur SQL !'.$sql.'<br>'.mysql_error());
print_r($r);
INSERT INTO articles ( dateArt ,articleVendu ,articleRef ,articleQuant ,articlePU ,id ,id_prod,session ) VALUES( NOW() ,'' ,'' ,'' ,'' ,'' ,'' ,'admin' )
$articleRef=trim($_POST["articleRef"]);
$articleRef=isset($_POST["articleRef"])?trim($_POST["articleRef"]):'error';
<?php //-------------------------------------------------------------- //RECUPERATION DES VARIABLES POST / SESSION ... //-------------------------------------------------------------- $pseudo = isset($_SESSION['pseudo'])?$_SESSION['pseudo']:''; //$dateArt=trim($_POST["dateArt".$i]); $articleRef=isset($_POST["articleRef"])?trim($_POST["articleRef"]):'error'; $articleQuant=isset($_POST["articleQuant"])?trim($_POST["articleQuant"]):'error'; $articlePU=isset($_POST["articlePU"])?trim($_POST["articlePU"]):'error'; //RECUPERATION DE L ID PRODUIT $artVendu = isset($_POST["articleVendu"])?$_POST["articleVendu"]:''; $id_pd = explode("/",$artVendu); $id_prod = $id_pd[1]; $articleVendu = $id_pd[0]; //-------------------------------------------------------------- // Debut du programme : //-------------------------------------------------------------- if (isset($_POST["submit"])) { ?> <!--Force IE6 into quirks mode with this comment tag--> <!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" lang="en" xml:lang="en"> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> <title>achat</title> </head> <body> <h1 style=" color:#400000">ARTICLES SAISIS</h1> <form action="" method="post"> <table width="960" border="0"> <tr> <td width="192">ARTICLES VENDUS</td> <td width="137"><span class="Style3">REFERENCE</span></td> <td width="148"><span class="Style3">QUANTITE</span></td> <td width="141"><span class="Style3">(PRIX U)</span></td> <td width="76"></td> <td width="80"></td> </tr> <?php $session = $_SESSION["pseudo"]; $sql = "SELECT * FROM tmp_articles WHERE session = '".$session."' order by id_art "; $q = mysql_query($sql) or die('Erreur SQL !<br>'.$sql.'<br>'.mysql_error()); //extract($_POST); while($rows = mysql_fetch_assoc($q)){ // on fait l'INSERT dans la base de données $sql = "INSERT INTO articles ( dateArt ,articleVendu ,articleRef ,articleQuant ,articlePU ,id ,id_prod,session ) VALUES( NOW() ,'".$rows["articleVendu"]."' ,'".$rows["articleRef"]."' ,'".$rows["articleQuant"]."' ,'".$rows["articlePU"]."' ,'".$rows["id"]."' ,'".$rows["id_prod"]."' ,'$pseudo' )"; // >>>> ECHO DE LA REQUETE <<<<<< echo "<br>-----------------------------------------<br>"; echo "<br><b> REQUETE : </b><br>".$sql."<br>"; echo "-----------------------------------------<br>"; // on insère les informations du formulaire dans la table $r = mysql_query($sql) or die('Erreur SQL !'.$sql.'<br>'.mysql_error()); ?> <tr> <td><input name="articleVendu" type="text" style="width:160px;background-color:#E5E5E5;" size="15" value="<?php echo $rows["articleVendu"]; ?>" /></td> <td><input type="text" style="width:100px;background-color:#E5E5E5; text-align:center" name="articleRef" value="<?php echo $rows["articleRef"]; ?>" /></td> <td><input type="text" style="width:100px;background-color:#E5E5E5; text-align:center" name="articleQuant" value="<?php echo $rows["articleQuant"]; ?>" /></td> <td><input type="text" style="width:100px;background-color:#E5E5E5; text-align:center " name="articlePU" value="<?php echo $rows["articlePU"]; ?>" /></td> <td><input type="text" style="width:45px;background-color:#E5E5E5 ; text-align:center" name="id" value="<?php echo $rows["id"]; ?>" /></td> <td><input type="text" style="width:45px;background-color:#E5E5E5; text-align:center " name="id_prod" value="<?php echo $rows["id_prod"]; ?>" /></td> </tr> <?php } // Fin de la boucle While }// Fin du IF ?> </table> <table width="200" border="0" style="position:absolute; top:5px; left:500px; color:#400000"> <tr> <td> <?php $sql = "SELECT SUM(articleQuant * articlePU) AS leTotal FROM tmp_articles WHERE session = '".$session."' "; // on envoie la requête $req = mysql_query($sql) or die('Erreur SQL !<br>'.$sql.'<br>'.mysql_error()); while ($liste_etu=mysql_fetch_assoc($req)) { $leTotal = number_format($liste_etu["leTotal"], 0, ',', ' '); echo '<center> <table width="561" border="0"> <tr> <td width="238" style=" color:#400000">MONTANT TOTAL A PAYER </td> <td bgcolor="#CCCCCC" width="307"><input type="text" name="textfield" value = "'.$leTotal.'"/>F</td> </tr> </table></center>'; } ?> </td> </tr> </table> </div> </br></br> <h3><input type="submit" name="submit" id="submit" value="FACTURER" /></h3> </div> </div> </form> </body> </html>
$sql = "INSERT INTO articles ( dateArt ,articleVendu ,articleRef ,articleQuant ,articlePU ,id ,id_prod,session ) VALUES( NOW() ,'".$rows["articleVendu"]."' ,'".$rows["articleRef"]."' ,'".$rows["articleQuant"]."' ,'".$rows["articlePU"]."' ,'".$rows["id"]."' ,'".$rows["id_prod"]."' ,'$pseudo' )"; // >>>> ECHO DE LA REQUETE <<<<<< echo "<br>-----------------------------------------<br>"; echo "<br><b> REQUETE : </b><br>".$sql."<br>"; echo "-----------------------------------------<br>";
<!--Force IE6 into quirks mode with this comment tag-->
<!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" lang="en" xml:lang="en">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>achat</title>
</head>
<body>
<h1 style=" color:#400000">ARTICLES SAISIS</h1>
<form action="" method="post">
<table width="960" border="0">
<tr>
<td width="192">ARTICLES VENDUS</td>
<td width="137"><span class="Style3">REFERENCE</span></td>
<td width="148"><span class="Style3">QUANTITE</span></td>
<td width="141"><span class="Style3">(PRIX U)</span></td>
<td width="76"></td>
<td width="80"></td>
</tr>
<?php
$pseudo = isset($_SESSION['pseudo'])?$_SESSION['pseudo']:'';
$sql = ("SELECT * FROM tmp_articles WHERE session = '".$session."' order by id_art ");
$q = mysql_query($sql) or die('Erreur SQL !<br>'.$sql.'<br>'.mysql_error());
while($rows = mysql_fetch_assoc($q)){
if (isset($_POST["submit"])) {
$sql = "INSERT INTO articles
(
dateArt
,articleVendu
,articleRef
,articleQuant
,articlePU
,id
,id_prod,session
)
VALUES(
NOW()
,'".$rows["articleVendu"]."'
,'".$rows["articleRef"]."'
,'".$rows["articleQuant"]."'
,'".$rows["articlePU"]."'
,'".$rows["id"]."'
,'".$rows["id_prod"]."'
,'$pseudo'
)";
// >>>> ECHO DE LA REQUETE <<<<<<
echo "<br>-----------------------------------------<br>";
echo "<br><b> REQUETE : </b><br>".$sql."<br>";
echo "-----------------------------------------<br>";
//on insère les informations du formulaire dans la table
$r = mysql_query($sql) or die('Erreur SQL !'.$sql.'<br>'.mysql_error());
print_r($r);
?>
<tr>
<td><input name="articleVendu" type="text" style="width:160px;background-color:#E5E5E5;" size="15" value="<?php echo $rows["articleVendu"]; ?>" /></td>
<td><input type="text" style="width:100px;background-color:#E5E5E5; text-align:center" name="articleRef" value="<?php echo $rows["articleRef"]; ?>" /></td>
<td><input type="text" style="width:100px;background-color:#E5E5E5; text-align:center" name="articleQuant" value="<?php echo $rows["articleQuant"]; ?>" /></td>
<td><input type="text" style="width:100px;background-color:#E5E5E5; text-align:center " name="articlePU" value="<?php echo $rows["articlePU"]; ?>" /></td>
<td><input type="text" style="width:45px;background-color:#E5E5E5 ; text-align:center" name="id" value="<?php echo $rows["id"]; ?>" /></td>
<td><input type="text" style="width:45px;background-color:#E5E5E5; text-align:center " name="id_prod" value="<?php echo $rows["id_prod"]; ?>" /></td>
</tr>
<?php
}}
?>
</table>
<table width="200" border="0" style="position:absolute; top:5px; left:500px; color:#400000">
<tr>
<td>
<?php
$sql = "SELECT SUM(articleQuant * articlePU) AS leTotal FROM tmp_articles WHERE session = '".$session."' ";
// on envoie la requête
$req = mysql_query($sql) or die('Erreur SQL !<br>'.$sql.'<br>'.mysql_error());
while ($liste_etu=mysql_fetch_assoc($req)) {
$leTotal = number_format($liste_etu["leTotal"], 0, ',', ' ');
echo '<center> <table width="561" border="0">
<tr>
<td width="238" style=" color:#400000">MONTANT TOTAL A PAYER </td>
<td bgcolor="#CCCCCC" width="307"><input type="text" name="textfield" value = "'.$leTotal.'"/>F</td>
</tr>
</table></center>';
}
?>
</td>
</tr>
</table>
</div>
</br></br>
<h3><input type="submit" name="submit" id="submit" value="FACTURER" /></h3>
</div>
</div>
</form>
</body>
</html>
<?php //-------------------------------------------------------------- //RECUPERATION DES VARIABLES POST / SESSION ... //-------------------------------------------------------------- $pseudo = isset($_SESSION['pseudo'])?$_SESSION['pseudo']:''; //$dateArt=trim($_POST["dateArt".$i]); $articleRef=isset($_POST["articleRef"])?trim($_POST["articleRef"]):'error'; $articleQuant=isset($_POST["articleQuant"])?trim($_POST["articleQuant"]):'error'; $articlePU=isset($_POST["articlePU"])?trim($_POST["articlePU"]):'error'; //RECUPERATION DE L ID PRODUIT $artVendu = isset($_POST["articleVendu"])?$_POST["articleVendu"]:''; $id_pd = explode("/",$artVendu); $id_prod = $id_pd[1]; $articleVendu = $id_pd[0];
<?php
if (isset($_POST["submit"])) {
$cat = strip_tags(trim($_POST['cat']));
//compter le nombre d'enregistrement
$session = isset($_SESSION["pseudo"])? $_SESSION["pseudo"]:'';
$sql = ("SELECT * FROM tmp_articles WHERE session = '".$session."' order by id_art ");
$sql = mysql_query($sql) or die('Erreur SQL !<br>'.$sql.'<br>'.mysql_error());
$nbre = mysql_num_rows($sql);
if($nbre !=0){
while($row = mysql_fetch_assoc($sql)){
$pseudo = isset($_SESSION['pseudo'])?$_SESSION['pseudo']:'';
$sql = "INSERT INTO articles
(
dateArt
,articleVendu
,articleRef
,articleQuant
,articlePU
,id
,id_prod,session
)
VALUES(
NOW()
,'".$row["articleVendu"]."'
,'".$row["articleRef"]."'
,'".$row["articleQuant"]."'
,'".$row["articlePU"]."'
,'".$row["id"]."'
,'".$row["id_prod"]."'
,'$pseudo'
)";
// >>>> ECHO DE LA REQUETE <<<<<<
echo "<br>-----------------------------------------<br>";
echo "<br><b> REQUETE : </b><br>".$sql."<br>";
echo "-----------------------------------------<br>";
// on insère les informations du formulaire dans la table
$r = mysql_query($sql) or die('Erreur SQL !'.$sql.'<br>'.mysql_error());
print_r($r);
}}}
?>
<!--Force IE6 into quirks mode with this comment tag-->
<!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" lang="en" xml:lang="en">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Dynamic Drive: CSS Top and Bottom Frames Layout</title>
</head>
<body>
<div id="framecontentTop">
<div class="innertube">
<h1 style=" color:#400000">ARTICLES SAISIS</h1>
<h3></h3>
</div>
</div>
<div id="maincontent">
<div class="innertube">
<form action="" method="post">
<table width="960" border="0">
<tr>
<td width="192">ARTICLES VENDUS</td>
<td width="137"><span class="Style3">REFERENCE</span></td>
<td width="148"><span class="Style3">QUANTITE</span></td>
<td width="141"><span class="Style3">(PRIX U)</span></td>
<td width="76"></td>
<td width="80"></td>
</tr>
<?php
$session = $_SESSION["pseudo"];
$sql = ("SELECT * FROM tmp_articles WHERE session = '".$session."' order by id_art ");
$q = mysql_query($sql) or die('Erreur SQL !<br>'.$sql.'<br>'.mysql_error());
while($rows = mysql_fetch_assoc($q)){
?>
<tr>
<td><input name="articleVendu<?php echo $j; ?>" type="text" style="width:160px;background-color:#E5E5E5;" size="15" value="<?php echo $rows["articleVendu"]; ?>" /></td>
<td><input type="text" style="width:100px;background-color:#E5E5E5; text-align:center" name="articleRef" value="<?php echo $rows["articleRef"]; ?>" /></td>
<td><input type="text" style="width:100px;background-color:#E5E5E5; text-align:center" name="articleQuant" value="<?php echo $rows["articleQuant"]; ?>" /></td>
<td><input type="text" style="width:100px;background-color:#E5E5E5; text-align:center " name="articlePU" value="<?php echo $rows["articlePU"]; ?>" /></td>
<td><input type="text" style="width:45px;background-color:#E5E5E5 ; text-align:center" name="id" value="<?php echo $rows["id"]; ?>" /></td>
<td><input type="text" style="width:45px;background-color:#E5E5E5; text-align:center " name="id_prod" value="<?php echo $rows["id_prod"]; ?>" /></td>
</tr>
<?php
}//}
?>
</table>
</div>
</div>
<div id="framecontentBottom">
<div class="innertube">
<div>
</br>
<table width="200" border="0" style="position:absolute; top:5px; left:500px; color:#400000">
<tr>
<td>
<?php
$sql = "SELECT SUM(articleQuant * articlePU) AS leTotal FROM tmp_articles WHERE session = '".$session."' ";
// on envoie la requête
$req = mysql_query($sql) or die('Erreur SQL !<br>'.$sql.'<br>'.mysql_error());
while ($liste_etu=mysql_fetch_assoc($req)) {
$leTotal = number_format($liste_etu["leTotal"], 0, ',', ' ');
echo '<center> <table width="561" border="0">
<tr>
<td width="238" style=" color:#400000">MONTANT TOTAL A PAYER </td>
<td bgcolor="#CCCCCC" width="307"><input type="text" name="textfield" value = "'.$leTotal.'"/>F</td>
</tr>
</table></center>';
}
?>
</td>
</tr>
</table>
</div>
</br></br>
<h3><input type="submit" name="submit" id="submit" value="FACTURER" /></h3>
</div>
</div>
</form>
</body>
</html>
$sql = ("SELECT * FROM tmp_articles WHERE session = '".$session."' order by id_art ");
<?php session_start(); //--------------------------------------------------------------- // RECUPERATION DES VARIABLES //--------------------------------------------------------------- // ici... Toutes les récup des variables de type POST / SESSION ...etc.. $pseudo = isset($_SESSION['pseudo'])?$_SESSION['pseudo']:''; $articleRef=isset($_POST["articleRef"])?trim($_POST["articleRef"]):'error'; $articleQuant=isset($_POST["articleQuant"])?trim($_POST["articleQuant"]):'error'; $articlePU=isset($_POST["articlePU"])?trim($_POST["articlePU"]):'error'; //RECUPERATION DE L ID PRODUIT $artVendu = isset($_POST["articleVendu"])?$_POST["articleVendu"]:''; $id_pd = explode("/",$artVendu); $id_prod = $id_pd[1]; $articleVendu = $id_pd[0]; //--------------------------------------------------------------- // Ensuite : Tous les traitements // a faire si ton/tes formulaires ont été "validés" //--------------------------------------------------------------- if (isset($_POST["submit"])){ // les actions à faire si ton formulaire a été envoyé... // Comme l'insert par exemple } //--------------------------------------------------------------- // Et enfin ..le reste de ton code // en général : l'affichage de la page... //---------------------------------------------------------------
$sql = ("SELECT * FROM tmp_articles WHERE session = '".$session."' order by id_art ");
$sql = ("SELECT * FROM tmp_articles WHERE session = '".$session."' order by id_art "); $sql = mysql_query($sql) or die('Erreur SQL !<br>'.$sql.'<br>'.mysql_error()); $nbre = mysql_num_rows($sql); echo "<br> Nombre de lignes : ".$nbre."<br>"; if($nbre !=0){ $r=0; while($row = mysql_fetch_assoc($sql)){ $r++; echo ">> Row => ".$r."<br>"; print_r($row); echo "<br>*************************<br>"; // Le reste de ton code
SELECT *
FROM tmp_articles
WHERE SESSION = 'admin'
ORDER BY id_art
echo ">> Row => ".$r."<br>";donne :
print_r($row);
echo "<br>*************************<br>";
<?php
if (isset($_POST["submit"])) {
//RECUPERATION DES DONNES DANS TMP_ARTICLE
$session = isset($_SESSION["pseudo"])? $_SESSION["pseudo"]:'';
$sql = ("SELECT * FROM tmp_articles WHERE session = '".$session."' order by id_art ");
$sql = mysql_query($sql) or die('Erreur SQL !<br>'.$sql.'<br>'.mysql_error());
$nbre = mysql_num_rows($sql);
echo "<br> Nombre de lignes : ".$nbre."<br>";
if($nbre !=0){
$r=0;
while($row = mysql_fetch_assoc($sql)){
$r++;
echo ">> Row => ".$r."<br>";
print_r($row);
echo "<br>*************************<br>";
// Le reste de ton code
//INSERTION DES VALEURS DANS LA TABLE ARTICLES
$sql = "INSERT INTO articles
(
dateArt
,articleVendu
,articleRef
,articleQuant
,articlePU
,id
,id_prod,session
)
VALUES(
NOW()
,'".$row["articleVendu"]."'
,'".$row["articleRef"]."'
,'".$row["articleQuant"]."'
,'".$row["articlePU"]."'
,'".$row["id"]."'
,'".$row["id_prod"]."'
,'$pseudo'
)";
// >>>> ECHO DE LA REQUETE <<<<<<
echo "<br>-----------------------------------------<br>";
echo "<br><b> REQUETE : </b><br>".$sql."<br>";
echo "-----------------------------------------<br>";
// EXECUTION DE LA REQUETE
$r = mysql_query($sql) or die('Erreur SQL !'.$sql.'<br>'.mysql_error());
print_r($r);
}}}
?>
<!--Force IE6 into quirks mode with this comment tag-->
<!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" lang="en" xml:lang="en">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Dynamic Drive: CSS Top and Bottom Frames Layout</title>
</head>
<body>
<div id="framecontentTop">
<div class="innertube">
<h1 style=" color:#400000">ARTICLES SAISIS</h1>
<h3></h3>
</div>
</div>
<div id="maincontent">
<div class="innertube">
<form action="" method="post">
<table width="960" border="0">
<tr>
<td width="192">ARTICLES VENDUS</td>
<td width="137"><span class="Style3">REFERENCE</span></td>
<td width="148"><span class="Style3">QUANTITE</span></td>
<td width="141"><span class="Style3">(PRIX U)</span></td>
<td width="76"></td>
<td width="80"></td>
</tr>
<?php
$session = $_SESSION["pseudo"];
$sql = ("SELECT *
FROM tmp_articles
WHERE session = '".$session."'
order by id_art ");
$q = mysql_query($sql) or die('Erreur SQL !<br>'.$sql.'<br>'.mysql_error());
while($rows = mysql_fetch_assoc($q)){
?>
<tr>
<td><input name="articleVendu<?php echo $j; ?>" type="text" style="width:160px;background-color:#E5E5E5;" size="15" value="<?php echo $rows["articleVendu"]; ?>" /></td>
<td><input type="text" style="width:100px;background-color:#E5E5E5; text-align:center" name="articleRef" value="<?php echo $rows["articleRef"]; ?>" /></td>
<td><input type="text" style="width:100px;background-color:#E5E5E5; text-align:center" name="articleQuant" value="<?php echo $rows["articleQuant"]; ?>" /></td>
<td><input type="text" style="width:100px;background-color:#E5E5E5; text-align:center " name="articlePU" value="<?php echo $rows["articlePU"]; ?>" /></td>
<td><input type="text" style="width:45px;background-color:#E5E5E5 ; text-align:center" name="id" value="<?php echo $rows["id"]; ?>" /></td>
<td><input type="text" style="width:45px;background-color:#E5E5E5; text-align:center " name="id_prod" value="<?php echo $rows["id_prod"]; ?>" /></td>
</tr>
<?php
}//}
?>
</table>
</div>
</div>
<div id="framecontentBottom">
<div class="innertube">
<div>
</br>
<table width="200" border="0" style="position:absolute; top:5px; left:500px; color:#400000">
<tr>
<td>
<?php
$sql = "SELECT SUM(articleQuant * articlePU) AS leTotal FROM tmp_articles WHERE session = '".$session."' ";
// on envoie la requête
$req = mysql_query($sql) or die('Erreur SQL !<br>'.$sql.'<br>'.mysql_error());
while ($liste_etu=mysql_fetch_assoc($req)) {
$leTotal = number_format($liste_etu["leTotal"], 0, ',', ' ');
echo '<center> <table width="561" border="0">
<tr>
<td width="238" style=" color:#400000">MONTANT TOTAL A PAYER </td>
<td bgcolor="#CCCCCC" width="307"><input type="text" name="textfield" value = "'.$leTotal.'"/>F</td>
</tr>
</table></center>';
}
?>
</td>
</tr>
</table>
</div>
</br></br>
<h3><input type="submit" name="submit" id="submit" value="FACTURER" /></h3>
</div>
</div>
</form>
</body>
</html>
// >>>> ECHO DE LA REQUETE <<<<<< echo "<br>-----------------------------------------<br>"; echo "<br><b> REQUETE : </b><br>".$sql."<br>"; echo "-----------------------------------------<br>";
<?php session_start(); //--------------------------------------------------------------- // RECUPERATION DES VARIABLES //--------------------------------------------------------------- // ici... Toutes les récup des variables de type POST / SESSION ...etc.. $session = isset($_SESSION["pseudo"])? $_SESSION["pseudo"]:''; $pseudo = isset($_SESSION['pseudo'])?$_SESSION['pseudo']:''; $articleRef=isset($_POST["articleRef"])?trim($_POST["articleRef"]):'error'; $articleQuant=isset($_POST["articleQuant"])?trim($_POST["articleQuant"]):'error'; $articlePU=isset($_POST["articlePU"])?trim($_POST["articlePU"]):'error'; //RECUPERATION DE L ID PRODUIT $artVendu = isset($_POST["articleVendu"])?$_POST["articleVendu"]:''; $id_pd = explode("/",$artVendu); $id_prod = $id_pd[1]; $articleVendu = $id_pd[0]; if (isset($_POST["submit"])) { //RECUPERATION DES DONNES DANS TMP_ARTICLE $sql = "SELECT * FROM tmp_articles WHERE session = '".$session."' order by id_art"; $req = mysql_query($sql) or die('Erreur SQL !<br>'.$sql.'<br>'.mysql_error()); $nbre = mysql_num_rows($req); echo "<br> Nombre de lignes : ".$nbre."<br>"; if($nbre !=0){ $r=0; while($row = mysql_fetch_assoc($req)){ $r++; echo ">> Row => ".$r."<br>"; print_r($row); echo "<br>*************************<br>"; //INSERTION DES VALEURS DANS LA TABLE ARTICLES $sql2 = "INSERT INTO articles ( dateArt ,articleVendu ,articleRef ,articleQuant ,articlePU ,id ,id_prod,session ) VALUES( NOW() ,'".$row["articleVendu"]."' ,'".$row["articleRef"]."' ,'".$row["articleQuant"]."' ,'".$row["articlePU"]."' ,'".$row["id"]."' ,'".$row["id_prod"]."' ,'$pseudo' )"; // >>>> ECHO DE LA REQUETE <<<<<< echo "<br>-----------------------------------------<br>"; echo "<br><b> REQUETE : </b><br>".$sql."<br>"; echo "-----------------------------------------<br>"; // EXECUTION DE LA REQUETE $r = mysql_query($sql2); if($r){ echo "<br><h2> Insertion OK</h2><br>"; }else{ echo "<br><h2> Insertion KO</h2><br>"; echo "<br><b> => Requête : </b><br>".$sql2."<br>"; echo " Error : ".mysql_error()."<br>"; } }// fin du While } // Fin du IF($nbre !=0) } //Fin du ID(isset($_POST["submit"])) ?> <!--Force IE6 into quirks mode with this comment tag--> <!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" lang="en" xml:lang="en"> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> <title>Dynamic Drive: CSS Top and Bottom Frames Layout</title> </head> <body> <div id="framecontentTop"> <div class="innertube"> <h1 style=" color:#400000">ARTICLES SAISIS</h1> <h3></h3> </div> </div> <div id="maincontent"> <div class="innertube"> <form action="" method="post"> <table width="960" border="0"> <tr> <td width="192">ARTICLES VENDUS</td> <td width="137"><span class="Style3">REFERENCE</span></td> <td width="148"><span class="Style3">QUANTITE</span></td> <td width="141"><span class="Style3">(PRIX U)</span></td> <td width="76"></td> <td width="80"></td> </tr> <?php $session = $_SESSION["pseudo"]; $sql = "SELECT * FROM tmp_articles WHERE session = '".$session."' order by id_art "; $q = mysql_query($sql) or die('Erreur SQL !<br>'.$sql.'<br>'.mysql_error()); while($rows = mysql_fetch_assoc($q)){ ?> <tr> <td><input name="articleVendu<?php echo $j; ?>" type="text" style="width:160px;background-color:#E5E5E5;" size="15" value="<?php echo $rows["articleVendu"]; ?>" /></td> <td><input type="text" style="width:100px;background-color:#E5E5E5; text-align:center" name="articleRef" value="<?php echo $rows["articleRef"]; ?>" /></td> <td><input type="text" style="width:100px;background-color:#E5E5E5; text-align:center" name="articleQuant" value="<?php echo $rows["articleQuant"]; ?>" /></td> <td><input type="text" style="width:100px;background-color:#E5E5E5; text-align:center " name="articlePU" value="<?php echo $rows["articlePU"]; ?>" /></td> <td><input type="text" style="width:45px;background-color:#E5E5E5 ; text-align:center" name="id" value="<?php echo $rows["id"]; ?>" /></td> <td><input type="text" style="width:45px;background-color:#E5E5E5; text-align:center " name="id_prod" value="<?php echo $rows["id_prod"]; ?>" /></td> </tr> <?php }//} ?> </table> </div> </div> <div id="framecontentBottom"> <div class="innertube"> <div> </br> <table width="200" border="0" style="position:absolute; top:5px; left:500px; color:#400000"> <tr> <td> <?php $sql = "SELECT SUM(articleQuant * articlePU) AS leTotal FROM tmp_articles WHERE session = '".$session."' "; // on envoie la requête $req = mysql_query($sql) or die('Erreur SQL !<br>'.$sql.'<br>'.mysql_error()); while ($liste_etu=mysql_fetch_assoc($req)) { $leTotal = number_format($liste_etu["leTotal"], 0, ',', ' '); echo '<center> <table width="561" border="0"> <tr> <td width="238" style=" color:#400000">MONTANT TOTAL A PAYER </td> <td bgcolor="#CCCCCC" width="307"><input type="text" name="textfield" value = "'.$leTotal.'"/>F</td> </tr> </table></center>'; } ?> </td> </tr> </table> </div> </br></br> <h3><input type="submit" name="submit" id="submit" value="FACTURER" /></h3> </div> </div> </form> </body> </html>
qu'allais-je devenir sans toiUn mec courageux qui aurait fini par trouver ^^
10 juin 2014 à 18:30
J'ai supprimé l'ancienne vu que tu l'avais créé sans être connecté.