RE: [xsl] XSL generating PHP/MySQL

Subject: RE: [xsl] XSL generating PHP/MySQL
From: "Joe Fawcett" <joefawcett@xxxxxxxxxxx>
Date: Thu, 27 Sep 2007 20:36:13 +0100
Riku

Probably your variable is out of scope. Was it decalred in a different template?

Joe

http://joe.fawcett.name


From: Riku Riikonen <riku.riikonen@xxxxxx>
Reply-To: xsl-list@xxxxxxxxxxxxxxxxxxxxxx
To: xsl-list@xxxxxxxxxxxxxxxxxxxxxx
Subject: [xsl] XSL generating PHP/MySQL
Date: Thu, 27 Sep 2007 22:28:07 +0300

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

Current Thread