News Feed
Jobs Feed
Sections




News Archive
Looking for more information on how to do PHP the right way? Check out PHP: The Right Way

Raphael Stolt's Blog:
Transforming data centered XML into SQL statements
May 08, 2007 @ 10:27:00

In this new post on Raphael Stolt's blog, he shows a way that you can take XML that holds SQL information (in his example INSERTs and DELETEs) and transforms them into SQL statements via XSL stylesheets.

A canny data import technique that emerged from praxis, while working on the import of data-centered XML resources, is utilitizing the abilities of Xslt. The generation of the required SQL statements actually only needs a simple Xsl stylesheet which might import for an PHP XSLTProcessor object or pass to the xsltproc command line tool. Both further described approaches are based upon the libxslt library and are assuming the use of XSLT 1.0.

He starts with an example bit of XML that has the XSL stylesheet at the top that will be used to transform the data and the information to perform inserts on several "partner" values in the XML below. Following this, he creates a PHP class to load the file and apply the stylesheet.

He also mentions a few different approaches to the same problem - XSLTProcessor class approach returning a single SQL string , xsltproc approach and the XSLTProcessor class approach using the ability to use PHP functions as XSLT functions.

0 comments voice your opinion now!
transform xml sql statement xslt insert delete transform xml sql statement xslt insert delete


blog comments powered by Disqus

Similar Posts

Sameer Borate's Blog: Splitting large MySQL dump files

PHPWACT.org: Handling UTF-8 with PHP

Community News: Serendipity 1.1.3 and 1.2-beta2 released due to SQL exploit

DevShed: An Introduction to Building Proxy Classes with PHP 5

Builder.com: Dynamic XML document construction with the PHP DOM


Community Events











Don't see your event here?
Let us know!


project framework security example component facebook package composer podcast application language performance introduction unittest hack install symfony2 hhvm release database

All content copyright, 2014 PHPDeveloper.org :: info@phpdeveloper.org - Powered by the Solar PHP Framework