{"id":1456,"date":"2019-10-24T18:50:00","date_gmt":"2019-10-24T16:50:00","guid":{"rendered":""},"modified":"2020-05-12T21:00:02","modified_gmt":"2020-05-12T19:00:02","slug":"embed-database-data-in-odt-file","status":"publish","type":"post","link":"https:\/\/digitalia.culturanuova.net\/blog\/?p=1456","title":{"rendered":"embed database data in odt file"},"content":{"rendered":"<div class=\"js-editable-content\">\n<h3>\n&nbsp;the problem<\/h3>\n<p>In odt it is possible to insert some database data as fields in a odt file, but when you change data in phpmyadmin I get <br \/>\n1) a <b>correct<\/b> update in the <b>data source<\/b> view above the text, <br \/>\n2) <b>not<\/b> in the odt file (<b>body<\/b>: where<br \/>\nare the fields): the fields texts remain unchanged, even after doing the<br \/>\n command &#8220;update fields&#8221; (both from menu and from keyboard: F9, or<br \/>\nshift+ctrl+F9). <\/p>\n<h3>\na solution <\/h3>\n<p>A workaround is to use insert &#8211; section to insert a part of a php file via localhost.<\/p>\n<ol>\n<li style=\"background-color: transparent; clear: left; float: left; margin-bottom: 1em; margin-right: 1em;\">you will see in your odt file the content of the (section=div, of the) php file, as in the picture following: <br \/> <img loading=\"lazy\" decoding=\"async\" alt=\"image description\" height=\"181\" src=\"https:\/\/ask.libreoffice.org\/upfiles\/15719305832413627.png\" style=\"height: auto; max-width: 685px;\" width=\"400\" \/><\/li>\n<li>insert -&gt; section -&gt; link -&gt; file name &#8220;<a href=\"http:\/\/localhost\/[path]\/[filename].php\">http:\/\/localhost\/[path]\/[filename].php<\/a>&#8221; -&gt; section (the &#8220;id&#8221; name you have chosen in php file, i.g. inserting a &lt;div id=&#8221;biblio&#8221;&gt;[php\/mysql code]&lt;\/div&gt; the section name will &#8220;biblio&#8221;)<\/li>\n<\/ol>\n<p>Of course, you must previously  <\/p>\n<ul>\n<li>activate a php\/mysql server in local <\/li>\n<li style=\"background-color: transparent;\">and possibly have some knowledge of html\/php source code.<\/li>\n<\/ul>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>&nbsp;the problem In odt it is possible to insert some database data as fields in a odt file, but when you change data in phpmyadmin I get 1) a correct update in the data source view above the text, 2) not in the odt file (body: where are the fields): the fields texts remain unchanged, &hellip; <\/p>\n<p class=\"link-more\"><a href=\"https:\/\/digitalia.culturanuova.net\/blog\/?p=1456\" class=\"more-link\">Leggi tutto<span class=\"screen-reader-text\"> &#8220;embed database data in odt file&#8221;<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[565],"tags":[112,113,114,39,115],"class_list":["post-1456","post","type-post","status-publish","format-standard","hentry","category-office","tag-database","tag-embed-database","tag-fields","tag-librewriter","tag-odt"],"_links":{"self":[{"href":"https:\/\/digitalia.culturanuova.net\/blog\/index.php?rest_route=\/wp\/v2\/posts\/1456","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/digitalia.culturanuova.net\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/digitalia.culturanuova.net\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/digitalia.culturanuova.net\/blog\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/digitalia.culturanuova.net\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1456"}],"version-history":[{"count":2,"href":"https:\/\/digitalia.culturanuova.net\/blog\/index.php?rest_route=\/wp\/v2\/posts\/1456\/revisions"}],"predecessor-version":[{"id":1963,"href":"https:\/\/digitalia.culturanuova.net\/blog\/index.php?rest_route=\/wp\/v2\/posts\/1456\/revisions\/1963"}],"wp:attachment":[{"href":"https:\/\/digitalia.culturanuova.net\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1456"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/digitalia.culturanuova.net\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1456"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/digitalia.culturanuova.net\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1456"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}