$css_class = $i % 2 == 0 ? 'clair' : 'sombre'; echo '<tr class="' . $css_class . '">'; foreach ($ligne as $indice => $information) { echo "<td>" . $information . "</td>"; } $i++; echo '<td><a href="?action=modification&id_promo=' . $ligne['id_promo'] . '"><img src="' . RACINE_SITE . 'photo/modif.png" alt="" title="Modifier la fiche de la promotion"></a></td>'; echo '<td><a href="?action=suppression&id_promo=' . $ligne['id_promo'] . '" OnClick="return(confirm(\'En êtes vous certain ?\'));"><img src="' . RACINE_SITE . 'photo/suppr.png" alt="" title="Supprimer ce commentaire"></a></td>'; echo '</tr>'; } echo '</table>'; echo "</div>"; } if (isset($_GET['action']) && ($_GET['action'] == 'ajout' || $_GET['action'] == 'modification')) { if (isset($_GET['id_promo'])) { $resultat = informationSurUnePromotion($_GET['id_promo']); $promotion_actuel = $resultat->fetch_assoc(); //print_r($promotion_actuel); } ?> <div id="prom_form"> <div style="padding: 10px;" id="div_promForm"> <form method="post" action=""> <label for="id_promo" class="gras">Id_promo</label> <input type="text" id="id_promo" name="id_promo" value="<?php if (isset($promotion_actuel['id_promo'])) { echo $promotion_actuel['id_promo']; } elseif (isset($_POST['id_promo'])) { echo $_POST['id_promo']; }
echo "<a href='?categorie={$categories['categorie']}' class='cat_design'>"; echo "<div class='image_cat' style='background-image:url({$photo['photo']})'></div>"; echo '<div class="titre_cat">' . $categories['categorie'] . '</div>'; echo '</a>'; } } if ($_GET['categorie'] != 'all') { $donnees2 = executeRequete("SELECT ar.id_article, note, categorie, titre, prix, photo, id_promo FROM article ar LEFT JOIN avis av ON ar.id_article = av.id_article WHERE categorie = '{$_GET['categorie']}' GROUP BY ar.id_article "); // $recupCategories = executeRequete("SELECT categorie FROM article GROUP BY categorie "); // $recupMarques = executeRequete("SELECT marque FROM article GROUP BY marque "); // Affichage de tous les articles de la catégorie: // Header dynamique en fonction de la catégorie: echo "<div id='header_categorie'><img src=' " . RACINE_SITE . "photo/{$_GET['categorie']}.jpg' alt='{$_GET['categorie']}' title='Bandeau catégorie {$_GET['categorie']}' /></div>"; echo '<a href="categories.php?categorie=all"> < Retour aux catégories </a>'; while ($article = $donnees2->fetch_assoc()) { $recup_promo = informationSurUnePromotion($article['id_article']); $promotion = $recup_promo->fetch_assoc(); $calcul_note = executeRequete("SELECT ROUND(AVG(note)*2)/2 AS moyenne FROM avis WHERE id_article = {$article['id_article']}"); $note_final = $calcul_note->fetch_assoc(); echo '<div class="articleCat">'; echo '<div class="note">'; imageNotation($note_final['moyenne']); echo '</div>'; if ($article['id_promo'] == 1) { echo '<div class="fond_prixCat">'; echo "<p>{$article['prix']} €</p>"; echo '</div>'; } else { echo '<div class="fond_prixPromoCat">'; echo "<p><span class='old_price'>{$article['prix']}€ </span> " . prixAvecPromo($article['id_article']) . "€</p>"; echo '</div>';
<?php require_once 'inc/init.inc.php'; require_once 'inc/haut_de_site.inc.php'; #---------- AJOUT AU PANIER ------------------ //Ajout des articles au panier : creationDuPanier(); if (isset($_POST['ajout_panier'])) { $result = informationSurUnArticle($_POST['id_article']); $result_promo = informationSurUnePromotion($_POST['id_article']); $article = $result->fetch_assoc(); $promo = $result_promo->fetch_assoc(); ajouterArticleDansPanier($article['id_article'], $article['titre'], $article['photo'], $article['prix'], $_POST['quantite'], $promo['id_promo'], $promo['reduction']); header('location: panier.php'); } #----------DEBUT VIDER LE PANIER---------- if (isset($_GET['action']) && $_GET['action'] == 'vider') { unset($_SESSION['panier']); header('location: panier.php'); exit; } #----------DEBUT RETIRER ARTICLE DU PANIER---------- if (isset($_GET['action']) && $_GET['action'] == 'retirer') { retirerArticleDuPanier($_GET['id_article']); header("location:panier.php"); exit; } #----------VERIFICATION CODE PROMO---------- if (isset($_POST['validation_codePromo'])) { for ($i = 0; $i < count($_SESSION['panier']['id_article']); $i++) { $query = executeRequete("SELECT * FROM article ar, promotion prom WHERE prom.id_promo = ar.id_promo AND '{$_POST['code_promoPanier']}' = prom.code_promo AND '" . $_SESSION['panier']['id_article'][$i] . "' = ar.id_article");
if (isset($_POST['envoyer'])) { if ($_POST['note'] <= 0 || $_POST['note'] > 5 || empty($_POST['sujet']) || empty($_POST['commentaire'])) { $msg .= '<p id="erreur">Veuillez remplir tous les champs et choisir une note valide.</p>'; } else { $sujet = $mysqli->real_escape_string($_POST['sujet']); $commentaire = $mysqli->real_escape_string($_POST['commentaire']); $note = $_POST['note']; executeRequete("INSERT INTO avis (id_membre,id_article,sujet,commentaire,note,date) VALUES ('" . $_SESSION['utilisateur']['id_membre'] . "','{$_GET['id_article']}','{$sujet}','{$commentaire}','{$note}',NOW())"); header('location:' . $url); } } if (isset($_GET['id_article'])) { $resultat = informationSurUnArticle($_GET['id_article']); } if (isset($_GET['id_article'])) { $resultat2 = informationSurUnePromotion($_GET['id_article']); } if ($resultat->num_rows <= 0) { header("location:shop.php"); exit; } $article = $resultat->fetch_assoc(); $promo = $resultat2->fetch_assoc(); $donnees = executeRequete("SELECT note FROM article ar LEFT JOIN avis av ON ar.id_article = av.id_article AND ar.id_article = '{$article['id_article']}'"); $recupNote = $donnees->fetch_assoc(); $donnees2 = executeRequete("SELECT ar.id_article, titre, photo, prix, note, categorie,sous_categorie, stock, id_promo FROM article ar LEFT JOIN avis av ON ar.id_article = av.id_article WHERE ar.id_article != '{$_GET['id_article']}' AND sous_categorie = '{$article['sous_categorie']}' GROUP BY ar.id_article LIMIT 4"); $calcul_note = executeRequete("SELECT ROUND(AVG(note)*2)/2 AS moyenne FROM avis WHERE id_article = {$_GET['id_article']}"); $note_final = $calcul_note->fetch_assoc(); $historique_message = executeRequete("SELECT * FROM avis WHERE id_article= '{$_GET['id_article']}'"); // Redirection du formulaire : $pageArticleEnCours = $_GET['id_article'];