D
derkomai
ex membre
Bonjour à tous ...
Voilà mon problème, je fais une gestion de caddie, jusqu'içi tout va bien mais lorque le client désire voir son caddie, tout s'affiche correctement. J'ai placer des checkbox pour permettre au client de supprimer des article de son caddie et j'ai employer php pour permettre de deleeter dans ma table l'article à enlever qui aura été choisit grace à la checkbox. Mais l'article ne se supprime jamais.
Voici mon code :
<html>
<head>
<title>Caddies</title>
</head>
<body bgcolor="#FFFFFF" text="#000000">
<table width="950" border="0" align="center" cellspacing="1" cellpadding="3" bordercolor="#0099CC">
<tr>
<td>
<form name="form2" method="post" action="index.php?page=cad">
<table width="100%" border="1" align="center" cellspacing="0" cellpadding="3">
<tr bgcolor="#F0F0F0" bordercolor="#FFFFFF">
<td width="3%"><center><b>N°</b></center></td>
<td width="11%"><div align="center"><strong>sku</strong></div></td>
<td width="30%"><div align="center"><strong>Marque</strong></div></td>
<td width="50%"><div align="center"><strong>Description</strong></div></td>
<td width="6%"><div align="center"><strongrice</strong></div></td>
</tr>
<?php
$database="base";
$hostname="";
$dbusername="root";
$dbpassword="";
$connect=mysql_connect($hostname,$dbusername,$dbpassword);
$dbselect=mysql_select_db($database);
$serialcount=0;
$query="select sku from neworder where user_id='".$user_id."'";
$result=mysql_query($query);
$carttotal=0;
while($row=mysql_fetch_array($result)) {
//Mise à jour du contenu du caddie.
if (isset($$row["sku"])) {
if ($$row["sku"]==1) {
$deletequery="delete from neworder where sku=".$row["sku"];
$deleteresult= mysql_query($deletequery);
}
}
}
//Affichage des détails sur les articles sélectionnés
$query="select * from neworder where user_id='".$user_id."'";
$result=mysql_query($query);
while($row=mysql_fetch_array($result)) {
$proquery="select * from produit where sku='".$row["sku"]."'";
$proresult=mysql_query($proquery);
if($pro=mysql_fetch_array($proresult)) {
echo "<tr bordercolor=\"#FFFFFF\" bgcolor=\"#DEDFD7\"> ";
echo " <td > ";
echo " <left><font size=\"2\">" . ++$serialcount . "</font></center> ";
echo " </td> ";
echo " <td ><left><font size=\"2\">".$pro["sku"]."</font></center></td> ";
echo " <td> ";
echo " <left><font size=\"2\">".$pro["vendor"] . "</font></center> ";
echo " </td> ";
echo " <td> ";
echo " <left><font size=\"2\">".$pro["description"] . "</font></center> ";
echo " </td> ";
echo " <td> ";
echo " <div align=\"right\"><font size=\"2\">".$row["price"]." €</div></font>";
echo " </td>";
echo " <td> ";
echo " <center> ";
echo " <input type=\"checkbox\" name=\"".$pro["sku"]."\" value=\"1\">Cancel";
echo " </center> ";
echo " </td>";
echo "</tr> ";
$carttotal+=$row["price"];
}
}
echo "<tr bordercolor=\"#FFFFFF\"> ";
echo " <td colspan=\"3\"></td>";
echo " <td ><div align=\"right\"><b>Total</b></div></td> ";
echo " <td > ";
echo " <div align=\"right\"><b>".$carttotal." €</b></div> ";
echo " </td> ";
echo "</tr> ";
?>
<tr bordercolor="#FFFFFF">
<td colspan="7" >
<div align="right">
<input type="submit" name="Submit" value="Make Changes">
</div>
</td>
</tr>
</table>
</form>
</td>
</tr>
</table>
<?php
echo " <center><a href=\"confirmorder.php?user_id=".$user_id."\"><h2>Confirm Order</a></h2></center>";
?>
</body>
</html>
merci d'avance
Voilà mon problème, je fais une gestion de caddie, jusqu'içi tout va bien mais lorque le client désire voir son caddie, tout s'affiche correctement. J'ai placer des checkbox pour permettre au client de supprimer des article de son caddie et j'ai employer php pour permettre de deleeter dans ma table l'article à enlever qui aura été choisit grace à la checkbox. Mais l'article ne se supprime jamais.
Voici mon code :
<html>
<head>
<title>Caddies</title>
</head>
<body bgcolor="#FFFFFF" text="#000000">
<table width="950" border="0" align="center" cellspacing="1" cellpadding="3" bordercolor="#0099CC">
<tr>
<td>
<form name="form2" method="post" action="index.php?page=cad">
<table width="100%" border="1" align="center" cellspacing="0" cellpadding="3">
<tr bgcolor="#F0F0F0" bordercolor="#FFFFFF">
<td width="3%"><center><b>N°</b></center></td>
<td width="11%"><div align="center"><strong>sku</strong></div></td>
<td width="30%"><div align="center"><strong>Marque</strong></div></td>
<td width="50%"><div align="center"><strong>Description</strong></div></td>
<td width="6%"><div align="center"><strongrice</strong></div></td>
</tr>
<?php
$database="base";
$hostname="";
$dbusername="root";
$dbpassword="";
$connect=mysql_connect($hostname,$dbusername,$dbpassword);
$dbselect=mysql_select_db($database);
$serialcount=0;
$query="select sku from neworder where user_id='".$user_id."'";
$result=mysql_query($query);
$carttotal=0;
while($row=mysql_fetch_array($result)) {
//Mise à jour du contenu du caddie.
if (isset($$row["sku"])) {
if ($$row["sku"]==1) {
$deletequery="delete from neworder where sku=".$row["sku"];
$deleteresult= mysql_query($deletequery);
}
}
}
//Affichage des détails sur les articles sélectionnés
$query="select * from neworder where user_id='".$user_id."'";
$result=mysql_query($query);
while($row=mysql_fetch_array($result)) {
$proquery="select * from produit where sku='".$row["sku"]."'";
$proresult=mysql_query($proquery);
if($pro=mysql_fetch_array($proresult)) {
echo "<tr bordercolor=\"#FFFFFF\" bgcolor=\"#DEDFD7\"> ";
echo " <td > ";
echo " <left><font size=\"2\">" . ++$serialcount . "</font></center> ";
echo " </td> ";
echo " <td ><left><font size=\"2\">".$pro["sku"]."</font></center></td> ";
echo " <td> ";
echo " <left><font size=\"2\">".$pro["vendor"] . "</font></center> ";
echo " </td> ";
echo " <td> ";
echo " <left><font size=\"2\">".$pro["description"] . "</font></center> ";
echo " </td> ";
echo " <td> ";
echo " <div align=\"right\"><font size=\"2\">".$row["price"]." €</div></font>";
echo " </td>";
echo " <td> ";
echo " <center> ";
echo " <input type=\"checkbox\" name=\"".$pro["sku"]."\" value=\"1\">Cancel";
echo " </center> ";
echo " </td>";
echo "</tr> ";
$carttotal+=$row["price"];
}
}
echo "<tr bordercolor=\"#FFFFFF\"> ";
echo " <td colspan=\"3\"></td>";
echo " <td ><div align=\"right\"><b>Total</b></div></td> ";
echo " <td > ";
echo " <div align=\"right\"><b>".$carttotal." €</b></div> ";
echo " </td> ";
echo "</tr> ";
?>
<tr bordercolor="#FFFFFF">
<td colspan="7" >
<div align="right">
<input type="submit" name="Submit" value="Make Changes">
</div>
</td>
</tr>
</table>
</form>
</td>
</tr>
</table>
<?php
echo " <center><a href=\"confirmorder.php?user_id=".$user_id."\"><h2>Confirm Order</a></h2></center>";
?>
</body>
</html>
merci d'avance