query('SELECT id_maj, date_maj FROM maj ORDER BY id_maj DESC LIMIT 1'); $result = $stmt->fetchObject(); $majmax = $result->id_maj; $lastupdate = $result->date_maj; $newsStmt = $dbconn->query('SELECT * FROM news WHERE actif = 1 ORDER BY date DESC'); $js = ''; $nav = ''; ?>

fetchObject()) { if ($news->libelle_en != null) { $libelle = str_replace('&', '&', $news->libelle_en); $libelle = stripslashes($libelle); $libelle = str_replace('BORDER="2">', 'ALT="" BORDER="2">', $libelle); ?> : date)) ?>

query( 'SELECT ref_disque, f.featured_category_id, category_name_en FROM featured f INNER JOIN featured_categories fc ON f.featured_category_id = fc.featured_category_id WHERE fc.active = 1 ORDER BY f.featured_category_id, f.numero ASC' ); $currentCat = 0; $groupesStmt = $dbconn->prepare( 'SELECT nom, groupe.id_groupe AS id_groupe FROM disque_groupe LEFT JOIN groupe ON disque_groupe.id_groupe = groupe.id_groupe WHERE disque_groupe.ref_disque = :ref_disque' ); $groupesStmt->bindParam(':ref_disque', $ref_disque, PDO::PARAM_INT); $labelsStmt = $dbconn->prepare( 'SELECT nom, label.id_label AS id_label FROM disque_label LEFT JOIN label ON disque_label.id_label = label.id_label WHERE disque_label.ref_disque = :ref_disque' ); $labelsStmt->bindParam(':ref_disque', $ref_disque, PDO::PARAM_INT); $disquesStmt = $dbconn->prepare( 'SELECT commentaire, disc_qty, enstock, epuise, id_maj, pochette, prix, promo, release_date, support, titre FROM disque WHERE ref_disque = :ref_disque' ); $disquesStmt->bindParam(':ref_disque', $ref_disque, PDO::PARAM_INT); while ($feat = $featStmt->fetchObject()) { $ref_disque = $feat->ref_disque; $groupesStmt->execute(); $groupes = []; while ($resultGroupes = $groupesStmt->fetchObject()) { if (in_array($resultGroupes->nom, ['VARIOUS', 'V/A'])) { $groupes[] = $resultGroupes->nom; } else { $groupes[] = '' . $resultGroupes->nom . ''; } } $groupes = implode('/', $groupes); $labelsStmt->execute(); $labels = []; while ($resultLabels = $labelsStmt->fetchObject()) { if (!in_array($resultLabels->nom, ['SANSLABEL', 'DIVERS/MISC'])) { $labels[] = '' . $resultLabels->nom . ' '; } } $affichelabs = implode('/', $labels); $disquesStmt->execute(); while ($disquesResult = $disquesStmt->fetchObject()) { $titre = stripSlashes($disquesResult->titre); if ($disquesResult->pochette != '') { $pochette = ''; } else { $ItemNr = '00' . substr("00000000" . $ref_disque, -6); $prodImagesDir = isset($_ENV['PROD_IMAGES_DIR']) ? $_ENV['PROD_IMAGES_DIR'] : ''; $imgName = "images/prod/I" . substr($ItemNr, 0, 2) . "/" . substr( $ItemNr, 2, 3 ) . "/" . $ItemNr . ".jpg"; if (file_exists($prodImagesDir . $imgName)) { $pochette = ''; } else { $pochette = ' '; } } if ($disquesResult->id_maj == $majmax) { $affichenew = ' ' . $captNew . ''; } else { $affichenew = ''; } if ($disquesResult->promo == 1) { $affichepromo = '' . $captCataPromo . ''; } else { $affichepromo = ''; } if ($disquesResult->enstock == 1) { $dispo = '' . $captEnstock . ''; $btn = ''; } elseif ($disquesResult->epuise == 0) { $dispo = '' . $capt23sem . ''; $btn = ''; } else { $dispo = ''; $btn = ''; } $commentaire = $disquesResult->commentaire; if (strlen($commentaire) < 350) { $commentaire = htmlspecialchars(stripSlashes($commentaire)) . ' '; } else { $commentaire = htmlspecialchars(substr(stripSlashes($commentaire), 0, 346)) . ' ... ' . $captHomeSuite . ' '; $nb_b = substr_count($commentaire, ""); $nb_slash_b = substr_count($commentaire, ""); if ($nb_b > $nb_slash_b) { $commentaire .= ''; } } if (isset($cookieSet)) { $affichePrix = '' . $captCataPrix . ' : ' . formatPrix( $disquesResult->prix ) . ''; } else { $affichePrix = '[' . $captLogin . ']'; } if ($feat->featured_category_id != $currentCat) { if ($currentCat > 0) { echo '

'; $js .= 'document.getElementById("selection-' . $feat->featured_category_id . '").style.display="none";' . PHP_EOL; } $theCategoryName = $feat->category_name_en; echo ''; // create navigation to load record selections $nav = $nav . '' . $theCategoryName . ''; $currentCat = $feat->featured_category_id; } ?>

(support ) ?>) disc_qty ?> release_date ?> : support) ?>

0) { ?>