rich1.0phorkiehttps://p.cweiske.de/MySQL: Read and write values from XML (e.g. TYPO3 FlexForm) ยท GitHubChristian Weiske86400900900<!-- embedding all files of https://p.cweiske.de/642 -->
<link rel="stylesheet" href="https://p.cweiske.de/css/embed.css"/>
<div class="phork" id="642">
<div class="phork-file">
<div class="phork-content">
<div class="code"><pre class="txt"># Read: Show real path in sys_file_storage
select name, uid, ExtractValue(configuration, '//T3FlexForms/data/sheet[@index="sDEF"]/language/field[@index="basePath"]/value') path from sys_file_storage where uid > 0
# Write: Set a new value (in this case a detail pid) in FlexForm of a tt_news plugin
UPDATE tt_content SET pi_flexform = UpdateXML(pi_flexform, '//T3FlexForms/data/sheet[@index="s_misc"]/language/field[@index="PIDitemDisplay"]/value', CONCAT('<value index="vDEF">', 123, '</value>' )) WHERE uid=11107</pre></div>
</div>
<div class="phork-meta">
<a href="https://p.cweiske.de/642/rev-raw/33187832bdcfdf72f741112006ad44ba9055e96e/MysqlXml.txt" style="float: right">view raw source</a>
<a href="https://p.cweiske.de/642#MysqlXml.txt">MysqlXml.txt</a>
</div>
</div>
</div>