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

Daniel Cousineau: Using Symfony Console From Scratch

Stoyan Stefanov's Blog: Text_Highlighter 0.7.1 and hiliteme.com updates

Ibuildings techPortal: Transforming XML with PHP and XSL

PHPMaster.com: Maven and PHP

Joshua Eichorn's Blog: Slides from azPHP presentation of PEAR: An Introduction


Community Events

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


performance framework opinion configure release example php7 voicesoftheelephpant language podcast laravel introduction interview api conference library application community series symfony2

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