ctan wrote: > The XML would be something like this... > > <?xml version="1.0" encoding="UTF-8"?> <snip xml>
Just noticed something... $line = mysql_fetch_array($result, MYSQL_ASSOC); returns an array. Your $arguments array wants a string. So.. $xml = join($line, ''); $arguments = array('/_xml'=> $xml); Peter > > Hope this helps... > > chia > > -----Original Message----- > From: Peter Clarke [mailto:[EMAIL PROTECTED]] > Sent: 25 July 2002 13:06 > To: Ctan > Cc: [EMAIL PROTECTED] > Subject: Re: Applying XSL to XML with PHP > > > Ctan wrote: > >>I'm trying to apply XSL to XML stored in a MySQL database with PHP. >>How do I go about doing this? I've tried following the example on >>php.net but I seem to run into a lot of trouble. Here's how the code >>looks like (BTW aml is XML stored in the argument Table): >> >> >>if (! empty($searchword )) >> >> $query = "SELECT aml FROM arguments WHERE aml LIKE '%$searchword%'"; >> $result = mysql_query($query) or die ("Query failed"); >> $line = mysql_fetch_array($result, MYSQL_ASSOC); >> >>// Create an array >>$arguments = array('/_xml'=> $line); >> >>//XSL file >>$xsl = "./sheet1.xsl"; >> >>// Create an XSLT processor >>$xslthandler = xslt_create(); >> >>// Perform the transformation >>$html = xslt_process( $xslthandler, 'arg:/_xml', $xsl, NULL, >>$arguments); >> >>// Detect errors >>if (!$html) die ('XSLT processing error: '.xslt_error($xslthandler)); >> >>// Destroy the XSLT processor >>xslt_free($xslthandler); >> >>// Output the resulting HTML >>print $html; >> >> >>What I get on the screen is: >> >> >>Array ( [0] => "With the contents of my variable...") >> >> >>And: >> >> >>Warning: Sablotron error on line 1: XML parser error 2: syntax error >>in /home/httpd/html/ctan/resultworkingcopy2.php on line 93 XSLT >>processing >>error: XML parser error 2: syntax error >> >> >>What gives? I really need to solve this urgent. Thanks... >> >>Chia > > > What is the xml. There may be a content encoding problem or some other > xml issue. > > Peter > > > > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php