{"type":"rich","version":"1.0","provider_name":"phorkie","provider_url":"https:\/\/p.cweiske.de\/","title":"MySQL: Read and write values from XML (e.g. TYPO3 FlexForm) \u00b7 GitHub","author_name":"Christian Weiske","cache_age":86400,"width":900,"height":900,"html":"<!-- embedding all files of https:\/\/p.cweiske.de\/642 -->\n<link rel=\"stylesheet\" href=\"https:\/\/p.cweiske.de\/css\/embed.css\"\/>\n<div class=\"phork\" id=\"642\">\n    <div class=\"phork-file\">\n <div class=\"phork-content\">\n  <div class=\"code\"><pre class=\"txt\"># Read: Show real path in sys_file_storage\nselect name, uid, ExtractValue(configuration, '\/\/T3FlexForms\/data\/sheet[@index=&quot;sDEF&quot;]\/language\/field[@index=&quot;basePath&quot;]\/value') path from sys_file_storage where uid &gt; 0 \n\n# Write: Set a new value (in this case a detail pid) in FlexForm of a tt_news plugin\nUPDATE tt_content SET pi_flexform = UpdateXML(pi_flexform, '\/\/T3FlexForms\/data\/sheet[@index=&quot;s_misc&quot;]\/language\/field[@index=&quot;PIDitemDisplay&quot;]\/value', CONCAT('&lt;value index=&quot;vDEF&quot;&gt;', 123, '&lt;\/value&gt;' )) WHERE uid=11107<\/pre><\/div>\n\n <\/div>\n <div class=\"phork-meta\">\n  <a href=\"https:\/\/p.cweiske.de\/642\/rev-raw\/33187832bdcfdf72f741112006ad44ba9055e96e\/MysqlXml.txt\" style=\"float: right\">view raw source<\/a>\n  <a href=\"https:\/\/p.cweiske.de\/642#MysqlXml.txt\">MysqlXml.txt<\/a>\n <\/div>\n<\/div>\n<\/div>\n"}