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