{"id":67,"date":"2026-08-19T15:51:24","date_gmt":"2026-08-19T13:51:24","guid":{"rendered":"https:\/\/bellevue1.synology.me\/wordpress\/?page_id=67"},"modified":"2026-08-19T16:40:24","modified_gmt":"2026-08-19T14:40:24","slug":"plan-comptable","status":"publish","type":"page","link":"https:\/\/bellevue1.synology.me\/wordpress\/index.php\/plan-comptable\/","title":{"rendered":"cr\u00e9ation d&rsquo;un arbre"},"content":{"rendered":"\n<figure class=\"wp-block-embed\"><div class=\"wp-block-embed__wrapper\">\nhttps:\/\/plnkr.co\/edit\/?p=preview&#038;preview\n<\/div><\/figure>\n\n\n<p>[wpdatatable id=1]<\/p>\n\n\n\n<p>function afficher_mes_pdf() {<br>\/\/ 1. Connexion \u00e0 la base de donn\u00e9es externe<br>$id_base_externe = new wpdb(&lsquo;UTILISATEUR&rsquo;, &lsquo;MOT_DE_PASSE&rsquo;, &lsquo;NOM_DE_LA_BASE&rsquo;, &lsquo;ADRESSE_SERVEUR_IP&rsquo;);<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>\/\/ 2. Requ\u00eate SQL pour r\u00e9cup\u00e9rer vos 3000 documents\n$documents = $id_base_externe-&gt;get_results(\"SELECT nom, categorie, lien FROM ma_table_documents\");\n\n\/\/ 3. Construction du rendu en HTML (Arbre ou Liste)\n$html = '&lt;ul class=\"arbre-documents\"&gt;';\nforeach ($documents as $doc) {\n    $html .= '&lt;li&gt;\ud83d\udcc2 ' . esc_html($doc-&gt;categorie) . ' - &lt;a href=\"' . esc_url($doc-&gt;lien) . '\"&gt;\ud83d\udcc4 ' . esc_html($doc-&gt;nom) . '&lt;\/a&gt;&lt;\/li&gt;';\n}\n$html .= '&lt;\/ul&gt;';\n\nreturn $html;<\/code><\/pre>\n\n\n\n<p>}<br>\/\/ Cr\u00e9e un shortcode [mes_documents_pdf] \u00e0 coller sur votre page<br>add_shortcode(&lsquo;mes_documents_pdf&rsquo;, &lsquo;afficher_mes_pdf&rsquo;);<\/p>\n","protected":false},"excerpt":{"rendered":"<p>function afficher_mes_pdf() {\/\/ 1. Connexion \u00e0 la base de donn\u00e9es externe$id_base_externe = new wpdb(&lsquo;UTILISATEUR&rsquo;, &lsquo;MOT_DE_PASSE&rsquo;, &lsquo;NOM_DE_LA_BASE&rsquo;, &lsquo;ADRESSE_SERVEUR_IP&rsquo;); }\/\/ Cr\u00e9e un shortcode [mes_documents_pdf] \u00e0 coller sur votre pageadd_shortcode(&lsquo;mes_documents_pdf&rsquo;, &lsquo;afficher_mes_pdf&rsquo;);<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-67","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/bellevue1.synology.me\/wordpress\/index.php\/wp-json\/wp\/v2\/pages\/67","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/bellevue1.synology.me\/wordpress\/index.php\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/bellevue1.synology.me\/wordpress\/index.php\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/bellevue1.synology.me\/wordpress\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/bellevue1.synology.me\/wordpress\/index.php\/wp-json\/wp\/v2\/comments?post=67"}],"version-history":[{"count":3,"href":"https:\/\/bellevue1.synology.me\/wordpress\/index.php\/wp-json\/wp\/v2\/pages\/67\/revisions"}],"predecessor-version":[{"id":72,"href":"https:\/\/bellevue1.synology.me\/wordpress\/index.php\/wp-json\/wp\/v2\/pages\/67\/revisions\/72"}],"wp:attachment":[{"href":"https:\/\/bellevue1.synology.me\/wordpress\/index.php\/wp-json\/wp\/v2\/media?parent=67"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}