session_start(); //ID_caddie //session_id //CodeProduit //Echelle //Type //Fabricant //Marque //Description //total_HT //total_TTC //qte //datemax $table_caddie="commandes_caddies"; $auth="abng"; $auth="abng"; $id_session = session_id(); include ("mainfile.php"); dbconnect(); $max_date_timeout_fin = date("U")+172800; $date_now__ = date("U"); mysql_query("delete from $table_caddie where datemax<'$date_now__'"); if ($choix=="del") { mysql_query("delete from $table_caddie where session_id='$id_session' AND Echelle='$Echelle' AND Type='$Type' AND Fabricant='$Fabricant' AND Marque='$Marque' AND CodeProduit='$CodeProduit'"); } else if ($choix=="update") { if ($subsub=="add") { mysql_query("update $table_caddie set qte=qte+1 where session_id='$id_session' AND Echelle='$Echelle' AND Type='$Type' AND Fabricant='$Fabricant' AND Marque='$Marque' AND CodeProduit='$CodeProduit'"); } else { mysql_query("update $table_caddie set qte=qte=qte-1 where session_id='$id_session' AND Echelle='$Echelle' AND Type='$Type' AND Fabricant='$Fabricant' AND Marque='$Marque' AND CodeProduit='$CodeProduit'"); } } else if ($choix=="add") { $test_deja_la=mysql_query("select * from $table_caddie where session_id='$id_session' AND Echelle='$Echelle' AND Type='$Type' AND Fabricant='$Fabricant' AND Marque='$Marque' AND CodeProduit='$CodeProduit'"); if (mysql_num_rows($test_deja_la)>0) { mysql_query("update $table_caddie set qte=qte+1 where session_id='$id_session' AND Echelle='$Echelle' AND Type='$Type' AND Fabricant='$Fabricant' AND Marque='$Marque' AND CodeProduit='$CodeProduit'"); } else { mysql_query("insert into $table_caddie values('','$id_session','$CodeProduit','$Echelle','$Type','$Fabricant','$Marque','$Description','$total_HT','$total_TTC','1','$max_date_timeout_fin')"); } } if ($choix=="sub") { mysql_query("update $table_caddie set qte=qte-1 where session_id='$id_session' AND Echelle='$Echelle' AND Type='$Type' AND Fabricant='$Fabricant' AND Marque='$Marque' AND CodeProduit='$CodeProduit'"); } if ($choix=="update") { mysql_query("update $table_caddie set qte='$qte' where session_id='$id_session' AND CodeProduit='$ref'"); } ?> $recup_all=mysql_query("select CodeProduit, Echelle, Type, Fabricant, Marque, Description, total_HT, total_TTC, qte from $table_caddie where session_id='$id_session'"); $maxing = mysql_num_rows($recup_all); if (mysql_num_rows($recup_all)>0) { ?>
![]() Votre
caddie : |
| } else { ?> } ?> |