{"id":1,"date":"2022-11-04T09:57:28","date_gmt":"2022-11-04T08:57:28","guid":{"rendered":"https:\/\/jeselectionne.com\/?p=1"},"modified":"2024-10-10T22:51:31","modified_gmt":"2024-10-10T20:51:31","slug":"bonjour-tout-le-monde","status":"publish","type":"post","link":"https:\/\/jeselectionne.com\/?p=1","title":{"rendered":"Votre guide des meilleurs produits de l&rsquo;ann\u00e9e"},"content":{"rendered":"\n<p>D\u00e9couvrez notre s\u00e9lection des produits incontournables du march\u00e9 pour vous.<\/p>\n\n<?php\nfunction afficher_tableau_produits() {\n    global $wpdb; \/\/ Utilisation de l'API WordPress pour la base de donn\u00e9es\n\n    \/\/ Requ\u00eate SQL pour r\u00e9cup\u00e9rer les produits\n    $resultats = $wpdb->get_results(\u00a0\u00bb\n        SELECT nom_produit, marque, prix, consommation_energetique, niveau_sonore, duree_garantie, option_reparation\n        FROM wp_products\n    \u00ab\u00a0);\n\n    \/\/ Construction du tableau\n    ob_start(); \/\/ Capture le contenu HTML pour l&rsquo;afficher plus tard\n    ?>\n    <table>\n        <thead>\n            <tr>\n                <th>Produit<\/th>\n                <th>Marque<\/th>\n                <th>Prix (\u20ac)<\/th>\n                <th>Consommation \u00c9nerg\u00e9tique (kWh\/an)<\/th>\n                <th>Niveau Sonore (dB)<\/th>\n                <th>Dur\u00e9e de Garantie (ann\u00e9es)<\/th>\n                <th>R\u00e9parable<\/th>\n            <\/tr>\n        <\/thead>\n        <tbody>\n            <?php if ($resultats): ?>\n                <?php foreach ($resultats as $produit): ?>\n                    <tr>\n                        <td><?php echo esc_html($produit->nom_produit); ?><\/td>\n                        <td><?php echo esc_html($produit->marque); ?><\/td>\n                        <td><?php echo esc_html($produit->prix); ?><\/td>\n                        <td><?php echo esc_html($produit->consommation_energetique); ?><\/td>\n                        <td><?php echo esc_html($produit->niveau_sonore); ?><\/td>\n                        <td><?php echo esc_html($produit->duree_garantie); ?><\/td>\n                        <td><?php echo $produit->option_reparation ? &lsquo;Oui&rsquo; : &lsquo;Non&rsquo;; ?><\/td>\n                    <\/tr>\n                <?php endforeach; ?>\n            <?php else: ?>\n                <tr><td colspan=\"7\">Aucun produit trouv\u00e9<\/td><\/tr>\n            <?php endif; ?>\n        <\/tbody>\n    <\/table>\n    <?php\n    return ob_get_clean(); \/\/ Retourne le contenu captur\u00e9\n}\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>D\u00e9couvrez notre s\u00e9lection des produits incontournables du march\u00e9 pour vous.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-1","post","type-post","status-publish","format-standard","hentry","category-non-classe"],"_links":{"self":[{"href":"https:\/\/jeselectionne.com\/index.php?rest_route=\/wp\/v2\/posts\/1"}],"collection":[{"href":"https:\/\/jeselectionne.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jeselectionne.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jeselectionne.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/jeselectionne.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1"}],"version-history":[{"count":3,"href":"https:\/\/jeselectionne.com\/index.php?rest_route=\/wp\/v2\/posts\/1\/revisions"}],"predecessor-version":[{"id":48,"href":"https:\/\/jeselectionne.com\/index.php?rest_route=\/wp\/v2\/posts\/1\/revisions\/48"}],"wp:attachment":[{"href":"https:\/\/jeselectionne.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jeselectionne.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jeselectionne.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}