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 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php