Helping ordinary people create extraordinary websites!
| |
Helping ordinary people create extraordinary websites! |
Using PHP 4s DOM XML Functions to Create XML Files from SQL DataBy Tony Marston2005-04-04 
Intended Audience
This tutorial is intended for developers who wish to extract data from a database and insert it into XML files so that it can be processed in some way, usually by transforming it into HTML using an XSL file. This method completely splits the presentation layer (i.e. the generation of HTML documents) from the business layer (the application of business rules using a language such as PHP) so that any one of these layers can be modified without affecting the other. In the samples below the code is generic in that no column names are ever hard coded. Data is retrieved from the database as an associative array (a series of 'name=value' pairs), and every element of the array is extracted and transferred to the XML file. The contents of the associative array are therefore governed entirely by the SQL 'select' statement. In the samples below I will show how to deal with data from a single table, and then data from two tables with a one-to-many relationship. Finally I will show how to insert additional data in the form of XML attributes. Tutorial Pages: » Intended Audience » Prerequisites » Multiple occurrences of a single table » A One-to-Many relationship » Adding optional attributes » Using Multi-Byte Characters » Conclusion » References
|
 |