From what I see, there isn't an XSLT variable named $index anywhere in
the stylesheet; I take it $index is supposed to be a PHP variable in the
result document? In that case, the problem is here:
<xsl:value-of select='concat("replace into table (index,variable) values
('",$index,"','",$variable,"')")' />
In there, you're telling it to concat (XSLT) variable $index, but in
other places you're outputting "$index" as text. (the first case) Is it
a PHP variable or an XSLT variable? Make up your mind, and amend your
stylesheet to follow suit.
Also, your code hurts my eyes. :P
~ Scott
-----Original Message-----
From: Joe Fawcett [mailto:joefawcett(_at_)hotmail(_dot_)com]
Sent: Thursday, September 27, 2007 2:36 PM
To: xsl-list(_at_)lists(_dot_)mulberrytech(_dot_)com
Subject: RE: [xsl] XSL generating PHP/MySQL
Riku
Probably your variable is out of scope. Was it decalred in a different
template?
Joe
http://joe.fawcett.name
From: Riku Riikonen <riku(_dot_)riikonen(_at_)uta(_dot_)fi>
Reply-To: xsl-list(_at_)lists(_dot_)mulberrytech(_dot_)com
To: xsl-list(_at_)lists(_dot_)mulberrytech(_dot_)com
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='20'</xsl:text>
</xsl:when>
<xsl:otherwise>
<xsl:text>$index='0';</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
('",$index,"','",$variable,"')")'
/><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>
--~--
--~------------------------------------------------------------------
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>
--~--
--~------------------------------------------------------------------
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>
--~--