News Feed
Sections




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

IBM developerWorks:
Turn SQL into XML with PHP
July 25, 2007 @ 09:21:00

On the IBM developerWorks site today, there's a new tutorial by Vikram Vaswani walking through the use of the XML_Query2XML PEAR package to pull data from your SQL database and push it into an XML structure.

Ever wished for an easy way to transform SQL result sets into XML? It's a PEAR package named XML_Query2XML, and it provides a comprehensive framework to efficiently turn the results of a database query into a customizable XML document. This article introduces the package, and demonstrates useful real-world applications, including using it with XSL and XPath, combining it with data from external Web services, and creating database dump files.

They go through the installation and the steps to create the XML:

  • Convert SQL to XML
  • Transform XML output with XSL
  • Customize XML output
  • Work with SQL joins
  • Filter SQL records with XPath
  • Merge data from multiple sources
  • Create database backups

Check out the full tutorial for an excellent guide to using this powerful PEAR package.

0 comments voice your opinion now!
pear xmlquery2xml xsl xpath join install backup pear xmlquery2xml xsl xpath join install backup


blog comments powered by Disqus

Similar Posts

PHPWomen.org: Bundled go-pear.phar broken in 5.2 windows releases

Zend Developer Zone: Reading and Writing Spreadsheets with PHP

Wb Developer Juice: 10 baby steps to install Memcached Server and access it with PHP

Manfred Webber's Blog: PHP and Flex - Part III

Richard Davey's Blog: WAMP Guide updated for PHP 5.2.3


Community Events





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


series list deployment release laravel framework zendserver community api podcast bugfix developer introduction symfony language interview voicesoftheelephpant tips conference library

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