xsl-list
[Top] [All Lists]

[xsl] XSL generating PHP/MySQL

2007-09-27 12:28:37
Hello

I'm pushing xml through xsl and trying to have php code.

Can anyone help and tell me what i'm doing wrong in my xsl? (here comes just the problematic part)



<xsl:choose>
        <xsl:when test="CASE1">
                                        
                <xsl:text>
mysql_query("</xsl:text><xsl:value-of select='concat("SET ","@","index=LAST_INSERT_ID()")' /><xsl:text>");
                $index="@index";</xsl:text>
        </xsl:when>
                        
        <xsl:otherwise>
                <xsl:choose>
                        <xsl:when test="CASE2">
                                <xsl:text>$index=&apos;20&apos;</xsl:text>
                        </xsl:when>
                        <xsl:otherwise>
                                <xsl:text>$index=&apos;0&apos;;</xsl:text>
                        </xsl:otherwise>
                </xsl:choose>
        </xsl:otherwise>
</xsl:choose>
<xsl:text>
</xsl:text>

<xsl:text>mysql_query("</xsl:text><xsl:value-of select='concat("replace into table (index,variable) values (&apos;",$index,"&apos;,&apos;",$variable,"&apos;)")' /><xsl:text>");</xsl:text>



After XSLT process i is said that variable index has not been declared. Variable called variable has been declared elsewhere.

I tried to use following
<xsl:variable name="index">$index</xsl:variable>
, but it didn't work.

Can anyone help me out?

BR
Riku

--~------------------------------------------------------------------
XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list
To unsubscribe, go to: http://lists.mulberrytech.com/xsl-list/
or e-mail: <mailto:xsl-list-unsubscribe(_at_)lists(_dot_)mulberrytech(_dot_)com>
--~--

<Prev in Thread] Current Thread [Next in Thread>