$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'];
