https://doc-en-mirror.openflyers.com/index.php?action=history&feed=atom&title=Tricks-and-tips 2026-05-01T08:34:04Z Revision history for this page on the wiki MediaWiki 1.39.6 https://doc-en-mirror.openflyers.com/index.php?title=Tricks-and-tips&diff=189&oldid=prev 2024-08-12T18:53:08Z

<p>Text replacement - &quot;&lt;xml&gt;&quot; to &quot;&lt;syntaxhighlight lang=&quot;xml&quot;&gt;&quot;</p> <p><b>New page</b></p><div>=SQL=<br /> ==Permut two rows according to their id==<br /> Goal: permut two rows with id=a and id=b using only one query<br /> &lt;syntaxhighlight lang=&quot;sql&quot;&gt;UPDATE some_table SET id = a + ABS(id - b) WHERE order_num in (a , b)&lt;/sql&gt;<br /> =XSLT=<br /> ==Permit php function call==<br /> &lt;syntaxhighlight lang=&quot;xml&quot;&gt;<br /> &lt;xsl:stylesheet xmlns:xsl=&quot;http://www.w3.org/1999/XSL/Transform&quot;<br /> xmlns:xhtml=&quot;http://www.w3.org/1999/xhtml&quot;<br /> version=&quot;1.0&quot; <br /> xmlns:php=&quot;http://php.net/xsl&quot;<br /> exclude-result-prefixes=&quot;xhtml php&quot;&gt;<br /> &lt;/xml&gt;<br /> Do not forget '''exclude-result-prefixes=&quot;php&quot;''' otherwise you will have xmlns:php attribute in your root tag!<br /> then:<br /> &lt;syntaxhighlight lang=&quot;xml&quot;&gt;&lt;xsl:value-of select=&quot;php:functionString('phpFunctionName', //something/forexample)&quot;/&gt;&lt;/xml&gt;</div>

imported>Claratte