Exporting Database Records To XML
As the web moves to an XML-based paradigm, one of the most common problems faced by developers involves converting legacy data, usually stored in a database, into corresponding XML data. With this in mind, let’s look at some practical examples that demonstrate how data stored in an SQL-compliant database system can be converted into well-formed XML.
Note that the code listings in this section assume the existence of a MySQL database and a familiarity with PHP’s database access functions (specifically, its MySQL functions). In case you don’t already have MySQL, you can download it from http://www.mysql.com/, and SQL dump files for the database tables used in this section may be obtained from this book’s companion ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access